Dynamic text

Merge data + text

To embed data into your text that updates automatically, use dynamic text. Dynamic text behaves like normal text - it can be formatted, resized, placed in a header or list etc. However, the text content depends on the cell it is linked to. If the cell is updated, then so is the linked text.

Insert dynamic text

When focussed in some text (e.g. in a text box, a sticky note, or shape), you'll see a gauge icon. From there you'll be asked to enter the cell, column, and row you'd like to pull data from:

When a cell updates, any dynamic text linked to that cell will also update. This means if your canvas is connected to a control cell, whenever a user updates a value, all connected cells and dynamic text will update.

To edit linked text after it has been created, just hover over it again and click on the floating tooltip near it.

Make sure the referenced cell is ordered using an ORDER clause to ensure the correct row order.