Generate Excel from record
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-06-2024 05:48 AM
Hi,
I have a record producer. I want to generate a excel of the submitted values after submitting the record. how to do?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-06-2024 05:50 AM
Check the link below. IT shows a way to do this via FLow Designer.
How to generate excel file from a script in Servic... - ServiceNow Community

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-06-2024 05:57 AM
this will be the manual process ;
Once the record is submitted, go to the table where the record was created. This would be the table you specified when creating the record producer. Once you're in the table, click on the cogwheel icon in the top right corner of the list and select "Export > Excel". This will download an Excel file containing all the records in the table, including the one you just submitted.
But, For automating this process, you may need to write a script that is triggered upon submission of the record producer, which then generates an excel file with the submitted values.
Please let me know if need help on script.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-06-2024 06:00 AM
Flow will not work i guess as it is a RP. Correct me if I am wrong.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-06-2024 06:01 AM
I havent tried, you will need to fiddle around it a bit. you can always use it on the table record