How to Limit a Reference Variable in an MRV for the same value selected in the first Row

[Peter Williams]

good morning everyone,

so i have a trick request to configure,

i have an MRV with a reference variables that is looking up on the cmn_department table

i want to have the ability to auto fill the other row users will select with the same value they selected in the first row of the MRV.

Example:

the Department Column u selected Office Expenses

i want every other row to only show Office Expenses and not have the users be able to select anything else but Office Expenses base on their first row

so all other rows will only have the Office Expense and nothing else

is this possible with an onChange script?

[DrewW]

Sounds like you need to create a client onLoad script that will look at the values in the MRV and populate the field and make it read only so they cannot change it.

[Peter Williams]

this is correct, the first value in the department [0] will determine the other department fields values > [1] in the array set

[DrewW]

So you should just need to get the value of the variable and use JSON.parse to convert it to an object and from there is should be easy to do.

[Peter Williams]

i am trying it but no success, any suggestion on how to write out the script for it?