Create a data table
- Architect > Datatable >All permissions
- To add a data table: Architect > Datatable > Add
- To delete a data table: Architect > Datatable > Delete
- To add a data table row: Architect > Datatable Row > Add
- To delete a data table row: Architect > Datatable Row > Delete
Create data tables with custom fields that make up the data table schema. For more information about editing and deleting data tables and rows, see Manage a data table.
- Click Admin.
- Under Architect, click Data Tables.
- Click Add . The Create Data Table window appears.
- In the Name box, type a meaningful, unique name for the data table.
- In the Division box, select the division in which you want the data table to belong.
- (Optional) In the Description box, enter any helpful information about the table.
- In the Reference Key Label box, add a descriptive name to describe the purpose or intent of the table’s primary key.
- Click Save. The Data Table view appears.
- Click Add Field under Custom Fields and select one of the following:
- Boolean
- Integer
- Decimal
- String
- To configure a Boolean, or check box, field, do the following:
- In the Field Label box, type a meaningful name for the field.
- To ensure the field appears checked by default, select True by default.
- Repeat step 10 for each additional Boolean field to add.
- To configure an integer field, do the following:
- In the Field Label box, type a meaningful name for the field.
- Enter a default value.
- Repeat step 11 for each additional integer you want to add.
- To configure a number, do the following:
- In the Field Label box, type a meaningful name for the field.
- Enter a default value.
- Repeat step 12 for each additional number you want to add.
- To configure a string, do the following:
- In the Field Label box, type a meaningful name for the field.
- Type a default text value.
- Repeat step 13 for each additional text field you want to add.
- Click Save.
- Click Admin.
- Under Architect, click Data Tables.
- Click the name of the data table that you want to add a table row to. Alternatively, hover over the row of the data table that you want to add a table row to and from the icons that appear, click .
- Click Add .
- Based on the reference key and custom fields you created for the data table, add the information to the fields for the table row.
- Click Save & Close. Alternatively, to save this row and add another row, click Save & Create Another.