Adding/Deleting Tables on an App Form
App forms come with a feature to create tables, which allow app users to add rows as needed when they enter data.
Tables are useful for managing multiple data entries in a single record.
For instance, you can create a table in an order management app, and use as many table rows as necessary to enter different products and quantities based on each customer order.
Adding a table on the app form
To create a table on your app form, first place a "Table" field by dragging and dropping the "Table" field from the list of fields onto the app form, and then drag and drop the fields you want to include in the table one by one.
You can set a name and field code for each created table.
In the procedure below, you will set a table name and field code in Step 5 to Step 8, that is, after placing fields inside the table. However, it is also possible to set these items before you begin placing fields inside the table or while you are placing them.
-
Click the App Settings icon (the gear-shaped icon) at the upper right of the "View" screen.
-
On the "App Settings" screen, click Form tab.
-
Place a "Table" field on the app form.
-
Drag and drop the fields you want to include in the table one by one. Fields are placed inside the table, and a guidance that tells you how to add more fields on the table appears.
-
Click Settings displayed under the Settings icon (the gear-shaped icon) at the upper right of each field and configure the settings for each field placed inside the table.
-
Click Table Settings under the Table Settings icon (the gear-shaped icon at the upper right of the table).
-
Enter a name in the Table name section.
If you want to hide the table name, select Hide table name. You may prefer to hide the name when, for example, you plan to use a "Label" field to display a formatted table name. -
As necessary, click the Edit icon under Field Code and enter a field code for the table.
-
Click Save on the "Table Settings" screen.
-
When you have finished configuring the form settings, click Save Form at the upper left of the screen.
When the form is saved, the guidance that tells you how to add more fields on the table disappears. -
Click Update App at the upper right of the screen.
-
On the confirmation dialog, click Update App.
Deleting a table on the app form
The following are the steps to delete a table.
-
Click the App Settings icon (the gear-shaped icon) at the upper right of the "View" screen.
-
On the "App Settings" screen, click Form tab.
-
Move your cursor to the Table Settings icon (the gear-shaped icon at the upper right of the table), then click Delete.
-
Click Delete on the confirmation dialog box.
-
Click Save Form on the upper left side of the screen.
-
Click Update App at the upper right of the screen.
-
On the confirmation dialog, click Update App.
Table-related actions available after the app is updated
The following are the actions you can perform on a table after you add it on the app form and update the app.
-
Changing the position of the entire table on the app form
-
Adding fields to the table / deleting fields inside the table
Note that it is not possible to move fields that are already in use into the table nor to move fields inside the table out of the table or into other tables. -
Changing the ordering of fields inside the table
Points to note when setting conditions that use values in a table
When you set conditions that use values in a table, note the following:
- When specifying field values in a table as a condition for filtering records to be displayed in a view
If any of the table rows in a record meets the filter condition, the record is displayed in the filtered result.
Configuring Views - When specifying field values in a table as a condition for sending notifications from an app
- Per Record Notifications
A notification is sent when any of the table rows meets the condition. However, the notification is not sent if any of the other table rows has already met the condition.
Per Record Notifications: Setting up Notifications Sent When a Record Meets a Certain Condition - Reminder Notifications
A reminder is sent every time a table row meets the condition.
Reminder Notifications: Setting Reminder Notifications with Date and Time Conditions - Conditions in the Permissions for Records setting
The permission setting is applied to a record if it contains any table rows that meet the condition.
Configuring Permissions for Records
- Per Record Notifications
How to add or delete table rows when adding or editing a record
You can add or delete table rows on each record.
-
Navigate to the "New Record" screen or the "Edit Record" screen of an app.
Adding Records
Editing Records -
Use the plus and minus buttons on the right side of the table to add or delete table rows.