Skip to content
Examples
1. Simple list of mandatory fields
This is the typical and most simple use-case: it's a check on a the list of table's mandatory fields. Just look at formula in the Validation column.
Tasks
Name
Description
Due Date
Owner
Is Done
Validation
Is Valid
Validation Message
A Task
This is the task description
🔴
The following fields are missing: Due Date,Owner
Another Taks
Some more details
8/24/2022
🟢
All mandatory fields are present
There are no rows in this table
2. Conditional validation
It is possible to combine the mandatory fields according to different conditions according to status. Conditions can be composed via Validation.ColumnList chains (see Composable Validation column, if you want to have multiple, different validation columns) or in a single column (see Composable Validation Alternative column)
Requests
Name
Value
Owner
Addressee
Evaluation Review
Rejection Reasons
Status
Basic Validation
Is Valid
Custom Validation Message
Composable Validation
Composable Validation Alternative
A new request
It would be nice to have...
Created
🟢
👍 All mandatory fields are present
🟢
🟢
Another request
It would be nice to also have...
Rejected because...
Rejected
🟢
👍 All mandatory fields are present
🟢
🟢
Another request
It would be nice to also have...
Approved
🟢
🚫 The following Fileds are missing:
🔴
🔴
There are no rows in this table
Statuses
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.