Workflow pagination

AppSheet AppSheet Q&A
, , ,
1

Hi, I just wonder how to make pages number in our template.

For example, I’ve created reports (pdf) with many pages, and now want to show number in every pages.

When I created the pages in Google Doc it worked. but When I created from bot automation it didn’t.

Any idea?

thanks

2

Not possible.

3

You have to experiment with your own template to figure out how much content fits on each single page. Then you have to manually build each page yourself, typically with page breaks and large <> <> blocks.

For example, if I have a report set up that uses a START expression to output X number of records, and I know 15 records can fit on the first page after the header info, then 20 records can fit on each page afterwards, I’d set up something like this.

Header info
<<START: TOP( .... , 15 )>>
<<[col1]>> <<[col2]>> ...
<<END>>
Page: 1

<<IF: COUNT( ... ) > 15>>
-------page-break--------
<<START: TOP( .... , 15+20 ) - TOP( ... , 15)>>
<<[col1]>> <<[col2]>> ...
<<END>>
Page: 2
<<ENDIF>>

<<IF: COUNT( ... ) > 15+20>>
-------page-break--------
<<START: TOP( .... , 15+20+20 ) - TOP( ... , 15+20)>>
<<[col1]>> <<[col2]>> ...
<<END>>
Page: 3
<<ENDIF>>

....etc....
4

Thanks, @Steve

5

Thanks @Marc_Dillon , i’m trying. It’s helpful info