Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.

HTML expression inside an action

Hello,
Could someone help me with the HTML expression so that the image is printed at the top of the page?

Screenshot 2025-01-27 12.29.10 PM.png

โ€ƒ

Screenshot 2025-01-27 14.46.58.png

"https://example.com?html=" & ENCODEURL(SUBSTITUTE("<!DOCTYPE html>
<html lang='en'>
<head>
<meta charset='UTF-8'>
<meta name='viewport' content='width=device-width, initial-scale=1.0'>
<title><PII Removed by Staff></title>
<style>
body {
text-align: left;
}

table {
width: 100%;
margin: 10px auto;
border-collapse: collapse;
}
th, td {
border: 1px solid #000;
padding: 5px;
text-align: left;
}
.signature {
margin-top: 10px;
font-size: 16px;
}
img {
max-width: 100%;
height: auto;
}
.company-info {
margin-bottom: 3px;
font-size: 16px;
text-align: left;
}

.footer {
font-size: 12px;
text-align: left;
}
</style>
</head>
<body>
<div class='image-container'>
<img src="&Config[Logo]&" alt='Logo'>
</div>

<style>
.image-container img {
float: left; /* Alinha a imagem ao lado esquerdo */
margin-right: 10px; /* Espaรงo opcional ao lado direito */
max-width: 7%; /* Ajuste da largura */
height: auto; /* Mantรฉm a proporรงรฃo */ }
</style>

<h1 style='color: blue;'>Pedido No.: " & [IDpedido] & " &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Data: " & TEXT([Data Pedido]) & "</h1>

<div class='company-info'>
<p>Cliente :</strong>"&[Idcliente].[fantasia]&"</p>
<p>Endereรงo:</strong>"&[Idcliente].[endereรงo]&"</p>
<p>Contato :</strong>"&[Contato]&" Telefone:"&[Idcliente].[celular]&"</p>
</div>

<table>
<thead>
<tr>
<th>Referencia</th>
<th>Cor(es)</td>
<th>Tamanho(s)</th>
<th>Quantidades</th>
<th>No.Peรงas</th>
<th>Preรงo</th>
<th>Total</th>
</tr>
</thead>
<tbody>
<tr>
<td> "&[Related Items][produto]&"</td>
<td> "&[Related Items][CorDesc] & "</td>
<td> "&[Related Items][TamDesc]&"</td>
<td> "&[Related Items][DescQtde]&"</td>
<td> "&[Related Items][TotalPecas]&"</td>
<td> "&[Related Items][Preรงo]&"</td>
<td> "&[Related Items][Total]&"</td>
</tr>
</tbody>
</table>

<p><strong>TOTAL DE PEร‡AS: "&sum([Related Items][TotalPecas])&"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TOTAL GERAL: R$ "&text(sum([Related Items][Total]))&" </strong></p>

<p><strong>e2webtecnologia.com.br </strong> </p>

</body>
</html>", "%", "percent"))

 

0 2 151
2 REPLIES 2

You could use hyperlink() as a wrapper to your <img src>

Hi Derick Paula,
Thank you for your contribution, but unfortunately I'm not writing the expression with hyperlink() correctly.

Top Labels in this Space