--- sourceDocument: Yokohama Build or modify applications sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/application-development Release : - yokohama ft:locale : - en-US ft:publication_title : - Yokohama Build or modify applications ft:clusterId : - cadev bundleId : - cadev workflow : - Development, Data, and Analytics --- # Data in Table Builder # Data in Table Builder {#ariaid-title1} * Release version: Yokohama * * Updated January 30, 2025 * * ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read Summarize ![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) 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 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 Figure 3. Example: Actual data table shown with two records 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 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: * Add a new column to a table. See [Add a table column in Table Builder](https://servicenow-prod.fluidtopics.net/Z9~hsE5ULW9umZgVi9ZlkA#add-table-column-fb "Store more information in a table record by adding a table column."). * Delete a table column. See [Delete a table column in Table Builder](https://servicenow-prod.fluidtopics.net/Z9~hsE5ULW9umZgVi9ZlkA#delete-column-fb "Delete a column from your table using Table Builder."). * Edit table properties. See [Edit table properties in Table Builder](https://servicenow-prod.fluidtopics.net/OSaNNYIONgHUhyDN_bhW2w "Change table properties such as the table label or other settings so that you can make a table extensible or add record numbers by using Table Builder."). * Change a column label. See [Change a column label in Table Builder](https://servicenow-prod.fluidtopics.net/Z9~hsE5ULW9umZgVi9ZlkA#change-column-label-fb "Modify the label that uniquely identifies the data that is stored in it to users."). * Change a column name. See [Changing a table column name in Table Builder](https://servicenow-prod.fluidtopics.net/Z9~hsE5ULW9umZgVi9ZlkA#change-column-name-fb "Change the database name for the column. You may opt to change the column name manually if a reviewer finds that the column name in the database was causing issues in testing."). * Change a column type. See [Change a column type in Table Builder](https://servicenow-prod.fluidtopics.net/Z9~hsE5ULW9umZgVi9ZlkA#change-column-type-fb "Change the type of field that will store information for rows in a table column. For example, if your table is tracking dates, you would want to select the Date column type."). * Add a default value to a table. See [Add a default value to a table column in Table Builder](https://servicenow-prod.fluidtopics.net/Z9~hsE5ULW9umZgVi9ZlkA#add-default-value-fb "Define the default value to populate a table column automatically after a user creates a record."). * Select a column as table display name. See [Select a column as the table display value in Table Builder](https://servicenow-prod.fluidtopics.net/Z9~hsE5ULW9umZgVi9ZlkA#set-display-value-fb "Select a column value that will be displayed in the reference fields of other tables. For example, the Opened by column of the task table could refer to a specific column in the user table so it can display a user name."). * Delete a table. See [Delete a table in Table Builder](https://servicenow-prod.fluidtopics.net/sot4ealzbOjcwqJyWC0ofw "Delete a table from your application so that it no longer appears in the app dashboard."). {#table-builder__ul_xwh_cgr_5sb} 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. * Add a new data record. See [Add a new data record](https://servicenow-prod.fluidtopics.net/kUDkHFxkVW221K1SNo9bBA#add-data-record-tb "Add a new data record within Table Builder Spreadsheet view."). * Edit individual data records. See [Edit individual data records](https://servicenow-prod.fluidtopics.net/kUDkHFxkVW221K1SNo9bBA#edit-your-data-records-tb "Edit individual data records within Table Builder Spreadsheet view."). * Sort your data records. See [Sort your data records](https://servicenow-prod.fluidtopics.net/kUDkHFxkVW221K1SNo9bBA#sort-your-data-records-tb "Sort your data records by a specific field column within Table Builder Spreadsheet view."). * Filter your data records. See [Filter your data records](https://servicenow-prod.fluidtopics.net/kUDkHFxkVW221K1SNo9bBA#filter-your-data-records-tb "Display only the data records you want to see in your list by setting up a conditional query within Table Builder Spreadsheet view."). * Edit column field properties. See [Edit column field properties](https://servicenow-prod.fluidtopics.net/kUDkHFxkVW221K1SNo9bBA#set-column-field-properties-tb "Edit field properties such as the field label, type, attributes, and default values within Table Builder Spreadsheet view."). * Add new columns. See [Add new columns](https://servicenow-prod.fluidtopics.net/kUDkHFxkVW221K1SNo9bBA#add-new-columns-tb "Add new field columns to a selected table within Table Builder Spreadsheet view."). * Duplicate an existing column. See [Duplicate an existing column](https://servicenow-prod.fluidtopics.net/kUDkHFxkVW221K1SNo9bBA#duplicate-an-existing-column-tb "Duplicate an existing field column within a table shown in Table Builder Spreadsheet view."). * Reorder columns. See [Reorder columns](https://servicenow-prod.fluidtopics.net/kUDkHFxkVW221K1SNo9bBA#reorder-columns-tb "Change the order in which your columns are displayed within Table Builder Spreadsheet view."). * Set column visibility. See [Set column visibility](https://servicenow-prod.fluidtopics.net/kUDkHFxkVW221K1SNo9bBA#set-column-visibility-tb "Choose whether to hide or show specific field columns within Table Builder Spreadsheet view."). * Pin columns. See [Pin columns](https://servicenow-prod.fluidtopics.net/kUDkHFxkVW221K1SNo9bBA#pin-columns-tb "Pin specific columns to always display on the left when you scroll to the right in a table with a large number of field columns within Table Builder Spreadsheet view. Pinned columns are saved for each individual user, not globally. The next time a user logs in, any columns they pinned will be shown."). * Delete a table column. See [Delete columns](https://servicenow-prod.fluidtopics.net/kUDkHFxkVW221K1SNo9bBA#delete-columns-tb "Delete a field column for a selected table within Table Builder Spreadsheet view."). {#table-builder__ul_pzp_k3f_zwb} You can also view the table relationships for your table in Schema view. See [Schema view in Table Builder](https://servicenow-prod.fluidtopics.net/HhjQDifJUy5e3CoDqm9lGw "Use Schema view in Table Builder to explore data relationships for your application data."). 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. * **[Spreadsheet view in Table Builder](https://servicenow-prod.fluidtopics.net/kUDkHFxkVW221K1SNo9bBA#tb-sprdsht-view)** Use Spreadsheet view in Table Builder to work with your application data records and data structure in a spreadsheet format. * **[Fields view in Table Builder](https://servicenow-prod.fluidtopics.net/Z9~hsE5ULW9umZgVi9ZlkA#modify-table-properties)** Modify the table properties and manage the table fields by using the default Fields view on the Data tab in Table Builder. * **[Schema view in Table Builder](https://servicenow-prod.fluidtopics.net/HhjQDifJUy5e3CoDqm9lGw)** Use Schema view in Table Builder to explore data relationships for your application data. * **[Preview your data in Table Builder](https://servicenow-prod.fluidtopics.net/CmWV_3MdBuFiEcCMKQwntg)** See what your table looks like after you've edited the table columns. * **[Delete a table in Table Builder](https://servicenow-prod.fluidtopics.net/sot4ealzbOjcwqJyWC0ofw)** Delete a table from your application so that it no longer appears in the app dashboard. * **[Edit table properties in Table Builder](https://servicenow-prod.fluidtopics.net/OSaNNYIONgHUhyDN_bhW2w)** Change table properties such as the table label or other settings so that you can make a table extensible or add record numbers by using Table Builder.