Forum Discussion

Carl_Williams's avatar
Carl_Williams
Iron Contributor
Dec 18, 2021

List Validation

Hello. I'm very confused about list validation. 

Every input whether correct or incorrect fails.

I'm attempting to set it so:

  1. If the [Contact Type] field is not "Band" and the [Band Type] field is populated, throw the error OR,
  2. If the [Contact Type] field is "Band" and the [Band Type] field is left empty, throw the error. 

As you can see in the attached images, even updating information to correct values throws the error. Perhasps I'm expecting too much from this validation?

 

EDIT: I've updated my validation to: =IF([Contact Type]="Band",IF([Band Type]<>"",TRUE,FALSE),TRUE)

However it's allowing me to add "Band Type" choices regardless of "Contact Type" required to be "Band".

EDIT2: This works:

=IF([Contact Type]="Band",IF([Band Type]<>"",TRUE,FALSE),FALSE)

 

Thanks!!

No RepliesBe the first to reply

Resources