Every table has a column structure. All rows of the table must conform to this column structure.
The column structure contains one column definition for each column in the table. Each column definition has the following properties:
- Column Name: The column name. The column name is obtained from the column header in the spreadsheet.
- Column Type: The column type which is one of the column types supported by AppSheet, such as Number, Price, Phone, Email, Image, or Text. This is the most important component of the column definition because it has a significant impact on the behavior of the column.
- Type Qualifier: Properties that further describe the column type. For example, a Number might include MinValue and MaxValue properties.
- App Formula: An expression used to compute the value of the column within the application.
- Key: Indicates whether the column is part of the key.
- Row Label: The value in this column is displayed to the user to help the user identify the row.
- Read Only: The column is not modifiable by the user.
- Hide: The column is hidden from the user.
- Require: The column must contain a value.
- Column Description: An optional description of the column. If you specify a column description, make it meaningful to the application user.
- Initial Value: The initial value to be assigned to the column when a new row is added to the table. The initial value can typically be overridden by the user.
- Search: The user can search the values in the column.
- Scan: The column value can be entered using a bar code scanner.
- Sensitive: The value in this column should not be logged to the audit log because it contains private or personal information.
- Sheet Formula: The expression assigned to this column in the worksheet.
Regenerating the column structure
After you have created an app from your worksheet, you may wish to make changes to your worksheet. For example, you may wish to add, delete, update, or re-order columns in your worksheet. After you make such changes, you must regenerate the application table to match your worksheet.
To perform regenerate, do the following:
- Open the application in the AppSheet Editor.
- Go to the Data>Column Structure tab.
- Scroll down to the column listing for the table you want to regenerate (look for the Show/Hide buttons underneath the table name).
- Click "Regenerate".
Do this for each worksheet you have modified.
You may have manually specified properties for your table columns through the AppSheet Editor. AppSheet will try to preserve these properties when you regenerate. Regenerate compares each column name in your worksheet to each column name in your application table. If the column names match exactly, regenerate presumes that the column properties you specified through the Editor should be preserved. If the column name in the worksheet does not match a column name in the application table, regenerate assumes that the column is new and it infers the new column's properties.