Generate documents from parent and children rows
Is it possible to generate one document from multiple rows?
Best example I can think of would be an itemized order with multiple items in the order - how can you list all order items from that parent row (order number) with the item ordered [qty, price, detail information] on the children rows? Having columns to fill on the same row not feasible as we frequently have more than 80 separate items to list with qty, price and other details and would max out the sheet without listing all the orders in process.
It would need to expand to multiple pages as needed (2 or 3 common) but still be only 1 page on a frequent basis.
Answers
-
Hi @ZennerJ
I hope you're well and safe!
Unfortunately, it's not possible now, but it's an excellent idea!
Possible workarounds
- 3rd-party service
- Smartsheet API
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@ZennerJ Hi! The only way to do this natively in Smartsheet with document builder would to have a field on the parent row that would collect all the child information you needed and format it with line breaks. So, in your document you'd have to have a large field that could display a block of information such as:
Item 1 - qty 100
Item 2 - qty 52
Item 3 - qty 10
....
Now that wouldn't work if it needed to span multiple pages though or if you wanted it in a tabular format with grid lines. The only way to do that would be to use a something like Appsheet that could generate reports in that format... That actually sounds like a good idea for a video. I'll have to look into making a video on doing that as I think it would be a good Appsheet/Smartsheet integration use case. Or, a custom API script written that would generate the reports in the format you need.
@Andrée Starå You must have been replying at the same time as I was. Sorry for some duplication.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!