Calculating a table inside a text field
If you want to send some data in the form of a table in, for example, an email notification, insert the following expression:
|
FORMAT("<table width=800 align =Left> <tr><th width=500><h2>{0}</h2></th> <th width=100><h2>Wirkung %</h2></th> <th width=100> <h2>Datum</h2></th></tr> <tr><td>{1}</td><td>{2}</td><td>{3}</td></tr></table>", LIST($title,$table.column1,$table.column2,$table.column3)) |
where
title — the system name of the field containing the title for the table;
table.column1 — before the dot insert the system name of the reference field you want to take the data from, after the dot insert the system name of the field to form a column with its data.
You can add as many column as you want, just always remember to keep the logic of the FORMAT function.
