Goal
Generate a document for each row in a Smartsheet. The document needs to accommodate cells with varying amounts of text - from a few words to multiple paragraphs. The fields should expand/contract based on the text length.
Problem
PDF technology doesn't automatically resize fields based on text length. Fixing field size has two downsides:
- Text may get cut off if too lengthy for the field
- Field looks too big if text is short
Potential Solutions
Smartsheet could support output to formats like:
- MS Word - fields auto-adjust size
- Google Docs - fields auto-adjust size
- HTML - text can wrap automatically
This would allow fields to naturally expand/contract based on the amount of text in each cell.