Hello everyone:
I have a problem with a "simple" validation in a form: 2 fields in a form, both are not required but at least 1 of them must be filled before saving the record
I'm sure this happened to more than one of you, seems I'm in a foggy day today and I can't find a "simple" or logical solution.
Any ideas?
Thank you very much.
Solved! Go to Solution.
Please try "
In the "Required" setting of [Field 1]
ISBLANK([Field 2])
In the "Required" setting of [Field 2]
ISBLANK([Field 1])
Please try "
In the "Required" setting of [Field 1]
ISBLANK([Field 2])
In the "Required" setting of [Field 2]
ISBLANK([Field 1])
This is what I meant by simple.
Brilliant solution.
Much appreciated.
Virtual Column "requerid"
App formula
IF(AND(ISBLANK([field1]), ISBLANK([fiedl2])), true, false)
Data validity - Valid if
[Requerid]="false"
User | Count |
---|---|
35 | |
9 | |
3 | |
3 | |
2 |