This article covers the day-to-day work with the records inside a data table that already exists: viewing them, adding, editing and deleting rows by hand, and exporting the table to CSV.
Creating a table and defining or changing its columns is separate work, covered in Creating a Data Table. What data tables are for, and the limits that apply everywhere, are on Data Tables.
Opening a table's rows
Open Data Tables in the main navigation and click the table's name in the list. The table's detail page shows its rows.
1. Breadcrumb: Shows which table's rows you are looking at.
2. Edit Schema: Opens the table's columns for editing, covered in Creating a Data Table.
3. + Add Row: Opens the Add New Row panel above the grid.
4. Id: A system column. Every row gets a server-generated Id when it is created. It is never editable and never changes.
5. Your columns: One column per column you defined, in the order of the schema.
6. DateCreated: A system column, stamped when the row is created.
7. DateModified: A system column, empty until the row is edited, so a row that has never been changed shows a dash.
8. Row actions: The edit and delete icons at the end of each row.
9. Total count: The footer under the grid shows the number of rows in the table. The Data Tables list shows the same figure per table in its Total Rows column, alongside a Data Tables Storage bar for the tenant, which is where you check how close a table is to the row and storage limits.
How values are shown
| Column type | How the grid renders it |
|---|---|
| Text, Long Text | The stored text |
| Number | Trailing zeros are trimmed, so a stored 64.90 is shown as 64.9 |
| Boolean | A green tick for True, a red cross for False |
| DateTime | The stored date and time |
| Empty value | A dash |
📝 Note: A dash means the cell holds no value. Leaving a field empty in the Add New Row panel stores NULL, not empty text. When a flow filters on such a column, the Data Table node's is empty condition matches both NULL and empty text on Text and Long Text columns, but only NULL on Number, Boolean and DateTime columns.
Adding a row
Click + Add Row. The Add New Row panel opens full width above the grid, with one input per editable column laid out in a wrapping row.
1. Column name and type chip: Each field carries its column name above it and a small chip naming the column's type: text, longText, number, boolean or dateTime.
2. Inputs: One per editable column. The input you get depends on the column's type:
| Type chip | What you enter |
|---|---|
text |
Free text, up to 200 characters |
longText |
Free text, up to 8,000 characters |
number |
A number; decimal values are accepted |
boolean |
A True / False picker |
dateTime |
A date picker |
3. Cancel and Save: At the right of the panel. Save writes the row, closes the panel and refreshes the grid.
4. Close (×): At the top right of the panel, the same as Cancel. Both discard what you typed without asking.
The three system columns, Id, DateCreated and DateModified, never appear in this panel. On save the new row is given an Id and a DateCreated automatically, and its DateModified stays empty until the row is first edited.
So on a support-ticket table, a row saved with resolutionHours set to 2.50 and isResolved set to True appears in the grid as 2.5, a green tick, a generated Id, today's DateCreated and a dash under DateModified.
Editing a row
Click the edit icon on the row. The same panel opens, titled Edit Row, with the row's current values filled in. Change what you need and click Save.
Saving an edit stamps the row's DateModified, which is what replaces the dash in that column. Id and DateCreated are not touched, so a row keeps the Id it was created with and any flow or agent holding that Id keeps pointing at the same row.
Deleting a row
Click the delete icon on the row and confirm.
⚠️ Warning: Deleting a row is permanent. There is no undo and no recycle bin: the row is removed immediately, and any flow that looks it up by Id stops finding it.
Exporting to CSV
On the Data Tables list, the table's row offers Export CSV, which opens the Export Data Table dialog.
1. Information notice: States that the system columns are left out of the export unless you ask for them.
2. Include system columns (Id, DateCreated, DateModified): Off by default, and off again every time the dialog is opened. Turn it on when you want the system columns in the file, for an audit extract or to reconcile rows against Ids your flow stored. With it on, Id is written as the first column and DateCreated and DateModified as the last two.
3. Buttons: Export produces the file; Cancel closes the dialog without exporting.
The file is written in a fixed, locale-independent format:
| Item | Format |
|---|---|
| Encoding | UTF-8 with a byte order mark |
| Line endings | CRLF |
| Quoting | Minimal, so values are quoted only when they need to be |
| Numbers | Invariant format, so 129.5 regardless of your regional settings |
| Booleans | Lowercase true / false |
| Dates | ISO format |
💡 Tip: Leave Include system columns off for any file you intend to import again. With them in the file, the import reads Id, DateCreated and DateModified as three ordinary columns of your own.
Importing a CSV always creates a new data table, so an export, edit and import round trip gives you a second table rather than updated rows in the first one. To change rows in place, use the Edit Row panel.