specs/routes/R_TBLE
Table Editor
Overview
The Table Editor allows the user to view and edit a Tulip Table as well as view, create, edit, and deactivate its fields and records.
Tulip Tables are database tables that can be used in apps to provide real-time synchronized access to records. Changes to records through apps, the Table Editor, or any other interface are immediately propagated to all connected clients.
The contents of a Tulip Table can be exported from the Table Editor in the form of a CSV file containing rows for each record.
Model/Page Connections
Edit
- A user can edit the name and description of a Tulip Table by selecting the "Edit Table Info" option in the overflow menu of the subheader, “...”.
- A user can edit the fields and records of a table from this page.
View
- A user can view the name of a Tulip Table in the subheader in the top left of the page.
- A user can view the description of a Tulip Table by clicking on a button with an "i" icon to the right of the table name.
- A user can view the fields and records of a Tulip table in the body of the page.
Create
- A user can create table fields by:
- Clicking the plus ("+") icon at the top of the main table view, to the right of any existing fields. A menu opens that allows the user to specify the new field's data type and label.
- Clicking the caret symbol on any column and choosing 'Insert Left/Right'
- A user can create a field in a different Table by creating a Linked Record field. After pressing the "+" icon to create a new field, the user can select "Linked Record" and then will be allowed to choose the same Table or a separate table, and then create a new field in that Table before pressing "Save".
Edit
- A user can edit the label of a field by clicking the caret to the right of the field's header cell, and selecting the "Edit field" option in the dropdown menu.
- A user can edit the description of a field by clicking the caret to the right of the field's header cell, and selecting the "Edit description" option in the dropdown menu.
View
- A user can view the fields of a table in the header row of the table view, located below the page's subheader and above the list of records. Each header cell shows an icon representing the data type of the field to the left, the label of the field next to the type icon, and if a description is present, an "i" icon that displays the description when hovered over.
- A user can view deactivated fields by selecting the "View Archived Fields" option in the overflow menu of the subheader, “...”. These are fields that have been deactivated since the table was initially created.
- A user can view metadata fields (e.g. date created, date updated) by selecting the "View Metadata Fields" option in the overflow menu of the subheader.
Archive
- A user can archive a field by clicking the caret to the right of the field's header cell, and selecting the "Archive Field" option in the dropdown menu.
- A user can restore archived fields by selecting the "View Archived Fields" option in the overflow menu of the subheader, and clicking a field's "Restore" button.
Create
- A user can create table records by clicking the "Create Record" button in the subheader.
- A user can create up to 10,000 records at a time by importing a CSV. Each row in the CSV will be one new record. In order to import rows from a CSV, the user must click the "..." menu in the top right of the screen and then choose the "Import data from CSV file" option. This functionality is only available for Cloud customers.
Datetime Formatting for CSV import
A variety of formats for dates and times including the ISO8601 and RFC 2822 standards is supported for CSV import.
The following general rules apply:
- Besides the two standards, the distinction between month-day-year (MDY) and day-month-year (DMY) formats is done via the separator
- MDY is using
/as a separator - DMY is using
.as a separator
- MDY is using
- Both single digit and double digit numbers are allowed for all formats. Mixing is also possible. This means the following two examples will both be valid and imported equally:
09/05/2023 08:04:03 PM9/5/2023 8:4:3 PM
- The
Aandastand forAMorPMandamorpm - For most formats there is an option with and without time zone
- The timzone should be added with double digits and a leading
+or- - Example:
+02:00
- The timzone should be added with double digits and a leading
The list of supported datetime formats is below:
| Type | Without time zone | With time zone |
|---|---|---|
| MDY, with seconds, 12h, AM/PM | M/D/YYYY h:m:s A | M/D/YYYY h:m:s A Z |
| MDY, with seconds, 12h, am/pm | M/D/YYYY h:m:s a | M/D/YYYY h:m:s a Z |
| MDY, with seconds, 24h | M/D/YYYY H:m:s | M/D/YYYY H:m:s Z |
| MDY, without seconds, 12h, AM/PM | M/D/YYYY h:m A | M/D/YYYY h:m A Z |
| MDY, without seconds, 12h, am/pm | M/D/YYYY h:m a | M/D/YYYY h:m a Z |
| MDY, without seconds, 24h | M/D/YYYY H:m | M/D/YYYY H:m Z |
| MDY, text month, with seconds, 24h | MMM/D/YYYY H:m:s | MMM/D/YYYY H:m:s Z |
| DMY, with seconds, 24h | D.M.YYYY H:m:s | D.M.YYYY H:m:s Z |
| DMY, without seconds, 24h | D.M.YYYY H:m | D.M.YYYY H:m Z |
| MDY, date only | M/D/YYYY | M/D/YYYY Z |
| DMY, date only | D.M.YYYY | D.M.YYYY Z |
| L LTS (localized date and format string) | L LTS | L LTS Z |
| ISO8601 | - | YYYY-MM-DDTHH:mm:ssZ |
| RFC 2822 | - | ddd, DD MMM YYYY HH:mm:ss ZZ |
Edit
- A user can edit table records by clicking on a cell of a table record.
- A user can edit multiple table records at once by uploading a CSV where the ID value of each row matches an existing row within the Table. This allows the user to update all values of a row except the ID in bulk. In order to mass update rows via a CSV, the user must click the "..." menu in the top right of the screen and then choose the "Import data from CSV file" option. This functionality is only available for Cloud customers.
View
- A user can view table records in a table view in the body of the page. Each row contains the data for a record.
- A user can view multiple pages of records by clicking on the numbered pagination buttons at the bottom of the page.
- A user can sort the table view by clicking the caret to the right of a field's header cell, and selecting one of the "Sort..." options in the dropdown menu.
- Text wrapping for the table can be toggled from the "..." menu
Delete
- A user can delete table records by clicking on a cell of a table record, and then clicking the "Delete" button in the bottom left of the resulting menu. The history of the record is persisted in the backend and can be accessed by creating a record with the same ID and viewing it in the Record History Widget.
Create
- A user can create a new Table Query by selecting the "Queries" button in the top right of the page and then pressing "Create New Query".
View
- A user can view all existing Table Queries by selecting the "Queries" button in the top right of the page and then viewing the list of all existing queries.
Create
- A user can create a new Table Aggregation by selecting the "Aggregations" button in the top right of the page and then pressing "Edit" in the bottom right of the resulting modal. After that, they must enter a name, choose a calculation type and select a field.
Edit
- A user can edit an existing Table Aggregation by pressing "Edit" in the Table Aggregations modal. Then, they can modify the name, calculation type and field of any existing Aggregation.
Deactivate
- A user can deactivate an existing Table Aggregation by pressing "Edit" in the Table Aggregations modal. Then, they can press the trash icon to remove the aggregation from the list.
View
- A user can view all existing Table Aggregation by selecting the "Aggregations" button in the top right of the page and then viewing the list of all aggregations that are attached to the Table.
View
- A user can view and search through a list of users when selecting a user value for a record being edited.
Pages
This page can be accessed from the following pages:
User Permissions
Table editing, table field creation/editing/deletion, and table record creation/editing/deletion may be restricted based on the user's role.
Tests
| ID | Name |
|---|---|
| QA-T83 | Table Management : 04 - Edit a table's name and description |
| QA-T84 | Table Management : 05 - Add columns to a table |
| QA-T85 | Table Management : 06 - Edit a table column |
| QA-T86 | Table Management : 07 - Edit a table column description |
| QA-T87 | Table Management : 08 - Delete a table column |
| QA-T88 | Table Management : 09 - Restore a deleted table column |
| QA-T89 | Table Management : 10 - Reorder table columns |
| QA-T90 | Table Management : 11 - Resize table columns |
| QA-T92 | Table Management : 12 - Create table records from the table detail page |
| QA-T93 | Table Management : 13 - Sort table records by column in table view |
| QA-T94 | Table Management : 14 - Load multiple pages of table records in table view |
| QA-T104 | Record Placeholders : 03 - View the table for a record placeholder |
| QA-T133 | Record Placeholders : 07 - Delete Table Record |
| QA-T245 | Embedded Tables : 05 - Handle deleted fields in embedded tables |
| QA-T397 | Table Links : 01 - Creating Table Links |
| QA-T398 | Table Links : 02 - Linking Records via Details Page |
| QA-T399 | Table Links : 03 - Linking Records via App Triggers |
| QA-T400 | Table Links : 04 - Deleting Linking Columns |
| QA-T464 | Tables CSV Import : 01 - Import to table |
| QA-T466 | Tables CSV Import : 02 - Import feature data handling |
| QA-T467 | Tables CSV Import : 03 - Import from export |
| QA-T570 | Table Queries : 01 - Create, Edit, Delete a Query |
| QA-T571 | Table Queries : 02 - Query Configuration |
| QA-T572 | Table Queries : 03 - Create, Edit, Delete an Aggregation |
| QA-T573 | Table Queries : 04 - Aggregation Configuration |
| QA-T595 | Table Queries : 08 - Editing and Deleting Queries, Aggregations in Published and Development Version Apps |
| QA-T700 | Table Queries : 02 / Query for an Archived Field |
| QA-T701 | Record Placeholders : 07 / Attempting to Delete a Loaded Table Record |
| QA-T702 | Table Management : 05 / Table Columns must be named |
| QA-T703 | Table Queries : 07 - Unique value aggregation |
| QA-T705 | Table Management : 06 / Table Columns labels cannot be blank and ID column type cannot be modified |
| QA-T715 | Table Management : 04 / Cannot leave table name blank on edit |
| QA-T716 | Table Management : 12 / Table Record Data Validation |
| QA-T721 | Table Queries : 03 / Can't edit a saved Aggregation without clicking 'Edit' |
| QA-T814 | Table Links : 05 - Linking Records via App Triggers |
| QA-T927 | Table Analytics - Filtering by 'Date Range' settings |
Requirements
| ID | Requirement |
|---|---|
| PLAT-8946 (806) | All records shall be Enduring, ie. stored, managed, accessible and unalterable for the full retention period. |