Adding Tables into Forms
Forms in apps provide "Table" function to add rows as needed while entering data.
Tables are useful to manage multiple data entries in one record.
For example, in an Order Management app, you can enter different product names and the numbers of orders for each customer, by just adding rows as required.
Steps to Add Tables into Forms
To create a table, choose a table from field list and place it, and then add fields you want to include one at a time using drag and drop operation.
You can also specify a table name and the field codes to a table.
In this section, a table name and the field codes are configured in step 5 through 8 after placing fields, although you can configure them before or during placing fields.
Click the app setting button on the upper right of the record view, and select the "Form" tab.
Place a table on the form.
Add fields you want to include one at a time using drag and drop operation. When the fields are placed, a guide for adding fields appears for the table.
Configure each field you placed in the table, by clicking Settings under the setting button .
Click Table Settings from the table setting button on the upper right of the table.
Enter the Table name.
To hide the table name (for example, if you want to apply certain styles in label field), select Hide table name.
Click the edit button as needed, and enter the field code.
Click Save on the table setting screen.
When the form is set, click "Save Form" the upper left side of the screen.
A guide for adding fields disappears when the form is saved.
Click "Update App" on the upper right side of the screen.
Actions Available after Updating Apps
You can perform following actions even after adding tables to a form and saving app.
Move the table
Add/delete fields to the table
* You cannot move the fields in use into a table, or move the fields in a table to outside of the table or to other tables.
Change the display order of fields in a table
Notes on When Setting Conditions Based on Values in a Table
When you set conditions based on values in a table, please note the following:
- When setting conditions for filtering records to be displayed in the record list
The filtered results include records where the value of the field in a row of the table meets the condition.
- When setting the conditions for sending notifications from the app
- Per Record Notifications
The notification is sent when a field value in any of the rows meets the condition. However, a notification is not sent if the set condition was met by a value in a field in another row.
A reminder is sent every time the value of a field in a row of the table meets the condition.
- When setting conditions for record permissions
The permission is applied to the record when the value of a field in a row of the table meets the condition.
- Per Record Notifications