2021.2

Mixing text and data in one cell
By default, each Dynamic Table cell that is based on a data field shows a placeholder. For
example: @CompanyName@ refers to a data field named CompanyName. However, unlike
other placeholders, these placeholders are not used as selector.
Instead, if a cell has the data-field or data-sum attribute, the software will replace the entire
contents of that cell with a value: the current value of the data field, or a running total,
respectively. (For information about data- attributes see: "HTML: table element and data-
attributes" on page838).
Any text that was added in Design mode will disappear.
In order to mix data and text in a cell, you should remove the data-field or data-sum attribute,
respectively, from the cell itself and then put that attribute on an element inside the cell.
Here's how to do that.
1. In the Workspace, open the Design tab.
2. Select the cell (see "Selecting an element" on page638).
3. On the "Attributes pane" on page1059, set Field or Sum to None.
4. Type text in the cell, before and/or after the placeholder.
5. Select the placeholder, right-click it and select Wrap in Span...
6. Select the new Span element.
7. On the "Attributes pane" on page1059, set Field or Sum to the desired data field.
8. Reapply the format if needed (see "Formatting values in a Dynamic Table" below).
Changing content based on a value
Changing the contents of a cell or row in a Dynamic Table, based on the value of a data field,
requires a script. See "Using scripts in Dynamic Tables" on page909.
Formatting values in a Dynamic Table
Values in Dynamic Table cells can be formatted in different ways. A date value, for example,
could be displayed as "Apr 2, 2016" (short date) or "4/2/16 12:00 AM"(medium date/time).
Which formats are possible depends on the data type of the field that the cell is associated to
(see "Data types" on page286)
For an explanation of the possible formats see "Formatting variable data" on page812.
Page 834