Upload excel sheet with records from servicenow table

tanz
Tera Expert

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

 

3 REPLIES 3

Mark Manders
Mega Patron

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

Business wants to download this is in a bulktemplate format  with their fieldsbecause it can futher used in some other activity (integartion)

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