[Problem] Generate PDF File with Start Expression

Hi all,

Left picture is my google docs template and as higlighted in red is my child table within it (Related Delivery Order). When I generate PDF file, the row is create depending on delivery order I have but unfortunately, the row that is generate from the child table push my signature, comment data to be over the page as shown in right picture.

Any solution to fix the row from child table so it stay within the page?

Thank you all

I am not sure if this will solve your problem but unless the number of child rows is always below a certain number (in that case, you should adjust your font size to always fit everything in one pate) , there is no way to ensure that.

One thing I would do is to have your signature line at the top so that it is always on the first page.

2 Likes

Thank you for your suggestion. I think that by adjust font size will not work.

If there is no other solution I would have to put my signature above the page instead.

Yes, AppSheet workflow/report templates currently do not inherently support pagination.

You may want to take a look at the following Tips and Tricks posts.

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Workflow-pagination-headers-and-footers/m-p/382764 by @Jonathon

Another one by @SkrOYC

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Part-2-Pixel-perfect-paginated-reports/m-p/416951

3 Likes

I think with HTML you can place your signature at the bottom (“footer”) of the page no matter the content before ir

3 Likes

Not work for me

Did you try it?

1 Like

Yes

Can you share the HTML template you made to see if I can help?

2 Likes

I just change the format from PDF to HTML but still not working

This is HTML:

Part 2: Pixel perfect paginated reports - Google Cloud Community

I could make an HTML template for you if you share me your current one

3 Likes

I am not good at coding. Is there an easy way for me to solve this problem?

I don’t think so, because it seems it’s not supported. I’m offering you a workaround if you send me your current template to make a new one using HTML/CSS for you

2 Likes

Whta I have to do is to download the visual studio code right? I downloaded it already. Next I have to write a code (create template using HTML) and send to you right?

This is HTML from Appsheet:

