question Validation on two reference field in Community Central forum

Validation on two reference field

Community Alums — Thu, 17 Oct 2024 14:35:40 GMT

Hi Team ,

Hi Team,

I have one requirement for my project: there is a record producer with two fields, 'Select Primary Approver' and 'Select Secondary Approver.' Both fields are reference fields that refer to the sys_user table. The requirement is that if I select a user, for example, Abel Tuter, in the 'Select Primary Approver' field, I do not want that user to be available in the 'Select Secondary Approver' field."

Re: Validation on two reference field

Voona Rohila — Thu, 17 Oct 2024 14:46:21 GMT

Hi @Community Alums

A simple Catalog UI policy would work.

Conditions - Select Primary Approver || is not empty ( Change your conditions accordingly)
In UI Policy actions - Select Select Secondary Approver field and check Hidden true, mandatory false.

Re: Validation on two reference field

Community Alums — Thu, 17 Oct 2024 14:53:29 GMT

Hi @Voona Rohila the requirement is selected user in primary approver field is not available in secondary approver field

for ex - In primary approver field If I select "Abel tuter" then I don't want Abel Tuter in secondary approver field

Re: Validation on two reference field

Voona Rohila — Thu, 17 Oct 2024 15:11:49 GMT

Ohh Okay, You can write a advanced reference qualifier on secondary approver variable dictionary.

javascript&colon; 'sys_id!='+current.variables.variablename // replace variablename with first approver variable name.

Mark it helpful if this helps you to understand. Accept Solution if this gives you the answer your looking for!!

Re: Validation on two reference field

Sumanth16 — Wed, 23 Oct 2024 19:31:40 GMT

Hi @Community Alums ,

This is how you should configure your reference qualifier on the second reference field.

javascript&colon;'sys_id!='+current.variables.requested_by(replace with first variable name);

If you find it helpful, please mark my answer as correct so that it can useful to others.

Thanks & Regards,
Sumanth Meda

Re: Validation on two reference field

Voona Rohila — Wed, 23 Oct 2024 19:34:08 GMT

Is this the same answer I provided @Sumanth16

Re: Validation on two reference field

Voona Rohila — Fri, 25 Oct 2024 14:30:41 GMT

Thank you for marking response as helpful, Is your issue fixed?