Validation Rule: Compare contents of Multi entry Person field to Single entry person field

  • 1 October 2020
  • 2 replies
  • 0 views

Badge +3

Hi Everyone,

 

I am wanting to do a validation on form submission to check to see that a person that has been entered in to a Multi person "Approvers" field is not present in the "Preparer" field.

 

This so the preparer cannot play a part in the Approval workflow.

 

I can get it to work if only one user is entered in to the "Approvers" field, and that user is the "Preparer", but as soon as I enter a second person in to the "Approvers" field, the validation no longer triggers.

 

This is what I have in the validation rule at the moment:
Preparer==Approvers

 

Thanks for you help


2 replies

Userlevel 6
Badge +22
Hi

Try:
contains(Approvers,Preparer)
Badge +3
Thanks Simon

Reply