ol{margin:0;padding:0}table td,table th{padding:0}.c40{border-right-style:solid;padding:5pt 5pt 5pt 5pt;border-bottom-color:#000000;border-top-width:1pt;border-right-width:1pt;border-left-color:#000000;vertical-align:top;border-right-color:#000000;border-left-width:1pt;border-top-style:solid;border-left-style:solid;border-bottom-width:1pt;width:552.1pt;border-top-color:#000000;border-bottom-style:solid}.c15{border-right-style:solid;padding:5pt 5pt 5pt 5pt;border-bottom-color:#000000;border-top-width:1pt;border-right-width:1pt;border-left-color:#000000;vertical-align:top;border-right-color:#000000;border-left-width:1pt;border-top-style:solid;border-left-style:solid;border-bottom-width:1pt;width:321pt;border-top-color:#000000;border-bottom-style:solid}.c20{border-right-style:solid;padding:5pt 5pt 5pt 5pt;border-bottom-color:#000000;border-top-width:1pt;border-right-width:1pt;border-left-color:#000000;vertical-align:top;border-right-color:#000000;border-left-width:1pt;border-top-style:solid;border-left-style:solid;border-bottom-width:1pt;width:177pt;border-top-color:#000000;border-bottom-style:solid}.c10{border-right-style:solid;padding:5pt 5pt 5pt 5pt;border-bottom-color:#000000;border-top-width:1pt;border-right-width:1pt;border-left-color:#000000;vertical-align:top;border-right-color:#000000;border-left-width:1pt;border-top-style:solid;border-left-style:solid;border-bottom-width:1pt;width:184pt;border-top-color:#000000;border-bottom-style:solid}.c14{border-right-style:solid;padding:5pt 5pt 5pt 5pt;border-bottom-color:#000000;border-top-width:1pt;border-right-width:1pt;border-left-color:#000000;vertical-align:middle;border-right-color:#000000;border-left-width:1pt;border-top-style:solid;border-left-style:solid;border-bottom-width:1pt;width:207.8pt;border-top-color:#000000;border-bottom-style:solid}.c38{border-right-style:solid;padding:5pt 5pt 5pt 5pt;border-bottom-color:#000000;border-top-width:1pt;border-right-width:1pt;border-left-color:#000000;vertical-align:top;border-right-color:#000000;border-left-width:1pt;border-top-style:solid;border-left-style:solid;border-bottom-width:1pt;width:207.8pt;border-top-color:#000000;border-bottom-style:solid}.c11{border-right-style:solid;padding:5pt 5pt 5pt 5pt;border-bottom-color:#000000;border-top-width:1pt;border-right-width:1pt;border-left-color:#000000;vertical-align:middle;border-right-color:#000000;border-left-width:1pt;border-top-style:solid;border-left-style:solid;border-bottom-width:1pt;width:113.2pt;border-top-color:#000000;border-bottom-style:solid}.c25{border-right-style:solid;padding:5pt 5pt 5pt 5pt;border-bottom-color:#000000;border-top-width:1pt;border-right-width:1pt;border-left-color:#000000;vertical-align:middle;border-right-color:#000000;border-left-width:1pt;border-top-style:solid;border-left-style:solid;border-bottom-width:1pt;width:177pt;border-top-color:#000000;border-bottom-style:solid}.c26{border-right-style:solid;padding:5pt 5pt 5pt 5pt;border-bottom-color:#000000;border-top-width:1pt;border-right-width:1pt;border-left-color:#000000;vertical-align:top;border-right-color:#000000;border-left-width:1pt;border-top-style:solid;border-left-style:solid;border-bottom-width:1pt;width:113.2pt;border-top-color:#000000;border-bottom-style:solid}.c29{border-right-style:solid;padding:7.2pt 7.2pt 7.2pt 7.2pt;border-bottom-color:#000000;border-top-width:1pt;border-right-width:1pt;border-left-color:#000000;vertical-align:top;border-right-color:#000000;border-left-width:1pt;border-top-style:solid;border-left-style:solid;border-bottom-width:1pt;width:566.5pt;border-top-color:#000000;border-bottom-style:solid}.c28{border-right-style:solid;padding:5pt 5pt 5pt 5pt;border-bottom-color:#000000;border-top-width:1pt;border-right-width:1pt;border-left-color:#000000;vertical-align:top;border-right-color:#000000;border-left-width:1pt;border-top-style:solid;border-left-style:solid;border-bottom-width:1pt;width:438pt;border-top-color:#000000;border-bottom-style:solid}.c6{border-right-style:solid;padding:5pt 5pt 5pt 5pt;border-bottom-color:#000000;border-top-width:1pt;border-right-width:1pt;border-left-color:#000000;vertical-align:top;border-right-color:#000000;border-left-width:1pt;border-top-style:solid;border-left-style:solid;border-bottom-width:1pt;width:551.2pt;border-top-color:#000000;border-bottom-style:solid}.c5{border-right-style:solid;padding:5pt 5pt 5pt 5pt;border-bottom-color:#000000;border-top-width:1pt;border-right-width:1pt;border-left-color:#000000;vertical-align:middle;border-right-color:#000000;border-left-width:1pt;border-top-style:solid;border-left-style:solid;border-bottom-width:1pt;width:230.2pt;border-top-color:#000000;border-bottom-style:solid}.c32{border-right-style:solid;padding:5pt 5pt 5pt 5pt;border-bottom-color:#000000;border-top-width:1pt;border-right-width:1pt;border-left-color:#000000;vertical-align:middle;border-right-color:#000000;border-left-width:1pt;border-top-style:solid;border-left-style:solid;border-bottom-width:1pt;width:53.2pt;border-top-color:#000000;border-bottom-style:solid}.c27{border-right-style:solid;padding:5pt 5pt 5pt 5pt;border-bottom-color:#000000;border-top-width:1pt;border-right-width:1pt;border-left-color:#000000;vertical-align:middle;border-right-color:#000000;border-left-width:1pt;border-top-style:solid;border-left-style:solid;border-bottom-width:1pt;width:551.2pt;border-top-color:#000000;border-bottom-style:solid}.c12{border-right-style:solid;padding:5pt 5pt 5pt 5pt;border-bottom-color:#000000;border-top-width:1pt;border-right-width:1pt;border-left-color:#000000;vertical-align:top;border-right-color:#000000;border-left-width:1pt;border-top-style:solid;border-left-style:solid;border-bottom-width:1pt;width:53.2pt;border-top-color:#000000;border-bottom-style:solid}.c17{color:#000000;font-weight:400;text-decoration:none;vertical-align:baseline;font-size:14pt;font-family:"Arial";font-style:normal}.c19{color:#000000;font-weight:400;text-decoration:none;vertical-align:baseline;font-size:13pt;font-family:"Arial";font-style:normal}.c0{color:#000000;font-weight:400;text-decoration:none;vertical-align:baseline;font-size:11pt;font-family:"Times New Roman";font-style:normal}.c16{color:#000000;font-weight:400;text-decoration:none;vertical-align:baseline;font-size:14pt;font-family:"Times New Roman";font-style:normal}.c3{color:#000000;font-weight:400;text-decoration:none;vertical-align:baseline;font-size:17pt;font-family:"Arial";font-style:normal}.c30{color:#000000;font-weight:400;text-decoration:none;vertical-align:baseline;font-size:8pt;font-family:"Times New Roman";font-style:normal}.c8{color:#000000;font-weight:400;text-decoration:none;vertical-align:baseline;font-size:11pt;font-family:"Arial";font-style:normal}.c35{color:#000000;font-weight:700;text-decoration:none;vertical-align:baseline;font-family:"Arial";font-style:normal}.c4{padding-top:0pt;padding-bottom:0pt;line-height:1.0;text-align:left;height:11pt}.c21{padding-top:1pt;padding-bottom:0pt;line-height:0.5;text-align:left;height:20pt}.c2{padding-top:0pt;padding-bottom:0pt;line-height:1.0;text-align:right}.c1{padding-top:0pt;padding-bottom:0pt;line-height:1.0;text-align:center}.c37{padding-top:0pt;padding-bottom:0pt;line-height:0.06;text-align:left}.c23{border-spacing:0;border-collapse:collapse;margin-right:auto}.c31{padding-top:0pt;padding-bottom:1pt;line-height:0.06;text-align:left}.c7{padding-top:0pt;padding-bottom:0pt;line-height:1.0;text-align:left}.c9{background-color:#ffffff;font-size:14pt;font-weight:700}.c39{background-color:#ffffff;max-width:566.5pt;padding:0pt 14.4pt 0pt 14.4pt}.c34{font-family:"Times New Roman";font-weight:400}.c13{height:0pt}.c36{font-weight:700}.c22{font-size:13pt}.c24{height:11pt}.c18{font-size:14pt}.c33{height:21pt}.title{padding-top:24pt;color:#000000;font-weight:700;font-size:36pt;padding-bottom:6pt;font-family:"Arial";line-height:1.0;page-break-after:avoid;text-align:left}.subtitle{padding-top:18pt;color:#666666;font-size:24pt;padding-bottom:4pt;font-family:"Georgia";line-height:1.0;page-break-after:avoid;font-style:italic;text-align:left}li{color:#000000;font-size:11pt;font-family:"Arial"}p{margin:0;color:#000000;font-size:11pt;font-family:"Arial"}h1{padding-top:32pt;color:#000000;font-weight:700;font-size:20pt;padding-bottom:18pt;font-family:"Arial";line-height:1.149999976158142;text-align:left}h2{padding-top:29.2pt;color:#000000;font-weight:700;font-size:16pt;padding-bottom:17.2pt;font-family:"Arial";line-height:1.149999976158142;text-align:left}h3{padding-top:28pt;color:#434343;font-weight:700;font-size:14pt;padding-bottom:16pt;font-family:"Arial";line-height:1.149999976158142;text-align:left}h4{padding-top:26.8pt;color:#666666;font-weight:700;font-size:12pt;padding-bottom:16.8pt;font-family:"Arial";line-height:1.149999976158142;text-align:left}h5{padding-top:24.8pt;color:#666666;font-weight:700;font-size:11pt;padding-bottom:16.8pt;font-family:"Arial";line-height:1.149999976158142;text-align:left}h6{padding-top:30pt;color:#666666;font-weight:700;font-size:11pt;padding-bottom:22pt;font-family:"Arial";line-height:1.149999976158142;font-style:italic;text-align:left}table tr { break-inside: avoid; } table td { overflow-wrap: anywhere; }

āļšāļĢāļīāļĐāļąāļ— āļŠāđˆāļ‡āđ€āļŠāļĢāļīāļĄāļ­āļīāļ™āđ€āļ•āļ­āļĢāđŒāļ„āļđāļĨ āļŠāđ€āļ•āļ™āđ€āļĨāļŠ āļˆāļģāļāļąāļ”

105 āļŦāļĄāļđāđˆ 3 āļ–āļ™āļ™āļŠāļēāļĒāđ€āļ­āđ€āļ‹āļĩāļĒ āļ•āļģāļšāļĨāļšāđ‰āļēāļ™āļŦāļĄāđ‰āļ­ āļ­āļģāđ€āļ āļ­āļžāļĢāļŦāļĄāļšāļļāļĢāļĩ

āļˆāļąāļ‡āļŦāļ§āļąāļ”āļŠāļīāļ‡āļŦāđŒāļšāļļāļĢāļĩ 16120 Tel. 036-699440-1 Fax. 036-699442

āđƒāļšāļŠāđˆāļ‡āļŠāļīāļ™āļ„āđ‰āļē/DELIVERY ORDER

āļŠāļ·āđˆāļ­āļĨāļđāļāļ„āđ‰āļē : āļšāļˆ.āđ€āļ­āđ€āļˆ āļ„āļīāļ—āđ€āļŠāđˆāļ™ āđāļ­āļ™āļ”āđŒāđ€āļ‹āļ­āļĢāđŒāļ§āļīāļŠ

āđ€āļĨāļ‚āļ—āļĩāđˆāđƒāļšāļŠāļąāđˆāļ‡āļ‚āļ­āļ‡ : DO-AC/22050001

āļ—āļĩāđˆāļ­āļĒāļđāđˆāļˆāļąāļ”āļŠāđˆāļ‡ : āđ‚āļĢāļ‡āļ‡āļēāļ™āļŠāļĄāļļāļ—āļĢāļŠāļēāļ„āļĢ

āļ§āļąāļ™āļ—āļĩāđˆāļ­āļ­āļ : 04/05/22

Part Number

Model Name

Series No

Quantity

SRF30687AS591S

REACH-IN FREEZER (2 x half SS Door) (SRF3-0687-AS)

SRF3675A-220400102

1

SCR31807AR591S

STAINLESS STEEL UNDER COUNTER COOLER (NOFROST) (SCR3-1807-AR)

SCR3875A-220400116

1

SSC31507591AS

COUNTER REFRIGERATOR FULL TOP SALAD BAR (SSC3-1507 AR)

SSC3575A-220400015

1

SSC31507591AS

COUNTER REFRIGERATOR FULL TOP SALAD BAR (SSC3-1507 AR)

SSC3575A-220400015

1

SSC31507591AS

COUNTER REFRIGERATOR FULL TOP SALAD BAR (SSC3-1507 AR)

SSC3575A-220400015

1

SSC31507591AS

COUNTER REFRIGERATOR FULL TOP SALAD BAR (SSC3-1507 AR)

SSC3575A-220400015

1

SSC31507591AS

COUNTER REFRIGERATOR FULL TOP SALAD BAR (SSC3-1507 AR)

SSC3575A-220400015

1

āļˆāļģāļ™āļ§āļ™āļĢāļ§āļĄ : 7

āļŦāļĄāļēāļĒāđ€āļŦāļ•āļļ :

āļ—āļ°āđ€āļšāļĩāļĒāļ™āļĢāļ– : āļ™āļēāļĒ āļ āļžāļ™āļīāļžāļīāļ āļ—āļąāļšāđ€āļ‡āļīāļ™ āļ™āļēāļĒ āļˆāļīāļĢāļ°āļžāļąāļ™āļ˜āđŒ āļĢāļļāđˆāļ‡āđ€āļĢāļ·āļ­āļ‡ āļ™āļēāļĒ

___________________________

āļœāļđāđ‰āļ­āļ™āļļāļĄāļąāļ•āļī

(Authorized Person)

___________________________

āļœāļđāđ‰āļŠāđˆāļ‡āļ‚āļ­āļ‡

(Carrier)

___________________________

āļœāļđāđ‰āļĢāļąāļšāļ‚āļ­āļ‡

(Receiver)