Extract values from attachments and create records in Custom table

Sapz
Tera Contributor

Hi All,

We have an requirement from our team to create records in custom table. Vendors would like to create tickets in SNOW who do not have access to the portal, hence we proposed creation of records through email. However they would like to attachments as well. 

They would like to submit the all the fields of the form in the excel which needs to be extracted and created a record in custom table. Could you please provide any suggestions on how to extract the values in the excel and create records in custom tables with appropriate field values.

 

Eg: Custom Table Name - Legal Documents

Fields- Name, Customer, Location, Area etc.

 

7 REPLIES 7

RAHUL Khanna1
Mega Guru
Can you please mark this as helpful/Answered and close the thread.

Ankur Bawiskar
Tera Patron
Tera Patron

@Sapz 

Hope you are doing good.

Let me know if I have answered your question.

If so, please mark appropriate reply as correct & helpful so others with similar questions/issues can find your posting quickly.

Regards
Ankur

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

Ankur Bawiskar
Tera Patron
Tera Patron

@Sapz 

Please remember to close the thread by marking appropriate reply as correct and helpful so that this question moves to answered list.

Regards
Ankur

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