This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Start expression in HTML reports

Posted on 09-28-2022 05:46 AM
muketaz
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

Hi everyone! Im trying to create a PDF report using a HTML template and getting some error that I think is realted to Start expression. All the expressions Im using were used in a DOC template that worked fine.

Appsheet Automation Monitoring Error:

Error encountered in step with name [Generar PDF orden confección]: Error: Task 'Generar PDF orden confección' Body template. Expression '[id_orden].[fecha]' is invalid due to: Unable to find column 'id_orden', did you mean 'fecha_orden'?. Error: Task 'Generar PDF orden confección' Body template. Expression '[nombre_producto]' is invalid due to: Unable to find column 'nombre_producto', did you mean 'nombre_orden'?. Error: Task 'Generar PDF orden confección' Body template. Expression '[talle_y_color]' is invalid due to: Unable to find column 'talle_y_color'. Error: Task 'Generar PDF orden confección' Body template. Expression '[tela_producto]' is invalid due to: Unable to find column 'tela_producto'. Error: Task 'Generar PDF orden confección' Body template. Expression '[molde_producto]' is invalid due to: Unable to find column 'molde_producto'. Error: Task 'Generar PDF orden confección' Body template. Expression '[bretel_producto]' is invalid due to: Unable to find column 'bretel_produ

HTML code sample:

