Autopopulate two values in based on three fields.

[Sirri]

Hi All,

we have requirement in catalog item there are three fields 

1)Requested for                                                                                                - Reference(sys_user)- [From Variable set]

2)Select the name of the person whose mailbox you need Full Access to  - Reference(sys_user)  - variable

3)Select the name of the Leaver whose mailbox you need Full Access to    - Reference(sys_user) - Variable

4)Confirmation                                                                                                     -Single Line Text(Readonly)

- When 2 & 3 fields are empty form should not submit please provide the code for this.

-When Both 2 & 3 are values filled form should not submit For this please provide code for this.

- In confirmation single line text we should want to populate 1&2 or 1&3 value As per the selection.

Please provide Clear code for this requirement.

Thank you

-

[Aniket Chavan]

Hello @Sirri ,

So in this scenario, you need to use the onChange client script but before that I want to confirm one thing that is the "Select the name of the person whose mailbox you need Full Access" & "Select the name of the Leaver whose mailbox you need Full Access to" both be will visible always or only one of them will be visible?

Just let me know your views on this one so that we can discuss about the further actions.

[Sirri]

Hi Aniket,

As per the selection  "Select the name of the person whose mailbox you need Full Access" or  "Select the name of the Leaver whose mailbox you need Full Access to" only one of them will visible with Requested for.

I hope you clear now. Please let me know how we can achieve this.

Thank you

[Aniket Chavan]

Hello @Sirri ,

Yes it's clear now, so you have to use two onChange client scripts for setting the value of confirmation variable , one will be used when "Select the name of the person whose mailbox you need Full Access" visible and one will be used when "Select the name of the Leaver whose mailbox you need Full Access to" visible,

also as you saying only one variable will be visible so hope you are already implemented logic behind it using UI policy or something, so you don't need to do any to fullfill these two criteria "When 2 & 3 fields are empty form should not submit and when Both 2 & 3 are values filled form should not submit" because currently the two onChange client scripts which I have provided you below don't have the logic to restrict user from submitting the item if those two conditions are not satisfying so please let me know your views on this one, also in my opinion you should use UI policy to make visible either one of those two variables so that you will no need to use 3rd onSubmit client script.

Script for fullAccessToPersonDisplay onChange:

function onChangeFullAccessToPerson(control, oldValue, newValue, isLoading, isTemplate) {
    if (isLoading || newValue === '')
        return;

    var requestedForDisplay = g_form.getDisplayValue('requested_for');
    var fullAccessToPersonDisplay = g_form.getDisplayValue('full_access_to_person');

    if (fullAccessToPersonDisplay) {
        g_form.setValue('confirmation_field', requestedForDisplay + ' - ' + fullAccessToPersonDisplay);
    }
}

 Script for leaverPersonDisplay onChange:

function onChangeLeaverPerson(control, oldValue, newValue, isLoading, isTemplate) {
    if (isLoading || newValue === '')
        return;

    var requestedForDisplay = g_form.getDisplayValue('requested_for');
    var leaverPersonDisplay = g_form.getDisplayValue('leaver_person');

    if (leaverPersonDisplay) {
        g_form.setValue('confirmation_field', requestedForDisplay + ' - ' + leaverPersonDisplay);
    }
}

Please select the appropriate variables in in the both onChange client scripts and let me know if you have any queries further.

[Sirri]

Hi Aniket,

I have written the on change client script. but It's showing unreachable code  in the both of two change client script please find the attached document for your reference. 

Thank you

[Aniket Chavan]

Hello @Sirri ,

It seems like you have added your code inside the onChange function means inside if condition so please adjust the code accordingly or else refer as below:
onChange client script for fullAccessToPerson:

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue === '') {
        return;
    }

    var requestedForDisplay = g_form.getDisplayValue('requested_for');
    var fullAccessToPersonDisplay = g_form.getDisplayValue('select_the_name_of_the_person_whose_mailbox_you_need_full_access_to');

    if (fullAccessToPersonDisplay) {
        // Move the following alert statement inside the if block if you want it to execute conditionally
        alert('test1');
        g_form.setValue('confirmation', requestedForDisplay + ' - ' + fullAccessToPersonDisplay);
    }
}

onChange client script for leaverPersonDisplay:

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue === '') {
        return;
    }

    var requestedForDisplay = g_form.getDisplayValue('requested_for');
    var leaverPersonDisplay = g_form.getDisplayValue('select_the_name_of_the_leaver_whose_mailbox_you_need_full_access_to');

    if (leaverPersonDisplay) {
        g_form.setValue('confirmation', requestedForDisplay + ' - ' + leaverPersonDisplay);
    }

    // Move the following alert statement inside the if block if you want it to execute conditionally
    alert('test2');
}

 Hope this will resolves your current issue and let me know if anything else is remaining.
 

Let me know your views on this and Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

Thanks,

Aniket