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.
Example of a table

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

  1. Open the app settings page.
    Opening App Settings Page

  2. On the screen to set forms, place a table on the form. Place a table

  3. Add fields you want to include one at a time using drag and drop operation. Place fields When the fields are placed, a guide for adding fields appears for the table.

  4. Configure each field you placed in the table, using Settings in the settings menu Gear icon. Set a table

  5. Click Table Settings from Table settings menu Gear icon located at the upper right of the table. Set fields in the table

  6. 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. Change table name

  7. Click Edit icon as needed, and enter the field code.
    Change a field code

  8. Click Save on the table setting screen.

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

  10. 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 Change field position in a 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 field position in a table

  • Change the display order of fields in a table Change field position 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.
    • Reminder
      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.