<html>
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="content-type" />
    <style type="text/css">
      @import url("https://themes.googleusercontent.com/fonts/css?kit=OPeqXG-QxW3ZD8BtmPikfA");
        .body{
        display: flex;
        justify-content: center;
        }
        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 {
        color: #000000;
        font-weight: 700;
        font-size: 16pt;
        font-family: "Arial";
        line-height: 1.149999976158142;
        text-align: left;
      }
        h3 {
        color: #434343;
        font-weight: 700;
        font-size: 14pt;
        font-family: "Arial";
        line-height: 1.149999976158142;
        text-align: left;
      }
        h4 {
        color: #666666;
        font-weight: 700;
        font-size: 12pt;
        font-family: "Arial";
        line-height: 1.149999976158142;
        text-align: left;
      }
        h5 {
        color: #666666;
        font-weight: 700;
        font-size: 11pt;
        font-family: "Arial";
        line-height: 1.149999976158142;
        text-align: left;
      }
        h6 {
        color: #666666;
        font-weight: 700;
        font-size: 11pt;
        font-family: "Arial";
        line-height: 1.149999976158142;
        font-style: italic;
        text-align: left;
      }
        p {
        margin: 0;
        color: #000000;
        font-size: 11pt;
        font-family: "Arial";
        padding-bottom: 1rem;
      }
        .body__container{
            width: 100%;
            height: 100%;
            padding: 25pt;
        }
        
        .logo{
            display: flex;
            justify-content: end;
        }
        .logo img{
            width: 414px;
            height: 113px; 
        }
        .data{
            padding-top: 1rem;
        }
        .body__table{
            display: grid;
            grid-template-columns:repeat(9, 1fr) ;
            
        }
        .body__table--header{
            grid-row-start: 1;

        }
        .body__table--item{
            background-color: #c6c0fe57;
            margin: 5% 5% 5% 0%;
            padding: 2%;
            word-break: break-all;
        }


    </style>
  </head>
  <body class="body">
    <main class="body__container">
        <section class="body__conteiner--header">
            <span class="logo">
                <img src="images/image1.jpg" alt="">
            </span>
            <div class="data">
                <h2>ORDEN DE CONFECCI&Oacute;N N&deg; &lt;&lt;[numero_orden]&gt;&gt;</h2>
                <h3 id="h.r3wsdmz4xslq">Fecha: &lt;&lt;[fecha_orden]&gt;&gt;</h3>
                <p><span> Confeccionadora:</span><span>&nbsp;Patri</span></p>
            </div>
        </section>

        <a id="t.72a840b28ab1e37f4647889d73f9f378b07b65b7"></a><a id="t.0"></a>

        <section class="body__table">
            <div class="body__table--header"><span class="headerspan">N° compra</span></div>
            <div class="body__table--header"><span class="tablespan">Fecha</span></div>
            <div class="body__table--header"><span class="tablespan">Modelo</span></div>
            <div class="body__table--header"><span class="tablespan">Talle y Color</span></div>
            <div class="body__table--header"><span class="tablespan">Tela</span></div>
            <div class="body__table--header"><span class="tablespan">Moldería</span></div>
            <div class="body__table--header"><span class="tablespan">Breteles</span></div>
            <div class="body__table--header"><span class="tablespan">Elásticos</span></div>
            <div class="body__table--header"><span class="tablespan">Comentario</span></div>

            <div class="body__table--item">
              <p>
                <span class="itemspan">
                    <span>&lt;&lt;Start:Select(detalle_ordenes[id_detalle],
                        AND(or([Estado]=&rdquo;</span>

                    <span>Lista para confecci&oacute;n</span>

                    <span>&rdquo;,[Estado]=&quot;Problema de confecci&oacute;n&quot;),
                        [Confeccion]=&rdquo;</span>

                    <span>5FD0BAB8</span>

                    <span>&rdquo;))&gt;&gt;&lt;&lt;[numero de orden]&gt;&gt;</span>
                </span>
              </p>
            </div>
            <div class="body__table--item">
              <p>
                <span class="itemspan">
                    &lt;&lt;[id_orden].[fecha]&gt;&gt;
                </span>
              </p>
            </div>
            <div class="body__table--item"><p><span class="itemspan">&lt;&lt;[nombre_producto]&gt;&gt;</span></p></div>
            <div class="body__table--item"><p><span class="itemspan">&lt;&lt;[talle_y_color]&gt;&gt;</span></p></div>
            <div class="body__table--item"><p><span class="itemspan">&lt;&lt;[tela_producto]&gt;&gt;</span></p></div>
            <div class="body__table--item"><p><span class="itemspan">&lt;&lt;[molde_producto]&gt;&gt;</span></p></div>
            <div class="body__table--item"><p><span class="itemspan">&lt;&lt;[bretel_producto]&gt;&gt;</span></p></div>
            <div class="body__table--item"><p><span class="itemspan">&lt;&lt;[elasticos_producto]&gt;&gt;</span></p></div>
            <div class="body__table--item"><p><span class="itemspan">>&lt;&lt;[Notas del comprador]&gt;&gt;&lt;&lt;End&gt;&gt;</span></p></div>

            
            
        </section>

        <hr style="page-break-before: always; display: none" />
    <p class="c7"><span class="c2 c19 c22"></span></p>
    <h2 class="c1 c20" id="h.b0pisdwtlnwe">
      <span
        style="
          overflow: hidden;
          display: inline-block;
          margin: 0px 0px;
          border: 0px solid #000000;
          transform: rotate(0rad) translateZ(0px);
          -webkit-transform: rotate(0rad) translateZ(0px);
          width: 1123px;
          height: 113px;
        "
        ><img
          alt=""
          src="images/image1.jpg"
          style="
            width: 414px;
            height: 113px;
            margin-left: 694px;
            margin-top: 0px;
            transform: rotate(0rad) translateZ(0px);
            -webkit-transform: rotate(0rad) translateZ(0px);
          "
          title=""
      /></span>
    </h2>
    <h2 class="c1 c20" id="h.94ulgl1m56ep">
      <span class="c19"
        >ORDEN DE CONFECCI&Oacute;N N&deg; &lt;&lt;[numero_orden]&gt;&gt;
      </span>
    </h2>
    <h2 class="c1 c20" id="h.iw1ba4aveksa">
      <span class="c19">Fecha: &lt;&lt;[fecha_orden]&gt;&gt;</span>
    </h2>
    <p class="c1">
      <span>Confeccionadora</span><span>:</span
      ><span class="c2">&nbsp;Eri</span>
    </p>
    <a id="t.57bcb33d93e59227e0566adfa576a26ff4a49567"></a><a id="t.1"></a>
    <table class="c6">
      <tr class="c13">
        <td class="c18" colspan="1" rowspan="1">
          <p class="c4"><span class="c0">N&deg; compra</span></p>
        </td>
        <td class="c15" colspan="1" rowspan="1">
          <p class="c4"><span class="c0">Fecha</span></p>
        </td>
        <td class="c9" colspan="1" rowspan="1">
          <p class="c4"><span class="c0">Modelo</span></p>
        </td>
        <td class="c3" colspan="1" rowspan="1">
          <p class="c4"><span class="c0">Talle y Color</span></p>
        </td>
        <td class="c9" colspan="1" rowspan="1">
          <p class="c4"><span class="c0">Tela</span></p>
        </td>
        <td class="c12" colspan="1" rowspan="1">
          <p class="c4"><span class="c0">Molder&iacute;a</span></p>
        </td>
        <td class="c8" colspan="1" rowspan="1">
          <p class="c4"><span class="c0">Breteles</span></p>
        </td>
        <td class="c23" colspan="1" rowspan="1">
          <p class="c4"><span class="c0">El&aacute;sticos</span></p>
        </td>
        <td class="c17" colspan="1" rowspan="1">
          <p class="c4"><span class="c0">Comentario</span></p>
        </td>
      </tr>
      <tr class="c13">
        <td class="c18" colspan="1" rowspan="1">
          <p class="c21">
            <span class="c11"
              >&lt;&lt;Start:Select(detalle_ordenes[id_detalle],
              AND(or([Estado]=&rdquo;</span
            ><span class="c5">Lista para confecci&oacute;n</span
            ><span class="c11"
              >&rdquo;,[Estado]=&quot;Problema de confecci&oacute;n&quot;),
              [Confeccion]=&rdquo;</span
            ><span class="c5">CBAD64B5</span
            ><span class="c11"
              >&rdquo;))&gt;&gt;&lt;&lt;[numero de orden]&gt;&gt;</span
            >
          </p>
        </td>
        <td class="c15" colspan="1" rowspan="1">
          <p class="c4">
            <span class="c0">&lt;&lt;[id_orden].[fecha]&gt;&gt;</span>
          </p>
        </td>
        <td class="c9" colspan="1" rowspan="1">
          <p class="c4">
            <span class="c0">&lt;&lt;[nombre_producto]&gt;&gt;</span>
          </p>
        </td>
        <td class="c3" colspan="1" rowspan="1">
          <p class="c4">
            <span class="c0">&lt;&lt;[talle_y_color]&gt;&gt;</span>
          </p>
        </td>
        <td class="c9" colspan="1" rowspan="1">
          <p class="c4">
            <span class="c0">&lt;&lt;[tela_producto]&gt;&gt;</span>
          </p>
        </td>
        <td class="c12" colspan="1" rowspan="1">
          <p class="c4">
            <span class="c0">&lt;&lt;[molde_producto]&gt;&gt;</span>
          </p>
        </td>
        <td class="c8" colspan="1" rowspan="1">
          <p class="c4">
            <span class="c0">&lt;&lt;[bretel_producto]&gt;&gt;</span>
          </p>
          <p class="c4 c14"><span class="c0"></span></p>
        </td>
        <td class="c23" colspan="1" rowspan="1">
          <p class="c4">
            <span class="c0">&lt;&lt;[elasticos_producto]&gt;&gt;</span>
          </p>
        </td>
        <td class="c17" colspan="1" rowspan="1">
          <p class="c4">
            <span class="c0"
              >&lt;&lt;[Notas del comprador]&gt;&gt;&lt;&lt;End&gt;&gt;</span
            >
          </p>
        </td>
      </tr>
    </table>
    <p class="c7"><span class="c10"></span></p>
    </main>
  </body>
