Need some help for create pdf file

[Wilco_kuis]

I have created an task to create a pdf file, see the code i use in google docs.

This code works fine, but what i want is for each different teacher(zwemdocent). That on a new page a new overview is created with the customers who belong with that teacher.

And the teachers can be different each time. 

Current code and output.

Totaal overzicht A Maand1

Maand:	Naam:	Zwemdocent
<<start: ORDERBY(FILTER(“A Maand1”,TRUE),[Zwemdocent],TRUE)>> <<[Naam]>>	<<[Naam]>>	<<[zwemdocent]>><<end>>

The output is as expected, total table with all customers and teachers.

etc.etc.

This is what i want if there are 2 different teachers instead of 1 table

1 page/table overview for each teacher, in this case the are 2 different teachers( 1 and 2 for example)

Can you guy's help me out, to create the right code?

Already thanks.

Wilco,

[SkrOYC · Accepted solution]

This starts to get into advance territory with nested Start: expressions and [_THISROW-n]stuff.
Check this:

Solved: Re: PAGE BREAKS IN PDFS - Google Cloud Community

[SkrOYC · Accepted solution]

This starts to get into advance territory with nested Start: expressions and [_THISROW-n]stuff.
Check this:

Solved: Re: PAGE BREAKS IN PDFS - Google Cloud Community

[WillowMobileSys · Accepted solution]

---

@Wilco_kuis wrote:

Totaal overzicht A Maand1

Maand:	Naam:	Zwemdocent
<<start: ORDERBY(FILTER(“A Maand1”,TRUE),[Zwemdocent],TRUE)>> <<[Naam]>>	<<[Naam]>>	<<[zwemdocent]>><<end>>

---

You will wan to "wrap" the code above in another START/END set of functions that will cycle through the list of Teachers.  Something like

<<START: Teachers[Teacher ID]>>

Totaal overzicht A Maand1

Maand:	Naam:	Zwemdocent
<<start: ORDERBY(FILTER(“A Maand1”,TRUE),[Zwemdocent],TRUE)>> <<[Naam]>>	<<[Naam]>>	<<[zwemdocent]>><<end>>

...{ Add any Teacher Summary details here}

{Add Page Break here to put next teacher on a new page}

<<END>>

NOTE: You will want to adjust your inner START expression to filter by the teacher from the outer START expression and likely move your ORDERBY function to the outer START.

[Wilco_kuis]

It works :-), thanks.

Result each page a different teacher.