Skip to content
Row Validation Pack
Share
Explore

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
0
Search
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
FS
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
0
Search
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...
FS
Federico Stefanato
Created
🟢
👍 All mandatory fields are present
🟢
🟢
2
Another request
It would be nice to also have...
FS
Federico Stefanato
FS
Federico Stefanato
Rejected because...
Rejected
🟢
👍 All mandatory fields are present
🟢
🟢
3
Another request
It would be nice to also have...
FS
Federico Stefanato
FS
Federico Stefanato
Approved
🟢
🚫 The following Fileds are missing:
Evaluation Review
🔴
🔴
There are no rows in this table
Statuses
0

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.