Printing multiple pdf labels with sequential number

[QP-Tech]

H

Really new to AppSheet  and before I get to involved I want to know if it would be possible to generate a multiple page pdf with a sequential number for each page.

I want to be able to print box labels 100 x 100 mm.

The information is the same on each label other than the box label which increase by 1 each time.

• Job number static
• description Static
• Box Quantity static
• Box Number sequential (increases by 1 )

I have a column that works out the number of boxes / labels required.

Really appreciate some help and guidance.

[Marc_Dillon]

Yes, it's possible, but it's not a trivial thing to do. 'Pagination' would be a good search term to use.

[AleksiAlkio]

How many numbers do you need to print? What's the maximum?

[QP-Tech]

Hi

The most we have had so far is 300 boxes, but would be good to do up to 999 if needed.

[AleksiAlkio]

So you would print 2 labels in one page or just one?

[AleksiAlkio]

Another Q.. do you have any table with more than 1000 rows alread?

[AleksiAlkio]

Lets assume you have one table (Rows) where you have more rows than 1000 and none of those rows are deleted. Then you have another table called "Labels" and you want to trigger the Bot from that row.

On you label template (in your Bot), you can trigger those 1000 rows like <<Start: ORDERBY(SELECT(Rows[Key],[_rownumber]<1001),[_rownumber],TRUE)>><<[_rownumber]>> <<[_THISROW].[Job Number]>><<End>>.

This will generate a loop for you with 1000 rows and if you set the template properly so each label is printed once on a paper, you have it. Though you need to add formulas for your static values on that template as well.