Validations in Rows

Get Help
1

Hello. I can’t find this in examples and settings - please help.
I want to implement validation when entering new row into a table: e.g. IF field A is OPTION1 then field B and C should be not empty, IF field A is OPTION2 then field D and F should be not empty, and so on.
Is it somehow possible?
If not - can I at least have formula that will do the same and if it is FALSE displays ERROR label/text?

2

Hi, Konstantin :slight_smile:
We would suggest boolean formula (checkbox) and color-coding on top
There is no need in the If formula - just a combination of and/or showing boolean

Btw, if you could share with us your case with details, there is a chance, that we can find a better solution :wink:

3

re: Btw, if you could share with us your case with details, there is a chance, that we can find a better solution

Validation is important part of ANY workflow.
Some examples:

  • allow only tasks with Estimate be scheduled.
  • allow only tasks with Estimate and Scheduled to be worked on and receive work logs
  • allow only correct financial transaction with all required fields to be created
    etc
1 Like