Multi Row Variable Set Auto Delete Selected Entry

lopchris27
Tera Contributor

‎10-08-2024 10:32 PM

Good day my fellow ServiceNow enthusiasts!

Hope you're all doing well and hope you could give me some advise on my concern. ^_^

 

I have a record producer that has a feature of saving the submitted details as draft.

There's also two (2) Multi Row Variable Sets:

1. External Stakeholders

2. Project Contact Person

 

We are using the 1st MRVS to get the Company name, address, contact number, description/role. The 2nd MRVS we used it to get the contact persons associated to the Business on the 1st MRVS. The 2nd MRVS have these fields:

Contact Person name, email, mobile, Company name (choices are from the 1st MRVS).

 

*1 Business can have more than 1 or 2 contact persons

 

What our client wants is if the user deleted the company from the 1st MRVS. The contact person/s on 2nd MRVS (person associated to the deleted company from 1st MRVS) should be automatically deleted.

 

What could be the approach for this requirement?

 

Hoping for your suggestions. Thank you.

0 Helpfuls
  • 305 Views
1 REPLY 1

Brad Bowman
Kilo Patron
Kilo Patron

‎10-09-2024 02:45 AM

Do you need to see the change to the 2nd MRVS on request form or target record as/when the row is deleted? Is another possibility that a user would edit a row and change the company name, etc or is this variable read only when populated to prevent this?  Are you using a workspace / ESC / Service Portal, or the native UI only?  

0 Helpfuls