API Demo: Creating a Formatted and Printable View of a Row
Here is a demonstration of a feature I created using SmartSheet's API.
Let's say you want to print all or some content of a row. Or perhaps you want a nicely formatted and easy to read view of the row. The specific use case addressed here is to print a copy of a school library order for new materials. This print out will be placed with the physical books or other materials when they are sent out from the school district central library to the schools.
When viewing a row in SmartSheet, there is a cell that contains a URL created by a formula. It links to a web application I created. Clicking this link, takes you to a web page that displays the nicely printable order/shipping form.
I have a very short video of how this works for the end user, and an image of what the printable page looks like is below.
Note: this is part of a much larger project using the SmartSheet API. I will share more of the features I have built in the future. I am looking into being able to share some of the node.js code.
Thanks for posting! i like to see what other people are doing with smartsheet
Thanks for sharing. I hope to understand this more after reading a few times. Please post more!
Thanks for sharing!
I look forward to what you post next!
Have a fantastic day!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
If you are looking to share the code, I suggest something like GitHub or BitBucket. You'll want to segment the parts you consider proprietary. I try to keep the non-proprietary stuff still functional. If it isn't, then it is a waste of the other developers' time to figure out the missing pieces.
Absolutely will use git, most likely GitHub.
I currently work for a public* school district, but have long experience consulting using open source tools for clients and dealing with the sometimes difficult issues of what is required to be contributed back to the community and keeping the proprietary stuff separate.
Ideally, I will be able share a functional and useful project. At least, I hope to share some code snippets -- gists -- to inspire others.
The toughest part of this project is the lack of example code beyond SmartSheet's own GitHub and Stackoverflow comments. (Actually, the toughest part past been learning Node.js after more than 15 years of mostly python coding)
* "Public" in the USA meaning
For most API work I prefer Python. I assume you use node.js because it can be easier with website integrations.
I found just searching for 'smartsheet' on the GItHub repos got enough hits to be useful, usually.
Having used Python since the 1990's, it is my first choice language for data analysis, web development, sysadmin tasks, etc.
Fast-Forward 1-year........ @leejoramo , were you ever able to "package" something functional for your "Print View" API project? I am extremely interested if there is a path forward to replicate something along these lines. Thanks.
i did not get how to do such printable version
did you upload your code or code snippets to GitHub?
This would be extremely helpful for a project I'm working on.