multi row variable set including tables

Supraja M
Tera Contributor

HI, i have a multi row variable set for 20 entries. the first variable displays all the server names from the server table and we have to pick it. Now the condition is that when i select the server name for the first entry which has these fields "used for" = "production" and " location " = "montvale", inside the table data for that particular server name say "xyz".

so now the condition is i should display servers for the next 19 entries whose "used for" = "production" and " location " = "montvale". so it is completely dependent on the first entry, first server name i select for the other 19 entries. 

and also its hould not display the server names if the first server names location was empty.

can anyone please help me to script this or answer me for whatever possible way present.

 

6 REPLIES 6

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

it's very difficult to understand without any screenshots

what did you try so far?

Regards
Ankur

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

i am sharing the screenshot

 

i have added

 

maroon_byte
Mega Sage

Please correct my understanding:

In your MRVS table, the user sets first row. Once first row is set, you automatically want next 19 rows to be added for the same server name from first row only if location of the server in first row is not empty?

Question: Why do you need 20 rows for same server?

Fact: You cannot add additional rows automatically when submitting first row in MRVS. You need to have a button (custom variable with UI Marco for Native portal & Widget for Service Portal) outside of MRVS to perform actions such as make row copies. See if below helps:

Widget Variable to Copy MRVS rows