How to Create a Table

Create a Table in an app form to add rows of fields in a record.

Creating a Table

  1. Within an app, click the Gear wheel Screen_Shot_2017-07-19_at_9.43.03_AM.png on the right.
  2. Navigate to the Form tab.
  3. Drag the desired fields for the table from the left to the form. 
  4. Drag the fields into a single, horizontal row. 
  5. Highlight the row by hovering over it and click on the Gridtable_icon.pngicon on the right.
  6. Click Settings.
  7. Click Set as Table
    • Labels, Related Records, Blank Spaces, Borders, Groups, Record Numbers, Created By, Updated By, Created Datetime, Updated Datetime, and activated fields can NOT be part of tables.
  8. Click Save.
  9. While still in the Form Editor, fields can be added, deleted, and edited in the Table.
  10. Click Save Form and Update App.

Please Note:

  • Once you set a field in a table, you cannot undo it, and the field cannot be moved.
  • Tables cannot be set for the fields to which apps for the operating environment are applied.
  • The following fields cannot be included in tables:
    • Label
    • Related Record
    • Blank space
    • Border
    • Group
    • Record number
    • Created by
    • Updated by
    • Created datetime
    • Updated datetime
  • Once the table is configured, a field can be added or deleted.
  • You can use the automatic calculation feature to total the numeric values of an item in the table. See Automatic Calculation
  • When a CSV/Excel file is used to update the existing records, values in fields that are set in a table cannot be updated.

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 the conditions for filtering and sorting records to be displayed in the record list, if there is a value that matches the set condition in a field in any of the rows in a table, the record to which that value belongs will be filtered and displayed.
  • When setting the conditions for sending notifications from the app
    • Per Record Notifications: A notification is sent if there is a value that matches the set condition in a field in any of the rows in the table. 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 out every time there is a value that matches the set condition in a field in any of the rows in the table.
  • When setting the conditions of Setting Record Permissions, if there is a value that matches the set condition in any of the rows in the table, an access privilege setting is applied to the corresponding record.
 
Was this article helpful?
7 out of 14 found this helpful

Comments

2 comments
  • Has a Matrix type of table ever been considered as an option in Kintone Apps?

  • Hi Heather,

    Thanks for reaching out! I don't believe so, but I'd be happy to mention this as a product request idea!

Please sign in to leave a comment.