Managing Columns

Create, configure and delete columns to give each table exactly the structure it needs.

Create a column

In the Grid, click + Column. A dialog guides you through the configuration.

Configure a column

Click a column’s name to open its menu:

• Hide removes the column from your view.
• Sort A to Z and Sort Z to A sort the records.
• New Filter creates a filter. See Manage Filters.
• Name / Description changes how the column is labeled.
• Type changes and configures the column type.
• Validation sets validation conditions.
• Background color sets conditional background colors.
• Delete column removes the column.

Move a column

Click the Sort columns icon, the two arrows at the left of the column headers, to change the order of the columns.

Special columns

The first column in a table is always of type ID. It can’t be moved or deleted, but it can be renamed and hidden.

By default, columns of type Modified and Created are placed last in a table. You can move, rename, hide and remove them.