MRVS & List Collector

JohnnySnow · ‎05-09-2023

Hi Team,

I have a requirement as below:

1. We have a record producer for employee separation, wherein we can select the user who is separating from the organization.

2. A user can have multiple positions & the positions & few other details are populated in a MRVS on the form. (this is readonly on the form as of now)

3. Now, the challenge is, when a user is separating from a specific position, we need a way to select individual records from the mrvs and process only that.

Is there a way to allow users to select individual record from mrvs? We are not planning to use the edit/remove

buttons on the mrvs.

Can we use listcollector to achieve this requirement? or any other way by which we can achieve this?

Thanks

Thanks
Johnny

Please mark this response as correct or helpful if it assisted you with your question.

Ankur Bawiskar · ‎05-09-2023

@JohnnySnow

then you can have list collector referring to this table with filter as

javascript&colon;'user=' + gs.getUserID();

It will show all the positions user is holding and then user will select which position to be removed.

once RITM is submitted you will know which positions to remove and which positions user hold(by querying that table) then do the next process

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Anil Lande · ‎05-09-2023

Hi Johny,

Your question is not clear.

Can you please elaborate more on below point?

Is there a way to allow users to select individual record from mrvs? --- Where you want user to select individual record?

How user will process each individual record?

Do you want to access each record using script?

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

JohnnySnow · ‎05-09-2023

Hi Anil,

Is there a way to allow users to select individual record from mrvs? --- Where you want user to select individual record?

>> I wanted to understand if the user can select a record(s) from the MRVS, which can be further processed.

How user will process each individual record?

>> User will only select the record from MRVS (if we are going ahead with MRVS solution), the selected record is basically the position from which the user is resigning.

Do you want to access each record using script?

>> I was actually looking for a way to select multiple position from a list of positions (of a user). I was figuring out if it was possible through MRVS or List Collector.

Hope it makes sense, if not please do let me know.

Thanks
Johnny

Please mark this response as correct or helpful if it assisted you with your question.

Ankur Bawiskar · ‎05-09-2023

@JohnnySnow

Is position stored somewhere in a table? How it is mapped with User record? If position is stored in some table and there is a link between that table and User then you can use list collector and auto-populate it with the user's position and ask them to keep the positions which they wish to keep. Once RITM is submitted you know which position users want to keep since user has kept those values in list collector and you know which positions he/she was actually holding from that mapping.

Do whatever processing you want to do

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

JohnnySnow · ‎05-09-2023

Hi @Ankur Bawiskar I tried to do that using list collector but we need the position id to process further, which I'm not sure how to achieve using a list collector. What I mean is: if user selects a position from the list collector, how can I know the position id of the selected position(the position id is a custom field as shown below).

If this works then we can continue to use list collector, else I need to figure out other solution.

Thanks

Thanks
Johnny

Please mark this response as correct or helpful if it assisted you with your question.