How to populate a multi row variable set based on selected variables in a catalogue item

[matthew_hughes]

I'm the below catalogue item where users have to select their options:

On the final part of my catalogue item, I have a multi row variable set where I'm wanting to add the selected details:

Does anyone know how I need to populate my multi row variable set with the selected options?

[matthew_hughes]

Hi @Ankur Bawiskar  This is the client script that I'm using:

function onChange(control, oldValue, newValue, isLoading) {

    //If form is loading, do nothing

    if (isLoading) {

        return;

    //If the list of Business Applications to update is cleared, clear the Multi Row variable set

    } else if (newValue == '') {

        g_form.setValue('selected_business_applications', []);

    //Each time a Business Application is added, add a row for each Business Application with the other variables

    } else {

        var businessApplications = g_form.getDisplayValue('business_applications_to_update');

        var businessApplicationNumber = g_form.getReference('business_applications_to_update');

        var currentPlatform = g_form.getDisplayValue('current_owning_platform');

        var newPlatform = g_form.getDisplayValue('new_platform');

        var newLab = g_form.getDisplayValue('new_lab_department');

        var appsArr = businessApplications.split(',');

        var apps = [];

        for (var i = 0; i < appsArr.length; i++) {

            apps.push({

                'current_business_owning_platform_variable_set': currentPlatform,

                'new_platform_variable_set': newPlatform,

                'new_lab_level_platform_child_variable_set': newLab,

                'business_application_owner_variable_set': applicationOwner,

                'business_application_name_variable_set': appsArr[i],

            });

        }

        g_form.setValue('selected_business_applications', JSON.stringify(apps));

    }

}

However, this is what I notice when I select multiple business applications on my catalogue item:

I'm wanting the Business Application Number and Business Application Owner columns to be populated as well with the details from the selected business applications. Do you know what I need to include my client script?

[Ankur Bawiskar]

@matthew_hughes 

simply fetch the value from the table's field and set in json

I could see you are already setting the business_application_owner_variable_set is that not what you want?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[matthew_hughes]

I'm trying to get the value to that field, but it returns as blank.

[Ankur Bawiskar]

@matthew_hughes 

please use GlideAjax as you will have to query the table and get the values

[Ankur Bawiskar]

@matthew_hughes 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.