Skip to Content

Templates

For: implementers.

Widget text fields accept templates in double braces. A template is replaced by a value from the query or from a filter. The result is always shown as text, never as HTML.

Variables

TemplateReads
{{pendiente}}The pendiente column of the first row
{{row.pendiente}}The same
{{filter.estado}}The current value of the estado filter. Empty when it has no value
{{data_provider.key}}A key/value pair written in the widget’s Data provider section, in widgets that have it

Single-value widgets (Stat, Stacked Stat, Text Card) read the first row. In a table, {{row.column}} reads each cell’s row.

Functions

Templates use Handlebars. These functions are available in every widget. When the value is not a valid number or date, they return -.

Numbers

TemplateValueResult
{{formatNumber total}}12500.512.500,5
{{formatNumber total decimals=1}}25.67825,7
{{formatNumber total prefix="$"}}1500$1.500
{{formatNumber total decimals=2 locale="en-US"}}25.67825.68
{{toFixed pct 1}}25.67825.7
{{round pct}}25.626
{{multiply ratio 100}}0.8585
{{divide total 1000}}25002.5
{{extractNumber reading}}"25.5 kg"25.5

formatNumber uses es-CL by default: dot for thousands, comma for decimals. Pass locale="en-US" for the English format. toFixed, round, multiply and divide return the number without a thousands separator.

Dates

TemplateResult
{{formatDate creada_en}}30-10-2026, 14:05
{{formatDate creada_en format="date"}}30-10-2026
{{formatDate creada_en format="time"}}14:05
{{formatDate creada_en format="relative"}}5m, 3h, 2d
{{formatDate creada_en timezone="America/Lima"}}The date in another time zone
{{datePart creada_en "weekday"}}viernes
{{timeAgo creada_en}}3h ago (always in English)

datePart accepts year, month, day, hour, minute and weekday. The default time zone is America/Santiago and the default locale is es-CL.

Pitfall: formatDate needs an ISO date with a time zone, such as 2026-10-30T17:05:00Z. A BigQuery TIMESTAMP column arrives as seconds in scientific notation (1.7933364E9) and formatDate shows -. In the query, use FORMAT_TIMESTAMP('%Y-%m-%dT%H:%M:%SZ', creada_en). A date without a zone (2026-10-30 14:05) is read in the viewer’s browser time zone.

Pitfall: double braces escape HTML. A value with &, < or " shows as &amp;, &lt; or &quot;. To show it as is, use triple braces: {{{responsable}}}.

Examples

FieldTemplateResult
Stacked Stat titleRequests by state ({{total}})Requests by state (49)
Status Card value{{formatNumber amount prefix="$"}}$1.250.000
Title that follows a filterDetail: {{filter.estado}}Detail: en_curso
Table cell{{row.responsable}} · {{formatDate row.creada_en format="date"}}South team · 30-10-2026
Last updated on