[Problem] Generate PDF File with Start Expression

maxmaxmax222 · 05-03-2022 08:24 PM

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

TeeSee1

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.

maxmaxmax222

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.

Suvrutt_Gurjar

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/3827... by @Jonathon

Another one by @SkrOYC

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

SkrOYC

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

maxmaxmax222

Not work for me

SkrOYC

Did you try it?

maxmaxmax222

Yes

SkrOYC

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

maxmaxmax222

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

SkrOYC

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

maxmaxmax222

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

SkrOYC

@maxmaxmax222 wrote:
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

maxmaxmax222

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?

maxmaxmax222

This is HTML from Appsheet:

<html><head><meta content="text/html; charset=UTF-8" http-equiv="content-type" /><style type="text/css">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; }</style></head><body class="c39"><h1 class="c21"></h1><a id="t.095cee0e05c28e39acaa35eb094d559fbd0fb6d0"></a><a id="t.0"></a><table class="c23"><tbody><tr class="c13"><td class="c29" colspan="1" rowspan="1"><a id="t.d7c62adec1f2b6d477321bce7b539f7536811900"></a><a id="t.1"></a><table class="c23"><tbody><tr class="c13"><td class="c26" colspan="1" rowspan="1"><span style="overflow: hidden; display: inline-block; margin: 0.00px 0.00px; border: 0.00px solid #000000; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px); width: 137.89px; height: 58.50px;"><img alt="" src="https://lh4.googleusercontent.com/ANcSZ7xO8V9gx6kj1wBYe_lfU78TPsA_dqt_7PwWhiW4Fq7_youMo2EXULw7dZAZDG..." style="width: 137.89px; height: 58.50px; margin-left: 0.00px; margin-top: 0.00px; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px);" title="" /></td><td class="c28" colspan="3" rowspan="1"><h1 class="c7" id="h.65xpcc4xbbi3">บริษัท ส่งเสริมอินเตอร์คูล สเตนเลส จำกัด</h1>105 หมู่ 3 ถนนสายเอเซีย ตำบลบ้านหม้อ อำเภอพรหมบุรีจังหวัดสิงห์บุรี 16120 Tel. 036-699440-1 Fax. 036-699442</td></tr><tr class="c13"><td class="c6" colspan="4" rowspan="1">ใบส่งสินค้า/DELIVERY ORDER</td></tr><tr class="c13"><td class="c15" colspan="2" rowspan="1">ชื่อลูกค้า : บจ.เอเจ คิทเช่น แอนด์เซอร์วิส</td><td class="c5" colspan="2" rowspan="1">เลขที่ใบสั่งของ : DO-AC/22050001</td></tr><tr class="c13"><td class="c15" colspan="2" rowspan="1">ที่อยู่จัดส่ง : โรงงานสมุทรสาคร</td><td class="c5" colspan="2" rowspan="1">วันที่ออก : 04/05/22</td></tr><tr class="c13"><td class="c11" colspan="1" rowspan="1">Part Number</td><td class="c14" colspan="1" rowspan="1">Model Name</td><td class="c25" colspan="1" rowspan="1">Series No</td><td class="c32" colspan="1" rowspan="1">Quantity</td></tr><tr class="c13"><td class="c11" colspan="1" rowspan="1">SRF30687AS591S</td><td class="c14" colspan="1" rowspan="1">REACH-IN FREEZER (2 x half SS Door) (SRF3-0687-AS)</td><td class="c25" colspan="1" rowspan="1">SRF3675A-220400102</td><td class="c32" colspan="1" rowspan="1">1</td></tr><tr class="c13"><td class="c11" colspan="1" rowspan="1">SCR31807AR591S</td><td class="c14" colspan="1" rowspan="1">STAINLESS STEEL UNDER COUNTER COOLER (NOFROST) (SCR3-1807-AR)</td><td class="c25" colspan="1" rowspan="1">SCR3875A-220400116</td><td class="c32" colspan="1" rowspan="1">1</td></tr><tr class="c13"><td class="c11" colspan="1" rowspan="1">SSC31507591AS</td><td class="c14" colspan="1" rowspan="1">COUNTER REFRIGERATOR FULL TOP SALAD BAR (SSC3-1507 AR)</td><td class="c25" colspan="1" rowspan="1">SSC3575A-220400015</td><td class="c32" colspan="1" rowspan="1">1</td></tr><tr class="c13"><td class="c11" colspan="1" rowspan="1">SSC31507591AS</td><td class="c14" colspan="1" rowspan="1">COUNTER REFRIGERATOR FULL TOP SALAD BAR (SSC3-1507 AR)</td><td class="c25" colspan="1" rowspan="1">SSC3575A-220400015</td><td class="c32" colspan="1" rowspan="1">1</td></tr><tr class="c13"><td class="c11" colspan="1" rowspan="1">SSC31507591AS</td><td class="c14" colspan="1" rowspan="1">COUNTER REFRIGERATOR FULL TOP SALAD BAR (SSC3-1507 AR)</td><td class="c25" colspan="1" rowspan="1">SSC3575A-220400015</td><td class="c32" colspan="1" rowspan="1">1</td></tr><tr class="c13"><td class="c11" colspan="1" rowspan="1">SSC31507591AS</td><td class="c14" colspan="1" rowspan="1">COUNTER REFRIGERATOR FULL TOP SALAD BAR (SSC3-1507 AR)</td><td class="c25" colspan="1" rowspan="1">SSC3575A-220400015</td><td class="c32" colspan="1" rowspan="1">1</td></tr><tr class="c13"><td class="c11" colspan="1" rowspan="1">SSC31507591AS</td><td class="c14" colspan="1" rowspan="1">COUNTER REFRIGERATOR FULL TOP SALAD BAR (SSC3-1507 AR)</td><td class="c25" colspan="1" rowspan="1">SSC3575A-220400015</td><td class="c32" colspan="1" rowspan="1">1</td></tr><tr class="c33"><td class="c27" colspan="4" rowspan="1"> จำนวนรวม : 7</td></tr></tbody></table><a id="t.8e8a13c487510f7cecaabc281d1b9e66d70b5de5"></a><a id="t.2"></a><table class="c23"><tbody><tr class="c13"><td class="c40" colspan="3" rowspan="1">หมายเหตุ : ทะเบียนรถ : นาย ภพนิพิฐ ทับเงิน นาย จิระพันธ์ รุ่งเรือง นาย </td></tr><tr class="c13"><td class="c10" colspan="1" rowspan="1">___________________________ผู้อนุมัติ(Authorized Person)</td><td class="c10" colspan="1" rowspan="1">___________________________ผู้ส่งของ(Carrier)</td><td class="c10" colspan="1" rowspan="1">___________________________ผู้รับของ(Receiver)</td></tr></tbody></table></td></tr></tbody></table></body></html>