To display a variable if requested for user is VIP and based on another condition

[rishabh31]

Dear Team,

I have the below variables:

1# Requested for (requested_for)-> Reference from sys_user Table

2# access_request_type-> Select Box/Choices: Add, Change, Remove
3# access_change _perma_OR_tempo-> Select Box/Choices: Permanent, Temporary

4# system_access-> Select Box/Choices: SAP, Ops in a box, Resident Portal, Credit Check

5# change_of_access_request-> Select Box/Choices: SAP, Resident Portal, Credit Check, SAP Concur
6# vip_requested_user_requestaccess_locations-> List Collector from cmn_location Table

7# properties_access_require-> Reference from cmn_location Table

The requirement is: Variables 6 and 7 should be displayed only when the user selected in variable 1 is VIP (VIP-True) AND variable 2 is one of Add/Change AND variable 3 is one of Permanent/Temporary AND variable 4 is one of SAP/Resident Portal OR variable 5 is one of SAP/Resident Portal.

To fulfil this I approached UI Policy/Action (as shown below screenshot)

But Condition part 'user selected in variable 1 is VIP (VIP-True)' is NOT achievable through UI Policy due to which Variables 6 and 7 are getting displayed when the rest mentioned conditions are met, this is not desirable.

Please help on how to get this fulfilled. I will mark responses as correct and helpful if resolved.

Thanks

[Manmohan K]

Hi @rishabh31 

create on change client script on change of access request with code like below

Change variable names and choices according to your instance configuration

 
var isVip;
var caller = g_form.getReference('requested_for', doAlert); // doAlert is our callback function 
function doAlert(caller) { //reference is passed into callback as first arguments
isVip= (caller.vip == true) ;
}
    var accessRequestType = g_form.getValue('access_request_type');
    var accessChangePermaOrTempo = g_form.getValue('access_change_perma_or_tempo');
    var systemAccess = g_form.getValue('system_access');
    var changeOfAccessRequest = g_form.getValue('change_of_access_request');

    // Check the conditions to show or hide variables 6 and 7
    var showVariables = (isVip) &&
        (accessRequestType == 'Add' || accessRequestType == 'Change') &&
        (accessChangePermaOrTempo == 'Permanent' || accessChangePermaOrTempo == 'Temporary') &&
        ((systemAccess == 'SAP' || systemAccess == 'Ops in a box' || systemAccess == 'Resident Portal') ||
        (changeOfAccessRequest == 'SAP' || changeOfAccessRequest == 'Resident Portal'));

    // Show or hide variables 6 and 7 based on the conditions
    g_form.setDisplay('vip_requested_user_requestaccess_locations', showVariables);
    g_form.setDisplay('properties_access_require', showVariables);

[rishabh31]

Thanks @Manmohan K for your response but it is throwing error as shown below screenshot

Thanks

[Manmohan K]

@rishabh31 

You would need to add basic skeleton of on change client script like below

function onChange(control, oldValue, newValue, isLoading) {
   if (isLoading || newValue == '') {
      return;
   }
var isVip;
var caller = g_form.getReference('requested_for', doAlert); // doAlert is our callback function 
function doAlert(caller) { //reference is passed into callback as first arguments
isVip= (caller.vip == true) ;
}
    var accessRequestType = g_form.getValue('access_request_type');
    var accessChangePermaOrTempo = g_form.getValue('access_change_perma_or_tempo');
    var systemAccess = g_form.getValue('system_access');
    var changeOfAccessRequest = g_form.getValue('change_of_access_request');

    // Check the conditions to show or hide variables 6 and 7
    var showVariables = (isVip) &&
        (accessRequestType == 'Add' || accessRequestType == 'Change') &&
        (accessChangePermaOrTempo == 'Permanent' || accessChangePermaOrTempo == 'Temporary') &&
        ((systemAccess == 'SAP' || systemAccess == 'Ops in a box' || systemAccess == 'Resident Portal') ||
        (changeOfAccessRequest == 'SAP' || changeOfAccessRequest == 'Resident Portal'));

    // Show or hide variables 6 and 7 based on the conditions
    g_form.setDisplay('vip_requested_user_requestaccess_locations', showVariables);
    g_form.setDisplay('properties_access_require', showVariables);
}

[rishabh31]

Hello @Manmohan K , thank you for the response but seems it is not checking vip=true for a requested user see the below screenshots.

*Abraham Lincoln is a VIP, in the form requested for is Abraham Lincoln and satisfies other conditions per script, but still its not displaying desired variables 6 and 7-

Just the above screenshot is the each of 7 variable's Question and Name.

NOTE: Since Variables 4 and 5 ('system_access' and 'change_of_access_request') are different variables so I modified your provided script per Onchange of each variable, for example please see the below Onchange CS for Variable 5 'change_of_access_request'-

function onChange(control, oldValue, newValue, isLoading) {
   if (isLoading || newValue == '') {
      return;
   }
   var isVip;
var caller = g_form.getReference('requested_for', doAlert); // doAlert is our callback function 
function doAlert(caller) { //reference is passed into callback as first arguments
isVip= (caller.vip == true) ;
}
    var accessRequestType = g_form.getValue('access_request_type');
    var accessChangePermaOrTempo = g_form.getValue('access_change_perma_or_tempo');
    //var systemAccess = g_form.getValue('system_access');
    var changeOfAccessRequest = g_form.getValue('change_of_access_request');
    // Check the conditions to show or hide variables 6 and 7
    var showVariables = (isVip) &&
        (accessRequestType == 'Add' || accessRequestType == 'Change') &&
        (accessChangePermaOrTempo == 'Permanent' || accessChangePermaOrTempo == 'Temporary') &&
        (changeOfAccessRequest == 'SAP' || changeOfAccessRequest == 'Resident Portal');
    // Show or hide variables 6 and 7 based on the conditions
    g_form.setDisplay('vip_requested_user_requestaccess_locations', showVariables);
    g_form.setDisplay('properties_access_require', showVariables); 
}

Need help to get this resolved.

Thanks