Add a data table to your application from an existing table that you or someone else previously created or from scratch.

Before you begin

Role required: admin, sn_app_eng_studio.user, or delegated_developer

Procedure

  1. Navigate to All > App Engine > App Engine Studio.
  2. From the My Apps page, open your application.
  3. Next to the Data heading, select the Add icon (Add icon).
  4. Select Create a blank table, and then select Continue.
  5. Choose from the following choices.
    OptionDescription
    Create new table Select this option to create a blank table from scratch.
    1. Choose Create new table.
    2. Click Continue.
    Create from an extensible table Select this option to create a new blank table from an existing extensible table in the ServiceNow AI Platform.
    1. Choose Create from an extensible table.
    2. Search for and select an existing table.
      Note: Tables already in the app display first in the list and recommended ServiceNow AI Platform tables display next, along with a short description of the type of information the table stores.
    3. Select Continue.
  6. On the form, fill in the properties of your new table.
    FieldDescription
    Table label Unique label to identify the table.
    Table name Database name for the table. A table name is created automatically after you enter a table label. You can edit the name if needed.
    Make extensible Option to allow other tables to share data from this table. For more information on table extension, see Table extension.
    Auto number Option to track table records with a unique number. If you select this option, define the Prefix, Starting number, and Number of digits.
    Prefix

    Abbreviated name of the table to append to the beginning of the record number. For example, if you are creating a "Laptop" table, then your prefix may be "LPTP" or "LT."
    Starting number

    Number to identify the first record created for your table.
    Number of digits

    Maximum number of digits to allow in the record number. This value determines the highest possible record number. For example, if you enter 7, then the highest possible number is 9999999.
  7. Select Continue.
  8. Control who has access to create, read, write, and delete content from this table by adding new roles and/or defining the desired Create, Read, Write, Delete permissions for existing roles.

    Roles that you create in the table persist throughout the application and can be further defined in other tables you add. See Add application security for more information on how security permissions work.

    Note: At least one role must have read access for you to be able to preview the table.
  9. Select Continue to add the new table.
  10. Return to your application home page or continue editing your table.
    • Select Done to return to your application home page.
    • Select Edit table to review the columns that were added to your table and continue editing it in Table Builder.
  11. If you continue editing, in the new tab that opens, review the table columns.

    Each table column appears as a row in Table Builder.

    A lock icon (Lock icon) appears next to columns from the extended table. You can't modify these columns.

  12. Customize your table by adding table columns.
    1. In Table Builder, select + Add new field.
    2. On the empty row, fill in the fields.
      Table 1. Table column properties
      FieldDescription
      Column label Unique label for the column.
      Column name Database name for the column.
      Type

      Type of information that the column contains. For example, to contain plain text in the column, select String.

      Depending on the type that you select, fill in the additional fields to further define the table column. For example, if you select String, define the character limit of the string input. Or, if you select Choice, define the choices that users can choose from.

      See Field types.
      Reference Table that is associated with the column. This field applies only if the column type is Reference.
      Max length Maximum number of characters that users can enter in the field.
      Default value Value that populates the field automatically after a new record is created.
      Display

      Option to set the column as the display value for the table. A reference field shows the display value of the table to which it is referring. For example, the Opened by column of the task table refers to the user table. Because the display value of the user table is the user name, the Opened by field shows something like Beth Anglin or Joe Employee. When you select a display value, choose the table column that would act as an appropriate title for individual records.

      Only one column can act as the display value for a table.
  13. Select Save.

What to do next

For more information on Table Builder, see Table Builder.