Skip to main content

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

  1. Select the required Application in the list.

  2. Click the Down Button in the form app bar.

  3. Select Tables in the menu.

Create a Table With Fields and a Primary Index

  1. Click the Add Item button in the list app bar.

  2. Type a name in the Table ID field.

  3. Click the Fields tab.

  4. Click the Add Fields button.

  5. Type a name in the Field ID field.

  6. 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.

  1. Click the Required switch to a true state.

  2. Type a data size in the Size field.

  3. Click the lookup icon in the Default Display Type and select a default display type.