Solved

Mandatory people picker field based on two conditions: condition A and condition B

  • 21 February 2023
  • 1 reply
  • 60 views

Userlevel 1
Badge +6

I am building a form for making appointments with these fields:

  • Appt Category (Choice): Make appointment or block appointments
  • Supervisor (people picker)
  • Supervisor Not Listed (checkbox yes/no - default is no)
  • Supervisor (Manual Entry) - text field

I already have a rule where ‘Supervisor (Manual Entry)’ is a required field when ‘Supervisor Not Listed’ is equal to ‘Yes’…

 

But need a validation rule to make the ‘Supervisor’ (people picker) field MANDATORY on these two conditions. I tried this rule, but it does not work:  

  • ‘Appt Category’ = “Make appointment” AND
  • ‘Supervisor Not Listed’ is equal to ‘No’

So that when ‘Appt Category’ = “block appointments”, the supervisor fields are not mandatory.

Thank You.

icon

Best answer by isabellamai 21 February 2023, 16:03

View original

1 reply

Userlevel 1
Badge +6

I was able to resolve it with the below rule:

If(equals(ApptCategory,"Make appointment") && not(SupervisorNotListed), isNullOrEmpty({Self}))

 

 

Reply