Upload excel sheet with records from servicenow table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2024 10:13 PM
Hi,
I have a excel sheet with few columns. test.xlsx
columns are below.
ID Details (the columns are in bold letters)
I want to create a UI action in list choice which will download this excel template.
Additionally , i want these fields to map to incident table, like ID is mapped of Number and Details is mapped to short description.
So for example, if I select the two incident numbers and click on UI action, it should give me data of those two incidents records in my excel sheet.
Also it should allow only 50 records to be selected at a time and when it exceeds on clicking the UI Action it should show pop up like "Selection exceeded 50 records".
Can anyone help me achieve this script
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2024 10:32 PM
What is your use case? What is the need to create something so custom, when the export functionality is already there (it will just export the real column names).
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2024 10:36 PM
Business wants to download this is in a bulktemplate format with their fieldsbecause it can futher used in some other activity (integartion)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2024 10:55 PM
Create custom excel export functionality and call that integration? I would go back to the business and talk about setting up a real integration. This requirement doesn't make sense.
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark