Data in Table Builder

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.
• Delete a table column. See Delete a table column in Table Builder.
• Edit table properties. See Edit table properties in Table Builder.
• Change a column label. See Change a column label in Table Builder.
• Change a column name. See Changing a table column name in Table Builder.
• Change a column type. See Change a column type in Table Builder.
• Add a default value to a table. See Add a default value to a table column in Table Builder.
• Select a column as table display name. See Select a column as the table display value in Table Builder.
• Delete a table. See Delete a table in Table Builder.

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.
• Edit individual data records. See Edit individual data records.
• Sort your data records. See Sort your data records.
• Filter your data records. See Filter your data records.
• Edit column field properties. See Edit column field properties.
• Add new columns. See Add new columns.
• Duplicate an existing column. See Duplicate an existing column.
• Reorder columns. See Reorder columns.
• Set column visibility. See Set column visibility.
• Pin columns. See Pin columns.
• Delete a table column. See Delete columns.

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.

• Spreadsheet view in Table Builder
  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
  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
  Use Schema view in Table Builder to explore data relationships for your application data.
• Preview your data in Table Builder
  See what your table looks like after you've edited the table columns.
• Delete a table in Table Builder
  Delete a table from your application so that it no longer appears in the app dashboard.
• Edit table properties in Table Builder
  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.