Table Editor

Overview

The Table Editor allows the user to view and edit a Tulip Table as well as view, create, edit, and delete 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

Tulip Table

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.

Table Field

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.

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 deleted fields by selecting the "View Deleted Fields" option in the overflow menu of the subheader, “...”. These are fields that have been deleted since the table was initially created.
• A user can view metadata fields (e.g. date created, date updated) by selecting the "View Deleted Fields" option in the overflow menu of the subheader.

Delete

• A user can delete a field by clicking the caret to the right of the field's header cell, and selecting the "Delete Field" option in the dropdown menu.
• A user can restore deleted fields by selecting the "View Deleted Fields" option in the overflow menu of the subheader, and clicking a field's "Restore" button.

Table Record

Create

• A user can create table records by clicking the "Create Record" button in the subheader.

Edit

• A user can edit table records by clicking on a cell of a table record.

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.

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.

User

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:

• Tables
• App Editor

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