Skip to content
Gallery
Row Validation Pack
Row Validation Pack
Examples
More
Share
Explore

icon picker
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
1
A Task
This is the task description
​
🔴
The following fields are missing: Due Date,Owner
2
Another Taks
Some more details
8/24/2022
Federico Stefanato
🟢
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
1
A new request
It would be nice to have...
Federico Stefanato
​
​
​
Created
🟢
👍 All mandatory fields are present
🟢
🟢
2
Another request
It would be nice to also have...
Federico Stefanato
Federico Stefanato
​
Rejected because...
Rejected
🟢
👍 All mandatory fields are present
🟢
🟢
3
Another request
It would be nice to also have...
Federico Stefanato
Federico Stefanato
​
​
Approved
🟢
🚫 The following Fileds are missing:
Evaluation Review
🔴
🔴
There are no rows in this table
⁠
Statuses
⁠

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.