Pierre Christophorov 10/15/2026 6:59:00 AM I have a solution, which is not better, but which has been working for 5 years, where I send with Sendgrid every day mails with the relevant tables and data to each user.
The Sendgrid Message Text is a formula-HTML field, with a succession of tables which are active or not according to the privileges of the user.
For instance, the code for the tables one user has to validate goes like this:
------------------- & If([!#FHA.ABAP]=0,"", '<a href=\''&URLRoot()&'/view.aspx?id=xxxxxxxx\'><br><br><h2>Factures achats que je dois valider</h2></a>' & '<table id=\'YouTomTable\'>' & '<tr>' & '<th style="border-top-left-radius: 10px; border:0;"></th>' & '<th>Nous</th>' & '<th>Fournisseur</th>' & '<th>Montant TTC</th>' & '<th>Date Facture</th>' & '<th>Limite Paiement</th>' & '<th style="border-top-right-radius: 10px; border:0;">Log</th>' & '</tr>' & [!FHA.ABAP]) & '</table>' -------------------
Where [!FHA.ABAP] is a summary field is a concatenation across all the records of a series of fields, going like this: "<tr>" & "<td><a href='" & URLRoot() & "/preview.aspx?t=" & TableId() & "&id=" & RecordId()&"'><img src='"&URLRoot()&"/res.aspx/View48.png' alt='View' ></a></td>" & "<td>" & Replace(Replace(Replace(Nz([Société Destinataire],""),"\n","<BR>"),"'",""),'"','') &"</td>" & "<td>" & Replace(Replace(Replace(Nz([Fournisseur],""),"\n","<BR>"),"'",""),'"','') &"</td>" & "<td>" & Replace(Replace(Replace(Nz([N° Facture],""),"\n","<BR>"),"'",""),'"','') &"</td>" & "<td>" & Nz(Format([Montant HT],"#,#.00") &" "& [(M)],"") & "</td>" & "<td>" & Nz(Format([Montant TTC],"#,#.00") &" "& [(M)],"") & "</td>" & "<td>" & Nz(Format([Date de Facture],"d","fr-FR"),"") &"</td>" & "<td>" & Nz(Format([Date Limite de Paiement],"d","fr-FR"),"") &"</td>" & "</tr>"
If this interests anybody I will gladly provide all info here
Pierre
|