Solved: Overflowing table rows on appsheet generated docum...

Samson21 · 10-14-2024 05:42 AM

Hello, I have a problem about the PDF that i'm generating via appsheet. I wanted to make a quotation, where the contents are in a form of tables.

There's this one particular row that has a lot of contents (takes data from appsheet in longtext form) and i want to make the contents overflow between pages. I have the button to "allow row to overflow across pages" checked, but when I generate the PDF, it doesn't work (that contents moved onto the next page, leaving an awkward blank)

I have tried it before and it was successful but I don't know what I did today that made it go wrong again. Could you please help?

Thank you in advance

Steve

Is there any other way to make this work?

Use an HTML template, then you have complete control.

is there any expression that works like Start: expression but can be used for list type column?

Not directly. If the elements of your list are of type Ref, you can use them. Another approach would be to create a table specifically to do what you want. The table would have one column, of type Number. You'd add as many rows as you think you'd ever have list items, with the Number column values ranging from 1 to whatever that most number is. Then you can use this table in your <<Start>> tag to generate indexes into the list.

View solution in original post

WillowMobileSys

@Samson21 wrote:

that contents moved onto the next page, leaving an awkward blank

It's not clear what yo mean by this. Can you show examples of the issue and what you expect?

Samson21

Sorry for the confusion.

This is the template that i am using to generate PDF with appsheet, and as you can see here, i have checked the box "Allow row to overflow accross pages"

But this is the result that I got after I generate the PDF

The row doesn't overflow, leaving an awkward blank.

Steve

There are many Docs layout options that are ignored by AppSheet. This is one of them.

AppSheet reports are not aware of page breaks, so they cannot adjust layout to accommodate them.

Samson21

Is there any other way to make this work? is there any expression that works like Start: expression but can be used for list type column?

Steve

Is there any other way to make this work?

Use an HTML template, then you have complete control.

is there any expression that works like Start: expression but can be used for list type column?

Not directly. If the elements of your list are of type Ref, you can use them. Another approach would be to create a table specifically to do what you want. The table would have one column, of type Number. You'd add as many rows as you think you'd ever have list items, with the Number column values ranging from 1 to whatever that most number is. Then you can use this table in your <<Start>> tag to generate indexes into the list.

Samson21

Thank you for the idea 🙏

Overflowing table rows on appsheet generated document