</html>

 If anyone have an idea of what Im doing wrong I will aprecciate your advice.
Thanks in advance!

0 3 356
Topic Labels
0 Likes
3 REPLIES 3

Posted on --/--/---- --:-- AM
SkrOYC
Gold 5
Gold 5
Reply posted on --/--/---- --:-- AM

Maybe these could help:

I'm looking for dificult template use cases! - Google Cloud Community
Part 1 - Almost pixel perfect pdf reports from aut... - Google Cloud Community
Part 2: Pixel perfect paginated reports - Google Cloud Community

Quick fix: Leave your Start: expressions alone. Just wrap on a <p>, nothing else. Start: expressions are not meant to be on the final report, it's not part of your content. Part 2 explains how I see Start: expressions:

SkrOYC_0-1664369754030.png

 

Posted on --/--/---- --:-- AM
muketaz
Bronze 5
Bronze 5
In response to SkrOYC
Reply posted on --/--/---- --:-- AM

Thanks for your answer, and this awesome post explaining the details! I was already using it as a guide and skipped that module.
I will see if it works.
Thanks again! 

Translator
 
 
 

 

Posted on --/--/---- --:-- AM
SkrOYC
Gold 5
Gold 5
In response to muketaz
Reply posted on --/--/---- --:-- AM

Por cierto, hablo español!

Si te parece más fácil, me consultas en tu idioma. El español es mi lengua principal

Top Labels in this Space