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

How to add excel doc to CI

gunishi
Tera Guru

Hi all, 

 

I have a requirement to allow user to attach an excel doc to a CI. 

 

How would I go about this and make sure that the excel sheet has 2 mandatory columns: 'Asset tag' and 'Host name'?

 

Thank you in advance. I am new to servicenow and appreciate all your help thus far.

 

Kind regards, 

G

2 REPLIES 2

Tushar
Kilo Sage
Kilo Sage

Hi @gunishi 

 

I think you can create a ServiceNow script include that contains the code to check if the Excel sheet has the two mandatory columns.

You can then use this script include in a UI action to prevent users from uploading Excel docs that do not have the required columns.

 

Please, don't forget to mark my answer as correct if it solves your issue or mark it as helpful if it is relevant for you!

Regards,
Tushar

Shahid3
Tera Contributor

Hey @gunishi

 

I am hoping you can find a solution in below thread.

 

https://www.servicenow.com/community/itsm-forum/how-to-validate-if-a-specific-file-e-g-user-xlsx-is-...

 

Regards,

Shahid