Adding/deleting tables on an app form

Article Number:040555

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.

  1. Click the App settings icon (the gear-shaped icon) at the upper right of the View screen.
    スクリーンショット:[アプリを設定]アイコンが枠線で強調されている

  2. On the App settings screen, click the Form tab.

  3. Place a Table field on the app form.
    スクリーンショット:[テーブル]フィールドを配置している

  4. Drag and drop the fields you want to include in the table one by one.
    アニメーション:[テーブル]に含めるフィールドを配置している

    When you place a field inside the table, an area for adding another field will appear along with text telling you how to do so.

  5. 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.
    スクリーンショット:フィールドの設定メニューを表示している

  6. Hover your cursor over the top right of the Table field. When the Settings icon (the gear-shaped icon) appears, click Table settings.
    スクリーンショット:[テーブル]の設定メニューの[テーブルの設定]を枠線で強調している

  7. Enter a table name.
    If you want to hide the table name, select Hide table name. You may prefer to hide the name if, for example, you want to use a  Label field to display a formatted table name.
    スクリーンショット:[テーブル名]を入力している

  8. If necessary, click the Edit icon under Field code and enter a field code for the table.
    スクリーンショット:[テーブルの設定]ダイアログで[フィールドコード]の[編集]アイコンをクリックしてフィールドコードを変更している

  9. Click Save.

  10. 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 disappear.

  11. Click Update app at the upper right of the screen.

  12. On the Update app dialog, click Update app.

Deleting a table on the app form

The following are the steps to delete a table.

  1. Click the App settings icon (the gear-shaped icon) at the upper right of the View screen.
    スクリーンショット:[アプリを設定]アイコンが枠線で強調されている

  2. On the App settings screen, click the Form tab.

  3. On the Form settings screen, hover your cursor over the Settings icon (the gear-shaped icon) at the upper right of the field you want to delete, then click Delete.
    スクリーンショット:[削除]を枠線で強調している

  4. On the Delete table dialog, click Delete.

  5. Click Save form on the upper left side of the screen.

  6. Click Update app at the upper right of the screen.

  7. On the Update app dialog, click Update app.

Table-related actions available after the app is updated

The following are actions you can perform on a table after you add it on the app form and update the app.

  • Change the position of the entire table on the app form
    アニメーション:[テーブル]の位置を移動している

  • Add or delete fields in the table
    Note that is not possible to move fields that are already in-use into a table. It is also not possible to move fields inside a table out of the table or into other tables.
    アニメーション:[テーブル]にフィールドを追加している

  • Change the ordering of the 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, make sure to note the following information.

How to add or delete table rows when adding or editing a record

You can add or delete table rows on each record.

  1. Navigate to the New record screen or the record editing screen in your app.

  2. To add a row, click the Add row icon (the plus sign-shaped icon).
    To delete a row, click the Delete row icon (the minus sign-shaped icon).
    スクリーンショット:[テーブル]フィールド内の右端に行を追加または削除するアイコンが表示されている