Update and Delete Entries from MRVS

Jenni sree
Tera Contributor

Hi Everyone,

We have a reference variable on a record producer which is referencing to the User table and we have MRVS on the same itself. We have written a script to update this MRVS to add groups based on the user selected.
For Example : If the user is part of three groups, then three rows will be added in the MRVS. 

Now we need to make validation is such a way that :-

1. If user delete any row out of the three auto updated rows in the MRVS, then deletion should also reflect in the group membership table, Example- if the user is part of A,B,C and the rows are added in MRVS are also A,B,C, if I remove 'C' entry and submit the request, then user should be only in A,B but not in C.

2. If I make any update to the entries that are added to MRVS, same update should also reflect on the group membership table, Example- if I change the group name of 'A' to 'AB' the same update should also reflect on the group.

Please help me to get the validation script ASAP. Thanks in advance.

1 REPLY 1

en-zo
Tera Contributor

Looking a solution to a similar requirement. Was this ever get solved?