Hi! I’m trying to create an invoice using Document Builder.
I saw a video where they had a parent row with child rows underneath, and the child row items appeared in the generated invoice as separate lines. In the comments, they mentioned that Document Builder only generates from one row, so the child row data needs to be brought into the parent row using JOIN formulas.
I tried using a formula like: =JOIN(CHILDREN(), CHAR(10) + CHAR(10))
In Smartsheet, the values appear on separate lines, but when I generate the PDF, all the items appear in one single line instead.
For example, I need “Project Manager” to appear on one line and “Equipment Technician” on another line. This is just a small example, but sometimes I may have more than 10 or 20 items, so creating separate fields for each item would not be practical.
The PDF field is set as a multiline text field in Adobe Acrobat.
How can I make each child row item appear on a separate line in the generated PDF?
Thank you!