Hi guys,
I have a form that goes (in simplified way) something like this:
Field1 - Position
Field2 - Option1
Field3 - Option2
I know this is not ideal but constraints force me to do it this way.
I want a rule that basically turns my field red if Option2 has the same value as what is in Option1. Problem is, I only care about repeats in the SAME record, not across the whole table.
Is this possible?
I have a form that goes (in simplified way) something like this:
Field1 - Position
Field2 - Option1
Field3 - Option2
I know this is not ideal but constraints force me to do it this way.
I want a rule that basically turns my field red if Option2 has the same value as what is in Option1. Problem is, I only care about repeats in the SAME record, not across the whole table.
Is this possible?