Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

validate 2 fields in a form before saving?

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 Solved
0 3 217
1 ACCEPTED SOLUTION

Please try "

In the "Required" setting of [Field 1] 

ISBLANK([Field 2])

In the "Required" setting of [Field 2] 

ISBLANK([Field 1])

View solution in original post

3 REPLIES 3

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"

 

Top Labels in this Space