When data validation is enabled, SeaTable checks whether the entered cell value corresponds to the defined target format. If the input does not correspond to the target format, the cell is highlighted in red. In web forms, a non-compliant input leads to an error message and the form cannot be submitted.
Data validation in SeaTable 3.0
The target format is defined in the form of a regular thailand rcs data expression sequence with exactly 5 digits is, for example, [0-9]{5}. There are two arguments in favor of regular expressions: they are a widely used method and offer maximum flexibility. The type of characters allowed, the length, and also the syntax of the input can be precisely defined with regular expressions.
Data validation is available in text columns in version 3.0. If a target format is added subsequently, all existing entries are also checked and non-compliant values are marked as such. There is therefore nothing to stop you subsequently activating data validation in existing columns.