Copy value from excel to multi row variable set when attachment added in catalog form

Siddharth4
Tera Contributor

‎08-01-2023 07:03 AM

Hi,

 

I have created a MRVS having 4 rows and an attachment button in a catalog Item form in a portal. I have a requirement that when user added an attachment then all the value will be copied to the MRVS.

We have a standard excel template which we will upload in the attachment variable. The excel sheet will have multiple columns and rows and we want the value of these rows to be copied to the MRVS just after the attachment get submitted in Item form.

Kindly suggest and provide the steps or script to achieve this functionality. 

 

Thanks 

 

0 Helpfuls
  • 214 Views
1 REPLY 1

Brad Bowman
Kilo Patron
Kilo Patron

‎08-01-2023 10:54 AM

I have done this by adding a label variable at the bottom of the form instructing the users to attach a file, then click the 'Import' link which is a UI Action that only appears on this Catalog Item.  The UI Action reads the attachment and populates the MRVS.  I'm doing this at the Catalog Task level in the native UI, but it should also work on the form in Portal? Let me know if the approach sounds like it would work and I can send you the UI Action script.

0 Helpfuls