The CreatorCon Call for Content is officially open! Get started here.

Need add clip on Multi row set variable set

SNOW17
Tera Expert

 

We need assistance with a catalog item that contains a multi-row set variable. In the screenshot provided, we require the 'Clip' option to be added next to the 'Add' button. In order to obtain the attachment document, we believe we need to make batch bulk updates as shown below. Do you have any suggestions or approaches for fulfilling this requirement?

 

SNOW17_0-1707418075881.png

 

Thanks in advance.

 

2 ACCEPTED SOLUTIONS

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @SNOW17 

 

Adding clip is not possible next to Add. You can use standard attachment option only.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

@SNOW17 you might have to script for that by parsing the attached file and then use an API called GlideExcelParser() to get the data in excel and then map it to the respective variables.

For more info on the APi refer below document which has example code snippets on how to parse an excel.

 

https://developer.servicenow.com/dev.do#!/reference/api/vancouver/server/sn_impex-namespace/GlideExc...

 

Hope this helps 

Mark the answer correct if this helps you 

THanks 

Mohith Devatte.

 

 

 

View solution in original post

4 REPLIES 4

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @SNOW17 

 

Adding clip is not possible next to Add. You can use standard attachment option only.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Mohith Devatte
Tera Sage
Tera Sage

Hello @SNOW17 ,

You cant edit Multi row variable set working model as it is built OOB and changing it would effect it globally.

I can  suggest you a workaround for the same.

In the variable set you can create a variable which is of type "Attachment" which will allow you to add attachment for every record at row level.

For more info on the same please refer to below article.

https://www.servicenow.com/community/itsm-articles/attachment-variable-making-attachment-mandatory-i...

Hope this helps 

Mark the answer correct if this helps you 

THanks 

Mohith Devatte.

SNOW17
Tera Expert

Will uploading an Excel attachment populate the data into the variable set immediately upon attachment?

 

@SNOW17 you might have to script for that by parsing the attached file and then use an API called GlideExcelParser() to get the data in excel and then map it to the respective variables.

For more info on the APi refer below document which has example code snippets on how to parse an excel.

 

https://developer.servicenow.com/dev.do#!/reference/api/vancouver/server/sn_impex-namespace/GlideExc...

 

Hope this helps 

Mark the answer correct if this helps you 

THanks 

Mohith Devatte.