Constraints*

*This document is a work in progress

This section includes options for limiting the values entered, setting default values, and configuring field validation.

1. Minimum and Maximum

You can specify the minimum and maximum values that can be entered into the columns. Any values outside of this range are not permitted. These limits can be applied to the input types: Number, Decimal, Date Time, and Date.

For Date Time and Date types, you can specify the beginning date and time and the ending date and time as the range, and any date beyond this timeline is not allowed.

2. Field Validation

For the Text input type, you can define whether you want to allow only numeric input, alphanumeric input, or non-numeric input. You can also specify whether the input should be an Email ID or a URL. The field value is validated against your specified input type configuration and notified if another type is entered.

3. Default Value

When a new row is added, the column will be auto-populated with the default value if you set one. To configure them, simply click on the highlighted option shown below.

Find below an example where the default value is manually set as a static value. When you insert a new row, this default value gets auto-populated in the set column.

Enabling the 'Reset to default on update' always resets the value to the default value, even if any user updates them.