Template: how to force long text in a cell of a table to stay in the same sheet ?

[FaCe]

Hi,

i’ve a bot that create a new pdf file.

My template has table with cells in it where insert my columns data.

If “task” column (long-text) has many text in it instead of continue on the second line of the sheet the whole text is moved on the second page. How to make the text to stay on the first page jumping to the second page only when the text (of task column) has filled the whole first page ?

[dbaum]

What file format is your template?

[FaCe]

Google Doc

[dbaum]

Allow row to overflow across pages

[FaCe]

Thanks it works like a charm … it instead my <<[RG]>> column data is blank how to avoid to show it in the template ?

[dbaum]

Use If expressions in templates - AppSheet Help

You may need two versions of the table–one with and one without the RG row.

[FaCe]

Unfortunately it’s inconsistent … sometimes works sometimes no …