Table view

Create, filter, and edit records in rows and columns.

Use a Table view to work with records in rows and columns. This is the default view for a new table and provides a broad choice of features.

In Table view you can:

• Use Hide columns or x hidden columns to show or hide columns.
• Use Filter to show only the records you need.
• Turn on Inline Editing to edit data directly in the table view, like in a spreadsheet.
• Use Import/export to work with data from this view.

You can also change table columns directly by clicking the column title. In the menu, you can choose:

• Rename column
• Duplicate column
• Insert column left or right
• Sort in ascending or descending order
• Aggregation, depending on the data type, which you can display in the footer with Show footer
• Conditional formatting
• Hide column

Use the + button in the last column header to:

• + New data field Create a new data field in the current table. The field is also added to the form view.
• ƒx Add calculated column Open the Logic editor and enter plain text or logic to gather and display data from your app.

  The script is saved only in this table view column.
• Select an existing field that is currently hidden in the table view. Use Search above the displayed fields to find it.

Avoid large, performance-intensive scripts in the calculated column. The script runs in every row each time the view opens, which can slow down daily work.

The script of the calculated column is deleted if you delete the column or the whole view.