Create a data table
- Architect > Data Table > All permission
- To add a data table: Architect > Data Table > Add
- To delete a data table: Architect > Data Table > Delete
- To add a data table row: Architect > Data Table > Add Row
- To delete a data table row: Architect > Data Table > Delete Row
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 .
- In the Name box, type a meaningful, unique name for the data table.
- (Optional) In the Notes 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.[/bs_well]
- Click Add Field 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 8 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 9 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 10 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 11 for each additional text field you want to add.
- Click Save.
- Click Admin.
- Under Architect, click Data Tables.
- Next to the table you want to open, click More and from the menu that appears, click Open Table.
- 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. Alternatively, to save this row and add another row, click Save and Add Another.