Add and configure fields

Use a stored field for a value you enter, a computed field for a calculation, or a related field for data linked from another table.

Add a field in Jet Tables

1. Open Data, select your Jet Tables resource, and open the table.

2. Select Add field at the right end of the column headers.

3. Choose Add new field.

4. Set the name and a type that matches the values you will store, then complete the field configuration.

5. Enter a sample value in a test record. Reopen it and confirm that the value and format are correct.

Choose a stored field or one of the available calculated-field options.

Example configuration for a Number field. This screenshot shows the form before creation.

The same menu includes computed fields, lookups, rollups, and AI autofill. See Computed fields and Relationships.

For connected data, update the source schema where required, then sync schema changes. Changing a component's display format does not change the source column type.

Configure columns in Classic App Builder

Select the table component and configure the column's display type. For example, use an image display for a field containing image URLs. Check a record with a value and a record with an empty value.

Change a column display type in Classic App Builder

Reorder component columns

Choose which columns appear in a component

Reorder columns to match your task, and hide fields that do not need to appear in the component. Hidden fields remain in the data source; use permissions to control access.

For Data Editor view controls, follow Navigate the Data Editor.