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.
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/3827... by @Jonathon
Another one by @SkrOYC
I think with HTML you can place your signature at the bottom ("footer") of the page no matter the content before ir
Not work for me
Did you try it?
Yes
Can you share the HTML template you made to see if I can help?
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
I am not good at coding. Is there an easy way for me to solve this problem?
@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
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:
<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"><span class="c0"></span></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"><p class="c24 c37"><span class="c0"></span></p><a id="t.d7c62adec1f2b6d477321bce7b539f7536811900"></a><a id="t.1"></a><table class="c23"><tbody><tr class="c13"><td class="c26" colspan="1" rowspan="1"><p class="c7"><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="" /></span></p></td><td class="c28" colspan="3" rowspan="1"><h1 class="c7" id="h.65xpcc4xbbi3"><span class="c18 c35">เธเธฃเธดเธฉเธฑเธ เธชเนเธเนเธชเธฃเธดเธกเธญเธดเธเนเธเธญเธฃเนเธเธนเธฅ เธชเนเธเธเนเธฅเธช เธเธณเธเธฑเธ</span></h1><p class="c7"><span>105 </span><span class="c22">เธซเธกเธนเน</span><span> 3 </span><span class="c19">เธเธเธเธชเธฒเธขเนเธญเนเธเธตเธข เธเธณเธเธฅเธเนเธฒเธเธซเธกเนเธญ เธญเธณเนเธ เธญเธเธฃเธซเธกเธเธธเธฃเธต</span></p><p class="c7"><span class="c22">เธเธฑเธเธซเธงเธฑเธเธชเธดเธเธซเนเธเธธเธฃเธต</span><span> 16120 Tel. 036-699440-1 Fax. 036-699442</span></p></td></tr><tr class="c13"><td class="c6" colspan="4" rowspan="1"><p class="c1"><span class="c18">เนเธเธชเนเธเธชเธดเธเธเนเธฒ</span><span>/DELIVERY ORDER</span></p></td></tr><tr class="c13"><td class="c15" colspan="2" rowspan="1"><p class="c7"><span class="c17">เธเธทเนเธญเธฅเธนเธเธเนเธฒ : เธเธ.เนเธญเนเธ เธเธดเธเนเธเนเธ เนเธญเธเธเนเนเธเธญเธฃเนเธงเธดเธช</span></p></td><td class="c5" colspan="2" rowspan="1"><p class="c2" id="h.yjaie9kvv467"><span class="c18">เนเธฅเธเธเธตเนเนเธเธชเธฑเนเธเธเธญเธ :</span><span class="c8"> DO-AC/22050001</span></p></td></tr><tr class="c13"><td class="c15" colspan="2" rowspan="1"><p class="c7"><span class="c17">เธเธตเนเธญเธขเธนเนเธเธฑเธเธชเนเธ : เนเธฃเธเธเธฒเธเธชเธกเธธเธเธฃเธชเธฒเธเธฃ</span></p></td><td class="c5" colspan="2" rowspan="1"><p class="c2" id="h.yjaie9kvv467-1"><span class="c18">เธงเธฑเธเธเธตเนเธญเธญเธ :</span><span class="c8"> 04/05/22</span></p></td></tr><tr class="c13"><td class="c11" colspan="1" rowspan="1"><p class="c1"><span class="c8">Part Number</span></p></td><td class="c14" colspan="1" rowspan="1"><p class="c1" id="h.yjaie9kvv467-2"><span class="c8">Model Name</span></p></td><td class="c25" colspan="1" rowspan="1"><p class="c1" id="h.yjaie9kvv467-3"><span class="c8">Series No</span></p></td><td class="c32" colspan="1" rowspan="1"><p class="c1" id="h.yjaie9kvv467-4"><span class="c8">Quantity</span></p></td></tr><tr class="c13"><td class="c11" colspan="1" rowspan="1"><p class="c7"><span class="c8">SRF30687AS591S</span></p></td><td class="c14" colspan="1" rowspan="1"><p class="c7" id="h.yjaie9kvv467-5"><span class="c8">REACH-IN FREEZER (2 x half SS Door) (SRF3-0687-AS)</span></p></td><td class="c25" colspan="1" rowspan="1"><p class="c1" id="h.yjaie9kvv467-6"><span class="c8">SRF3675A-220400102</span></p></td><td class="c32" colspan="1" rowspan="1"><p class="c1"><span class="c8">1</span></p></td></tr><tr class="c13"><td class="c11" colspan="1" rowspan="1"><p class="c7"><span class="c8">SCR31807AR591S</span></p></td><td class="c14" colspan="1" rowspan="1"><p class="c7" id="h.yjaie9kvv467-5"><span class="c8">STAINLESS STEEL UNDER COUNTER COOLER (NOFROST) (SCR3-1807-AR)</span></p></td><td class="c25" colspan="1" rowspan="1"><p class="c1" id="h.yjaie9kvv467-6"><span class="c8">SCR3875A-220400116</span></p></td><td class="c32" colspan="1" rowspan="1"><p class="c1"><span class="c8">1</span></p></td></tr><tr class="c13"><td class="c11" colspan="1" rowspan="1"><p class="c7"><span class="c8">SSC31507591AS</span></p></td><td class="c14" colspan="1" rowspan="1"><p class="c7" id="h.yjaie9kvv467-5"><span class="c8">COUNTER REFRIGERATOR FULL TOP SALAD BAR (SSC3-1507 AR)</span></p></td><td class="c25" colspan="1" rowspan="1"><p class="c1" id="h.yjaie9kvv467-6"><span class="c8">SSC3575A-220400015</span></p></td><td class="c32" colspan="1" rowspan="1"><p class="c1"><span class="c8">1</span></p></td></tr><tr class="c13"><td class="c11" colspan="1" rowspan="1"><p class="c7"><span class="c8">SSC31507591AS</span></p></td><td class="c14" colspan="1" rowspan="1"><p class="c7" id="h.yjaie9kvv467-5"><span class="c8">COUNTER REFRIGERATOR FULL TOP SALAD BAR (SSC3-1507 AR)</span></p></td><td class="c25" colspan="1" rowspan="1"><p class="c1" id="h.yjaie9kvv467-6"><span class="c8">SSC3575A-220400015</span></p></td><td class="c32" colspan="1" rowspan="1"><p class="c1"><span class="c8">1</span></p></td></tr><tr class="c13"><td class="c11" colspan="1" rowspan="1"><p class="c7"><span class="c8">SSC31507591AS</span></p></td><td class="c14" colspan="1" rowspan="1"><p class="c7" id="h.yjaie9kvv467-5"><span class="c8">COUNTER REFRIGERATOR FULL TOP SALAD BAR (SSC3-1507 AR)</span></p></td><td class="c25" colspan="1" rowspan="1"><p class="c1" id="h.yjaie9kvv467-6"><span class="c8">SSC3575A-220400015</span></p></td><td class="c32" colspan="1" rowspan="1"><p class="c1"><span class="c8">1</span></p></td></tr><tr class="c13"><td class="c11" colspan="1" rowspan="1"><p class="c7"><span class="c8">SSC31507591AS</span></p></td><td class="c14" colspan="1" rowspan="1"><p class="c7" id="h.yjaie9kvv467-5"><span class="c8">COUNTER REFRIGERATOR FULL TOP SALAD BAR (SSC3-1507 AR)</span></p></td><td class="c25" colspan="1" rowspan="1"><p class="c1" id="h.yjaie9kvv467-6"><span class="c8">SSC3575A-220400015</span></p></td><td class="c32" colspan="1" rowspan="1"><p class="c1"><span class="c8">1</span></p></td></tr><tr class="c13"><td class="c11" colspan="1" rowspan="1"><p class="c7"><span class="c8">SSC31507591AS</span></p></td><td class="c14" colspan="1" rowspan="1"><p class="c7" id="h.yjaie9kvv467-5"><span class="c8">COUNTER REFRIGERATOR FULL TOP SALAD BAR (SSC3-1507 AR)</span></p></td><td class="c25" colspan="1" rowspan="1"><p class="c1" id="h.yjaie9kvv467-6"><span class="c8">SSC3575A-220400015</span></p></td><td class="c32" colspan="1" rowspan="1"><p class="c1"><span class="c8">1</span></p></td></tr><tr class="c33"><td class="c27" colspan="4" rowspan="1"><p class="c1"><span class="c18"> เธเธณเธเธงเธเธฃเธงเธก : </span><span class="c18 c36">7</span></p></td></tr></tbody></table><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><p class="c4"><span class="c0"></span></p><a id="t.8e8a13c487510f7cecaabc281d1b9e66d70b5de5"></a><a id="t.2"></a><table class="c23"><tbody><tr class="c13"><td class="c40" colspan="3" rowspan="1"><p class="c7"><span class="c16">เธซเธกเธฒเธขเนเธซเธเธธ : </span></p><p class="c7"><span class="c18 c34">เธเธฐเนเธเธตเธขเธเธฃเธ : เธเธฒเธข เธ เธเธเธดเธเธดเธ เธเธฑเธเนเธเธดเธ เธเธฒเธข เธเธดเธฃเธฐเธเธฑเธเธเน เธฃเธธเนเธเนเธฃเธทเธญเธ เธเธฒเธข </span></p></td></tr><tr class="c13"><td class="c10" colspan="1" rowspan="1"><p class="c4"><span class="c8"></span></p><p class="c7"><span class="c8">___________________________</span></p><p class="c1"><span class="c18">เธเธนเนเธญเธเธธเธกเธฑเธเธด</span></p><p class="c1"><span>(Authorized Person)</span></p></td><td class="c10" colspan="1" rowspan="1"><p class="c4"><span class="c8"></span></p><p class="c7"><span class="c8">___________________________</span></p><p class="c1"><span class="c18">เธเธนเนเธชเนเธเธเธญเธ</span></p><p class="c1"><span>(Carrier)</span></p></td><td class="c10" colspan="1" rowspan="1"><p class="c4"><span class="c8"></span></p><p class="c7"><span class="c8">___________________________</span></p><p class="c1"><span class="c18">เธเธนเนเธฃเธฑเธเธเธญเธ</span></p><p class="c1"><span>(Receiver)</span></p></td></tr></tbody></table><p class="c4"><span class="c0"></span></p></td></tr></tbody></table><p class="c24 c31"><span class="c30"></span></p></body></html>
User | Count |
---|---|
17 | |
12 | |
5 | |
5 | |
5 |