Recently came across a limitation of MRVS multi-row variable set that it cannot access the form variables. Meaning if you have a Catalog item form with 'Requested For' variable and an MRVS multi-row variable set, and would like to have the requested_for field value to be carried forward to MRVS scope, it's not possible and that creates limitation for scripting, setting filter criteria for your MRVS variables. Most of you who have worked with MRVS and tried to fetch the values from the form will be able relate better:
I found the answer in using the browser session for storing catalog form values and retrieving them on your MRVS:
//Store the value in the session storage:
sessionStorage.setItem("requested_for", ""+g_form.getValue('requested_for'));
//Retrieving the session value
var req_for = sessionStorage.getItem("requested_for");
Let's get into details of our use case about 'Requested For' and accessing its value in the 'MRVS'. I have attached the updateset for the explanation below.
After you created the catalog item, variable(requested_for), and the MRVS variable set, start with the below:
Step1: Write a Catalog Client Script to store value onChange
Name: Store Value req_for (onChange)
UI Type: All
Type: OnChange
Applies to: A Catalog item
Catalog item: <Your catalog item name>
Variable name: requested_for
Script:
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
if (typeof(Storage) !== "undefined") {
sessionStorage.setItem("requested_for", ""+g_form.getValue('requested_for'));
} else {
alert("Sorry, your browser does not support Web Storage...");
}
}
Step2: Write another Catalog Client Script to store value onLoad
Name: Store Value req_for (onLoad)
UI Type: All
Type: OnLoad
Applies to: A Catalog item
Catalog item: <Your catalog item name>
Script:
function onLoad() {
if (typeof(Storage) !== "undefined") {
sessionStorage.setItem("requested_for", ""+g_form.getValue('requested_for'));
} else {
alert("Sorry, your browser does not support Web Storage...");
}
}
Step 3:Write one last Catalog Client Script to Retrieve value onLoad
Name: Retrieve Value req_for (onLoad)
UI Type: All
Type: OnLoad
Applies to: A Variable Set
Variable Set: <Your MRVS name>
Script:
function onLoad() {
var req_for = sessionStorage.getItem("requested_for");
g_form.setValue('tb_requested_for',req_for);
}
//Your MRVS should have a variable named 'tb_requested_for', and the value will appear
The above example shows you how to store value from the form and then retrieve it on the MRVS page, you can save multiple form values and retrieve them in MRVS, Once you retrieve these values on the MRVS, you will be able to use it for MRVS.variables filter criteria, or for multiple other reasons.
If you find this article helpful. Please comment and hit like.
Glad the solution helped you and thanks for marking it helpful.
About the session storage limitation, few that are top of my mind are:
Its like cache memory, The data is deleted when the user closes the specific browser tab. But that should not affect in most cases, as with the tab closure, the form data also is lost and has to be refilled
I have not tested with the 'same browser, multiple tabs' working on the same form.
I want to display table on Service Catalog. I have tried using Multi-Row variable Set. By default MRVS Order is 100 then it is visible on form, but the MRVS has to visible in middle of service catalog form. So I have changed order number of MRVS variable set then it is not visible on form. Can any one help me out with this problem.
Not sure if you have already got the solution, but if it helps, just number the MRVS in sequence where you want it. For example if you want it between variables with order 100 and 300, make your variable set order as 200.
Hi Ashish , this helped me a lot to populate info into MRVS variable from outside, i tried to apply reference qualifiers using this field , but it is not working . please let me know can we apply reference qualifiers in MRVS ?
Starting Quebec, you can now use the g_service_catalog API which is available in all environments, such as, Service Portal, Now Platform, Workspace, and Now® Mobile
Starting Quebec, you can now use the g_service_catalog API which is available in all environments, such as, Service Portal, Now Platform, Workspace, and Now® Mobile
Hi, I have a it different scenario. I have cost in the MRVS where we add cost as per rows. I want to add the cost and populate in other variable whenever a new row is added with cost.
As you can see 100 + 300 should populate in Total cost.
Lets suppose if I add new row with cost 200 then it should automatically calculate 100+300+200 and show it in Total cost. Is it possible?
Mentioned solution works well. Since the post is from 2020, I would suggest an alternative solution using g_service_catalog - getValue(String variableName).
We use cookies on this site to improve your browsing experience, analyze individualized usage and website traffic, tailor content to your preferences, and make your interactions with our website more meaningful. To learn more about the cookies we use and how you can change your preferences, please read our Cookie Policy and visit our Cookie Preference Manager. By clicking “Accept and Proceed,” closing this banner or continuing to browse this site, you consent to the use of cookies.
