Import rows to MRVS from the Excel/CSV attachment in Catalog item form before submit.

rc26
Tera Contributor

‎06-29-2023 10:38 PM

HI,

 

We have a requirement where we want to copy data from spreadsheet and add in multi row variable set when file attached using attachment icon in catalog item form in service portal. Please help us with the steps.

 

Thanks!!

0 Helpfuls
  • 521 Views
5 REPLIES 5

Ankur Bawiskar
Tera Patron
Tera Patron

‎06-30-2023 12:24 AM

@rc26 

check this link

Attach csv to catalog item to populate a Multi Row Variable Set (MRVs) 

 

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

rc26
Tera Contributor
In response to Ankur Bawiskar

‎06-30-2023 03:33 AM - edited ‎06-30-2023 03:36 AM

But we don't have macro variable type available. If I use custom how to show that macro in catalog form?

And also want to know when this code runs?

0 Helpfuls

Ankur Bawiskar
Tera Patron
Tera Patron
In response to rc26

‎06-30-2023 03:36 AM

@rc26 

you can create one as per the link

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

rc26
Tera Contributor
In response to Ankur Bawiskar

‎06-30-2023 03:53 AM

Our requirement is after uploading the attachment, we want to show one button kind of one. On click of it the data from attachment should get copied to MRVS before submitting the form. I have created the UI Macro. But to create a macro type variable in catalog item, I dont see that variable type. How to show such macro in catalog form.

0 Helpfuls