Adding Tables
Last updated 22/02/2022
Creating Tables in Five
Five gives you two methods to create tables.
Table Form - The Table form gives you more extensibility to build your tables.
Table Wizard - Five's Table Wizard will guide you through a step-by-step process to input the configurations for your tables in a systematic order and subsequent steps will rely on information entered in previous steps. Five will compute the appropriate path and route you accordingly.
The following documenation will explain how to add a table with fields and a primary index.
Accessing Tables
Requirement
The Developer or Control role is required to create, read, update, and delete a table.
Steps
Select the required Application in the list.
Click the Down Button in the form app bar.
Select Tables in the menu.
Create a Table With Fields and a Primary Index
Click the Add Item button in the list app bar.
Type a name in the Table ID field.
Click the Fields tab.
Click the Add Fields button.
Type a name in the Field ID field.
Click the lookup icon in the Data Type field and select a data type.
tip
It is good practice to make your first field your primary key field. In Five, you can use a Globally Unique Identifier (GUID) data type to uniquely identify each record in
the table. A GUID is a 128-bit globally unique ID. The data size we use in Five for a GUID is 36
.
Click the Required switch to a true state.
Type a data size in the Size field.
Click the lookup icon in the Default Display Type and select a default display type.