- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-14-2018 09:29 AM
I need to know how i can fill out an attached excel spreadsheet in a script, ui action, etc.
A record on a custom table has an excell spreadsheet attached. I would like to have a UI Action that takes values from the ServiceNow form and insert them into the Excel spreadsheet.
Is this possible?
Solved! Go to Solution.
- Labels:
-
Integrations
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2018 07:06 AM
I have resolved this issue by creating a MID Server script include to modify the excel spreadsheet

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-14-2018 09:36 AM
I don't think its possible to update an existing attachment, all you can do is create a new one, that's all.!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-14-2018 09:41 AM
would i be able to retrieve the attachment, update the data in the attachment and add the updated attachment to the record. So if the UI Action were selected multiple times there would be an additional attachment that was filled out in addition to the original "raw or source" attachment.
If so, how would i go about updating the excel spreadsheet.
Thanks for your quick response

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-14-2018 09:49 AM
There is a way to retrieve data from an attachment. You can modify the data after retrieving it and then create a new attachment with the modified data, that's the best you could do i guess. Please take a look at this link.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-14-2018 09:55 AM
Thanks for the info I will see where I get and let you know.