Data in Table Builder

  • Release version: Yokohama
  • Updated January 30, 2025
  • 2 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Data in Table Builder

    Table Builder is a versatile tool in ServiceNow Yokohama release that allows you to modify table properties and manage fields within a selected data table. It provides multiple views—Fields, Spreadsheet, and Schema—to edit table columns, structure, and data records efficiently. This enables customization of tables and data handling tailored to your application needs.

    Show full answer Show less

    Key Features

    • Fields View: Edit table columns as rows, allowing you to add, delete, rename, or change the label and type of columns. You can also set default values, select display name columns, and modify table properties such as labels and extensibility.
    • Spreadsheet View: Available with appropriate licensing and Table Builder for App Engine installed, this view lets you work with data records and table structure in a spreadsheet format. Actions include adding/editing data records, sorting, filtering, reordering columns, setting column visibility, pinning columns, duplicating columns, and deleting columns.
    • Schema View: Also requiring specific licensing and Table Builder for App Engine, this view helps explore table relationships within your application data.
    • Search and Filter: Quickly find and filter table columns in Fields view using the search box and filter options to show inactive or extended fields.
    • Preview: Preview table appearance after editing columns to verify changes.
    • Delete Table: Remove tables from your application, so they no longer appear on the app dashboard.

    Practical Benefits for ServiceNow Customers

    • Efficiently customize tables by editing columns and properties to align with your data entry and application requirements.
    • Leverage spreadsheet-style data management for easier manipulation of records and structure when licensed for low-code capabilities.
    • Understand and manage data relationships with Schema view to improve application design.
    • Improve usability and data integrity by setting meaningful column labels, types, and default values.
    • Streamline table maintenance by quickly searching columns and managing visibility and ordering in the interface.

    With Table Builder, you can modify the table properties and manage the fields that are available for a selected data table.

    Table Builder is a tool for editing data tables. You edit a table on the Data tab by editing the columns of the table.

    Figure 1. Table Builder
    User interface for Table Builder.

    In Table Builder, each table column is represented as a row. For example, "Art title," "Image," and "Available" appear as column headers on the actual table. However, when you edit the columns in Table Builder, they appear as rows.

    Figure 2. Example: Columns in Table Builder
    Example columns.
    Figure 3. Example: Actual data table shown with two records
    Example table.
    To easily find a specific table column to edit in the default Fields view, type the column name into the search box at the top right. As you type, the list of columns below is filtered to match the entered keyword.
    Note:
    Use the Filter options list to show inactive fields or to hide extended fields from the list (if a table has been extended from an existing table).
    Figure 4. Search for a table column
    Search for a table column.

    As you edit the table columns in Table Builder, think of each row as a field on a form. For example, if you change a column label, use a label that describes the data that you expect the user to enter in the form field. Change the column type to support this kind of form entry.

    Modify table properties and table structure in Fields view, where you can perform the following actions:
    Work with table structure and your data records in spreadsheet format within Spreadsheet view, where you can perform the following actions:
    Note:
    This feature is only available if your licensing entitles you to "exclusive low code capability" and you have Table Builder for App Engine installed. Contact your Solutions consultant for more information.
    You can also view the table relationships for your table in Schema view. See Schema view in Table Builder.
    Note:
    This feature is only available if your licensing entitles you to "exclusive low code capability" and you have Table Builder for App Engine installed. Contact your Solutions consultant for more information.