Document Generator Not Wrapping Text to Multiple Lines

Coby.C · 07/25/24

Hi!

I am using the Document Builder to auto-generate PDF invoices with the information pulled from the row in an invoice generation sheet I created.

I created my PDF template and fillable form fields in Adobe Acrobat - and I specifically made the "Customer Billing Info" and "Client Billing Info" fields multi-line so that they can accommodate the information laid out in standard Name, Street Address, City State Zip format with paragraphs between each.

The billing info is being pulled from a singular cell that is referencing another sheet, with CHAR(10) in between each reference to add a paragraph break so it is in the above format.

For some reason, I can only get one of the two billing info fields to work at a time. Either the Customer Billing Info is correct and the Client Billing Info is just one long line of text, or vice versa — but not both.

Any suggestions?

Jason Tarpinian · 07/26/24

That's odd that either of them will work separately. If you've formatted the source to be multi-line and it's still doing that, I'm not sure. But could you just make the info into separate fields? It'd be a bit more work to set up, but instead of concatenating them with a line break, just make them all individual fields.

Coby.C · 07/26/24

https://community.smartsheet.com/discussion/comment/446496#Comment_446496

Yes it is very strange!

It's funny because I made the switch to joining the info to one cell and one field because it was messy and weird with line cutoffs in my first rendition separating it out into separate fields — seems like I will have to sacrifice one of them lol. Thank you!

Document Generator Not Wrapping Text to Multiple Lines

Answers

Categories