Create a blank table

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

始める前に

Role required: admin, sn_app_eng_studio.user, or delegated_developer

手順

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 ().
4. Select Create a blank table, and then select Continue.
5. Choose from the following choices.

   オプション	説明
   Create new table	Select this option to create a blank table from scratch. Choose Create new table. 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. Choose Create from an extensible table. Search for and select an existing table. 注: 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. Select Continue.

6. On the form, fill in the properties of your new table.

   Field	Description
   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.

   注:

   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 () 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.

       表 : 1. Table column properties

       Field	Description
       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.

次のタスク

For more information on Table Builder, see Table Builder.