Constraints

This section provides options for limiting input values, setting default values, and configuring field validation.

1. Minimum and Maximum

Here 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.

Consider the example below, where the minimum and maximum values are set for the 'Salary' column.

Minimum and Maximum

The existing values remain unchanged. However if a user enters a salary that falls outside the specified range, they will be notified of the minimum and maximum limits.

user notified about the min and max values

Note: You can also set any one of these limits (either minimum or maximum).

For Date and DateTime input types, users may choose a date range or both date and time range. Any date and time outside of this range will not be accepted.

Minimum and maximum date range

2. Field Validation

This option is available for the Text input type, where you can specify whether to allow only numeric, alphanumeric, non-numeric, Email ID, or URL inputs. You can also specify a regex pattern to allow inputs that match a specific pattern. Inputs that do not match the pattern are flagged and rejected.

This ensures data correctness and accuracy.

Field Validation

The field value is validated against your specified input type configuration. If another type is entered, it is not accepted.

Example

When you choose the 'Regex' option, a new field appears with the link 'Click to configure'.

Regex option

After clicking the link, a pop-up appears where you can enter the regex pattern to be validated against. Click Apply and Save. In the example below, we have entered the regex text to validate the email ID or URL entered by the users.

Regex validation for Email ID column

When a user enters an incorrect email address or URL, the below prompt appears, and the input is rejected.

Wrong text input

3. Default Value

EDITable lets you configure default values for the columns. When a new row is added, the specified column is automatically filled with the default value if you have set one.

To set a default value, click the highlighted option below, beside the required column.

Click to configure default date

3.1. Static value

To set a static value, select Manual and enter the value. In the example below, a static value is set as the default date for the 'Start Date' column.

Setting static default value

Whenever a new row is added, this column value is automatically populated by default.

Default value is filled automatically

Reset to default on update

Checking the 'Reset to default on update' option sets the default value for newly inserted rows and disables the column from editing. The existing values are retained, and automatically changed to default only when users edit other values in the specific record. Find below an example where the value changes to the default.

Reset to default on update

For the 'Decimal' input type, you can also specify the default number of decimal digits to be allowed.

Decimal input type

For the 'Person' input type, you can either use their name or email address as default.

Person input type

For the 'Single-select' type, you can choose the default value from the list of options you have configured.

Single-select input type

For the 'Check Box' type, the default values are automatically configured with the Boolean values: true and false. You can change these to 1/0 or yes/no, etc., if necessary.

Checkbox type

3.2. Derived value

You can set derived values as defaults instead of using static values. These derived values are calculated using configurable formulas.

EDITable provides many Excel-like formulas and functions to help you perform these calculations. These values change dynamically as the underlying reference data changes.

Derived values can be set for the field types - Number, Decimal, Text, Date, DateTime, Person, and Email.

Configure derived value

Recalculate data on update

Checking the 'Recalculate data on update' option sets the calculated value as default for newly inserted rows and disables the column from editing. The existing values are retained and automatically changed to the derived value only when users edit other values in the specific record.

Recalculate data on update

We have discussed setting constraints and defaults for table data. In the next section, we will explore how to select and look up values from a table or visual for a single-select field type.