Replicating a spreadsheet in Servicenow

alvinbm1
Tera Expert

Hello,

The anyone successfully replicated a spreadsheet in Service Now.   (Also maybe created a form that looks like the spreadsheet as well)   I have   a spreadsheet that is shared among multiple consultants and we are unable to put it on google drive and nor do have collective access to SharePoint.   I'm thinking about creating a customized table, but what about the form to enter the data.   Replicating this spreadsheet in Service Now would be helpful because we have to link to Change and Incident records.     Please advise.

Thank you.

Sample of the spreadsheet:

find_real_file.png

1 ACCEPTED SOLUTION

geoffcox
Giga Guru

Hi Alvin!



We often do this now on UI pages that make efficient use of AngularJS. For example, our firewall rule editor:



find_real_file.png



You separately asked about our old demo where we had a page that looked like the old spreadsheet folks used to pass around, which we did deliberately in order to achieve acceptance of the new report. This was a UI page with a lot of html, jquery, and css:



find_real_file.png


I can discuss methods further if you need to (but I can't just copy all the code).



Cheers,


              Geoff.


View solution in original post

3 REPLIES 3

Chuck Tomasi
Tera Patron

Hi Alvin,



I encourage you to reach out to Reed at UXStorm he was working on something along the lines of this. I don't know if it made it in the ServiceNow store yet or not. It's worth a check.


darius_koohmare
ServiceNow Employee
ServiceNow Employee

One of the main points is to move away from a spreadsheet, not reproduce it


I would advise a custom table, where you make the columns of the spreadsheet fields, and each row in the spreadsheet is one record.


Then you can make yourself a list view/list report that looks similar (if you have too many columns though won't visualize nicely).


geoffcox
Giga Guru

Hi Alvin!



We often do this now on UI pages that make efficient use of AngularJS. For example, our firewall rule editor:



find_real_file.png



You separately asked about our old demo where we had a page that looked like the old spreadsheet folks used to pass around, which we did deliberately in order to achieve acceptance of the new report. This was a UI page with a lot of html, jquery, and css:



find_real_file.png


I can discuss methods further if you need to (but I can't just copy all the code).



Cheers,


              Geoff.