MRVS & List Collector

[JohnnySnow]

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

[Ankur Bawiskar]

@JohnnySnow 

how are you tracking/maintaining a user holds how many positions?

[JohnnySnow]

@Ankur Bawiskar Using this table 'sn_hr_core_job' below is the form view

and below is the table for the position id

[Ankur Bawiskar]

@JohnnySnow 

ok so if user holds 4 positions then there will be 4 records in table "sn_hr_core_job"?

[JohnnySnow]

correct @Ankur Bawiskar 

[Ankur Bawiskar · Accepted solution]

@JohnnySnow 

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

javascript:'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