Setting column formats and validation
To set formats and data validation for a column:
- In Grid layout, right-click or hover over the column header and select the context menu option "Edit column".
- If the column type supports data formats or validation, it will show as a "Format" and "Validation" tab in the column settings dialog.
- Select the respective tab, configure the format/validation, and save.
Supported column types
TYPE | FORMATS | DATA VALIDATION |
---|---|---|
Text |
Note: setting email or url format will also enforce validation. |
Note: min or max character lengths are inclusive, and blank values do not count against the min character length. |
Number |
Can toggle thousands separator. |
Note: max or min values are inclusive, and blank values do not count against the min value. |
[WIP] Date and time |
Date formats:
Note: to change date format from U.S. (MM/DD/YY) to European (DD/MM/YY), you need to change the table locale (see below). Time formats:
|
Date validation:
Note: date validation will not show warnings for existing values. |
Person |
|
Note: when limiting by domain email, it will support sub-domains. When limiting by a specific list of users, the person-selector will only autocomplete on that specific list. |
Data validation warnings
Existing column values that do not match validation will show a warning sign next to the value, to visually indicate to users which values should be updated.
Bot actions that try to update or add rows that do not match validation will fail and surface an "invalid" status in the bot execution history. To fix this, ensure that the bots are not sending data that does not match the validation criteria.
Changing date format via table locale
To change date format via locale:
- Hover over the table and select the context menu option "Table settings".
- In the Table locale section, select the respective tab and click save.