question how to compare reference fields in Community Central forum

question how to compare reference fields in Community Central forum https://www.servicenow.com/community/community-central-forum/how-to-compare-reference-fields/m-p/2984665#M397 <DIV><DIV><SPAN>function</SPAN><SPAN> onChange(control, oldValue, newValue, isLoading) {</SPAN></DIV><DIV><SPAN>   </SPAN><SPAN>if</SPAN><SPAN> (isLoading || newValue == </SPAN><SPAN>''</SPAN><SPAN>) {</SPAN></DIV><DIV><SPAN>    </SPAN></DIV><DIV><SPAN>return</SPAN><SPAN>;</SPAN></DIV><DIV><SPAN>   }</SPAN></DIV><BR /><DIV><SPAN>   </SPAN><SPAN>var</SPAN><SPAN> lm=g_form.getReference(</SPAN><SPAN>'line_manager'</SPAN><SPAN>);</SPAN></DIV><DIV><SPAN>    </SPAN><SPAN>var</SPAN><SPAN> dm=g_form.getReference(</SPAN><SPAN>'director_approval'</SPAN><SPAN>);</SPAN></DIV><DIV><SPAN>   </SPAN><SPAN>var</SPAN><SPAN> gm=g_form.getReference(</SPAN><SPAN>'general_approval'</SPAN><SPAN>);</SPAN></DIV><BR /><DIV><SPAN>   </SPAN><SPAN>if</SPAN><SPAN>(lm.employee_number == dm.employee_number || lm.employee_number==gm.employee_number || dm.employee_number==gm.employee_number){</SPAN></DIV><BR /><BR /><DIV><SPAN> alert(</SPAN><SPAN>"hi"</SPAN><SPAN>);</SPAN></DIV><DIV><SPAN>   g_form.clearValue(</SPAN><SPAN>'line_manager'</SPAN><SPAN>);</SPAN></DIV><DIV><SPAN>    g_form.clearValue(</SPAN><SPAN>'director_approval'</SPAN><SPAN>);</SPAN></DIV><DIV><SPAN>      g_form.clearValue(</SPAN><SPAN>'general_approvals'</SPAN><SPAN>);</SPAN></DIV><DIV><SPAN>   }</SPAN></DIV><DIV><SPAN>   </SPAN></DIV><DIV><SPAN>}</SPAN></DIV><DIV> </DIV><DIV><SPAN>I tried this showing as javascript error.</SPAN></DIV><DIV> </DIV><DIV><SPAN>I have 3 reference fields on the form where user selects managers</SPAN></DIV><DIV><SPAN>so the managers are to be unique and if it same then it gives an alert and clears the value</SPAN></DIV></DIV><P><a href="https://www.servicenow.com/community/user/viewprofilepage/user-id/279914">@Rupanjani</a> can you help here</P><P>Thanks advance</P> Tue, 09 Jul 2024 10:51:37 GMT pk2184046 2024-07-09T10:51:37Z how to compare reference fields https://www.servicenow.com/community/community-central-forum/how-to-compare-reference-fields/m-p/2984665#M397 <DIV><DIV><SPAN>function</SPAN><SPAN> onChange(control, oldValue, newValue, isLoading) {</SPAN></DIV><DIV><SPAN>   </SPAN><SPAN>if</SPAN><SPAN> (isLoading || newValue == </SPAN><SPAN>''</SPAN><SPAN>) {</SPAN></DIV><DIV><SPAN>    </SPAN></DIV><DIV><SPAN>return</SPAN><SPAN>;</SPAN></DIV><DIV><SPAN>   }</SPAN></DIV><BR /><DIV><SPAN>   </SPAN><SPAN>var</SPAN><SPAN> lm=g_form.getReference(</SPAN><SPAN>'line_manager'</SPAN><SPAN>);</SPAN></DIV><DIV><SPAN>    </SPAN><SPAN>var</SPAN><SPAN> dm=g_form.getReference(</SPAN><SPAN>'director_approval'</SPAN><SPAN>);</SPAN></DIV><DIV><SPAN>   </SPAN><SPAN>var</SPAN><SPAN> gm=g_form.getReference(</SPAN><SPAN>'general_approval'</SPAN><SPAN>);</SPAN></DIV><BR /><DIV><SPAN>   </SPAN><SPAN>if</SPAN><SPAN>(lm.employee_number == dm.employee_number || lm.employee_number==gm.employee_number || dm.employee_number==gm.employee_number){</SPAN></DIV><BR /><BR /><DIV><SPAN> alert(</SPAN><SPAN>"hi"</SPAN><SPAN>);</SPAN></DIV><DIV><SPAN>   g_form.clearValue(</SPAN><SPAN>'line_manager'</SPAN><SPAN>);</SPAN></DIV><DIV><SPAN>    g_form.clearValue(</SPAN><SPAN>'director_approval'</SPAN><SPAN>);</SPAN></DIV><DIV><SPAN>      g_form.clearValue(</SPAN><SPAN>'general_approvals'</SPAN><SPAN>);</SPAN></DIV><DIV><SPAN>   }</SPAN></DIV><DIV><SPAN>   </SPAN></DIV><DIV><SPAN>}</SPAN></DIV><DIV> </DIV><DIV><SPAN>I tried this showing as javascript error.</SPAN></DIV><DIV> </DIV><DIV><SPAN>I have 3 reference fields on the form where user selects managers</SPAN></DIV><DIV><SPAN>so the managers are to be unique and if it same then it gives an alert and clears the value</SPAN></DIV></DIV><P><a href="https://www.servicenow.com/community/user/viewprofilepage/user-id/279914">@Rupanjani</a> can you help here</P><P>Thanks advance</P> Tue, 09 Jul 2024 10:51:37 GMT https://www.servicenow.com/community/community-central-forum/how-to-compare-reference-fields/m-p/2984665#M397 pk2184046 2024-07-09T10:51:37Z Re: how to compare reference fields https://www.servicenow.com/community/community-central-forum/how-to-compare-reference-fields/m-p/2984695#M399 <P>Hi <a href="https://www.servicenow.com/community/user/viewprofilepage/user-id/581682">@pk2184046</a>,</P><P> </P><P>You can check with g_form.getValue() instead of getReference().</P><P>For reference fields, getValue will be returned as the sys_id.</P><P> </P><P>Try below script and check.</P><P> </P><LI-CODE lang="javascript">function onChange(control, oldValue, newValue, isLoading) { if (isLoading || newValue == '') { return; } var lm=g_form.getValue('line_manager'); var dm=g_form.getValue('director_approval'); var gm=g_form.getValue('general_approval'); if(lm == dm || lm == gm || dm == gm){ alert("hi"); g_form.addErrorMessage('Line Manager, Director Approval and General Approval needs to be different.) g_form.clearValue('line_manager'); g_form.clearValue('director_approval'); g_form.clearValue('general_approvals'); } }</LI-CODE><P> </P><P> </P> Tue, 09 Jul 2024 11:13:55 GMT https://www.servicenow.com/community/community-central-forum/how-to-compare-reference-fields/m-p/2984695#M399 Rupanjani 2024-07-09T11:13:55Z Re: how to compare reference fields https://www.servicenow.com/community/community-central-forum/how-to-compare-reference-fields/m-p/2987781#M406 <P>Hi <a href="https://www.servicenow.com/community/user/viewprofilepage/user-id/581682">@pk2184046</a> </P><P> </P><P>Try above code can clear all the values if one is matched.<BR />You need to write onChange client script on every field</P><P> </P><P>onChange Client script when line manager is set/changed</P><LI-CODE lang="javascript">function onChange(control, oldValue, newValue, isLoading) { if (isLoading || newValue == '') { return; } var lm=g_form.getValue('line_manager'); var dm=g_form.getValue('director_approval'); var gm=g_form.getValue('general_approval'); if(dm != '' && gm != ''){ if(lm == dm){ g_form.clearValue('line_manager'); g_form.showFieldMsg('line_manager', 'Line Manager and Director approver can not be same', 'error'); } else if (lm == gm) { g_form.clearValue('line_manager'); g_form.showFieldMsg('line_manager', 'Line Manager and General approver can not be same', 'error'); } } }</LI-CODE><P> </P><P>onChange client script when Director approver is set/changed</P><LI-CODE lang="javascript">function onChange(control, oldValue, newValue, isLoading) { if (isLoading || newValue == '') { return; } var lm=g_form.getValue('line_manager'); var dm=g_form.getValue('director_approval'); var gm=g_form.getValue('general_approval'); if(lm != '' && gm != ''){ if(dm == lm){ g_form.clearValue('director_approval'); g_form.showFieldMsg('director_approval', 'Director approver and Line Manager can not be same', 'error'); } else if (dm == gm) { g_form.clearValue('director_approval'); g_form.showFieldMsg('director_approval', 'Director approver and General approver can not be same', 'error'); } } }</LI-CODE><P> </P><P>onChange client script when general approver is set/changed.</P><LI-CODE lang="javascript">function onChange(control, oldValue, newValue, isLoading) { if (isLoading || newValue == '') { return; } var lm=g_form.getValue('line_manager'); var dm=g_form.getValue('director_approval'); var gm=g_form.getValue('general_approval'); if(lm != '' && dm != ''){ if(gm == lm){ g_form.clearValue('general_approval'); g_form.showFieldMsg('general_approval', 'General Approver and Line Manager can not be same', 'error'); } else if (gm == dm) { g_form.clearValue('general_approval'); g_form.showFieldMsg('general_approval', 'General Approver and Director approver can not be same', 'error'); } } }</LI-CODE><P> </P><P>Modify the error messages as required.</P><P> </P> Thu, 11 Jul 2024 17:50:56 GMT https://www.servicenow.com/community/community-central-forum/how-to-compare-reference-fields/m-p/2987781#M406 Rupanjani 2024-07-11T17:50:56Z Re: how to compare reference fields https://www.servicenow.com/community/community-central-forum/how-to-compare-reference-fields/m-p/2989671#M413 <P>Hi Rupa,</P><P> </P><P>Thank you for the response.</P><P>Small modifications to the script it worked.</P><P>Thanks again</P> Mon, 15 Jul 2024 06:30:21 GMT https://www.servicenow.com/community/community-central-forum/how-to-compare-reference-fields/m-p/2989671#M413 pk2184046 2024-07-15T06:30:21Z