Managing Tables

Creating a Custom Table

Custom tables are created by administrators. Go to Administration → Custom tables to open the table constructor. You will see the list of all tables in the application.

Click the New table button, then complete the form:

• Name — the name of the table.
• Projects — select the projects the table should be enabled on.

Submit the form. You are taken to the table, where you can add the custom fields that make up its columns.

Adding Custom Fields

Every custom table starts with one built-in field, Name, which cannot be removed. You build the rest of the table by adding custom fields; each custom field becomes a column.

Open the table from Administration → Custom tables and add a new custom field. Choose the field format, complete its settings, and save. There is no fixed limit on the number of fields, but as a best practice add only the fields you need — the more fields a table has, the longer its views take to load.

Common field formats include text, long text, integer, float, date, boolean, single-value list, key/value list, and user. Reordering fields changes both the column order in the table overview and the order of fields on the new-record form.

Deleting a Custom Table

To delete a table, go to Administration → Custom tables, open the table you want to remove, and delete it. Confirm the deletion if prompted (for example, by typing the table name).