question Possible to remove a choice from a reference variable if it is already selected in a Multirow Variable set? in Developer forum

Possible to remove a choice from a reference variable if it is already selected in a Multirow Variable set?

Kris V — Wed, 23 Mar 2022 22:31:06 GMT

I've got a Multirow variable set that is set up to return users only associated to a common cost center - that part works great.

What I am wondering is if there is something out there that can remove a choice from that reference list once that user has been selected. Currently I can select the user, fill out the mandatory fields and Add them to the MRVS. Then when I click "Add" again, that same user is still there and available for selection. Once they are selected I'd like to remove them.

Has anyone ever done this or know how?

Here is an example of what I am talking about - I have already selected myself and added my record to the MRVS, but when I click Add again, I am still there available for selection.

Re: Possible to remove a choice from a reference variable if it is already selected in a Multirow Variable set?

PB20201617 — Thu, 24 Mar 2022 00:19:20 GMT

You should be able to utilize an advanced reference qualifier to update the choices available within the list field based on prior input from the user.

Take a look at a similar example here: https://community.servicenow.com/community?id=community_question&sys_id=8fd60853db946410fb115583ca961971

Re: Possible to remove a choice from a reference variable if it is already selected in a Multirow Variable set?

Michael Jones - — Thu, 24 Mar 2022 00:20:20 GMT

So you could potentially do this, with quite a bit of difficulty and probably some undesired side-effects.

The only method I could think of would require you to write the selected users back to your catalog item with each row submit, and on each row load pull in that list to a hidden field on the MRVS (hidden on the modal but not on the row list) and then write a complicate reference qualifier to take the value of the field, and modify your query with a bunch of "^sys_id!=" statements to exclude the already selected users.

You would have to use some unorthodox methods to be able to write values from within the MRVS to the form and then load them back with each row, and you would have to do this as you can only reference fields on the MRVS form itself as part of a reference qualifier.

As an alternative you might consider using the "unique" checkbox on the variable itself. That would prevent the user from adding multiple rows with that same value.

I hope this helps!

If this was helpful, or correct, please be kind and mark the answer appropriately.

Michael Jones - Proud member of the GlideFast Consulting Team!

Re: Possible to remove a choice from a reference variable if it is already selected in a Multirow Variable set?

naveen14 — Thu, 24 Mar 2022 07:30:05 GMT

Hi @Kris V

OOB we had an option but it will show the user to select but it won't accept to add .

Solution :

you can find this(Unique , Unique Values Only)2 fields for each variable. On username field you can make this 2 fields as true then it won't allow duplicate entry.

Regards,

Naveen

Re: Possible to remove a choice from a reference variable if it is already selected in a Multirow Variable set?

Murthy Ch — Thu, 24 Mar 2022 07:49:18 GMT

@Kris V

You can check the Unique Checkbox on JMP User Name

So that you cannot select the same user again but the user is still visible on the list but you cant add the row.

Same explained in my article. Refer this:

https://community.servicenow.com/community?id=community_article&sys_id=a0dcbf0fdbbc8150e515c22305961941

Thanks,

Murthy

Re: Possible to remove a choice from a reference variable if it is already selected in a Multirow Variable set?

Kris V — Thu, 24 Mar 2022 14:05:00 GMT

Thanks for the reply - I am already using the unorthodox method to push cost center in to the MRVS which is what the advanced ref qualifier on the user name field is filtered off of.

I will try the unique checkbox, although I thought when I looked yesterday there wasn't an option for that on the variable.

(Just checked and it wasn't on the form, I will add it and give that a shot)

Re: Possible to remove a choice from a reference variable if it is already selected in a Multirow Variable set?

Kris V — Thu, 24 Mar 2022 14:06:56 GMT

That works for limiting it, which is good enough! Thanks!