Formatting and Conditions

Format money and dates, add links and images, show text only when it applies, and lay out lists in tables.

Word document templates and everything else use different options, so this page covers each separately. See Word templates and everything else.


Emails, texts, and other templates

These options work in emails, text messages, bid sheets, PDF catalog templates, certificates, display pages, receipt headers and footers, and basket descriptions.

Filters

Add a filter after a reference, separated by a |, to change how it's shown.

FilterWhat it doesExample output
currencyFormats a number as money.$300.00
timestampShows a date and time in your organization's time zone.
pad3Adds zeros to the start of a number to make it three digits long.007

For example:

Starting bid: {{ StartingBid | currency }}
Item #{{ Number | pad3 }}

Formatted money without a filter:

Every money field also has a formatted version with AsString added to its name. {{ StartingBidAsString }} shows the same thing as {{ StartingBid | currency }}.

What it showsCode
Link to the item on your event website{{ Item }} followed by the link filter
Link to your event website{{ Event }} followed by the link filter
The item's main image, in an email{{ Item }} followed by the image filter
{{ Item | link }}
{{ Event | link }}
{{ Item | image }}

Images don't display in text messages.

Show text only when a field has a value

Wrap text in {% ifstr FieldName %} and {% endifstr %} to show it only when the field isn't blank. This keeps your messages tidy when some records are missing information.

For example, this only adds the company line for participants who have a company:

{{ Name }}{% ifstr Company %}, {{ Company }}{% endifstr %}

Loop through a list

{% for bid in WinningBids %}{{ bid.Bidder.Name }}: {{ bid.Amount | currency }}
{% endfor %}

See Lists everywhere else for the lists you can use.


Word document templates

These options only work in Word document templates. See Word Templates.

Conditions

Show different text depending on a value. The condition is met when the value isn't blank, zero, or N.

{% if HasWinningBid %}Won by {{ WinningBidder.Name }}{% else %}No winner yet{% end %}

The {% else %} part is optional.

Loops

ToWrite
Repeat text for each entry in a list{% foreach ListName %}…{% end %}
Sort the list first{% foreach ListName orderby FieldName %}…{% end %}
Repeat a table row for each entry{% row ListName %} at the start of the row's first cell

To build a table with one row per entry:

  1. Insert a table with a header row and one more row.
  2. In the second row, put {% row ListName %} at the start of the first cell.
  3. Add the fields for each entry in that row's cells, such as {{ Amount }}.

Auctria repeats the second row once for each entry in the list. No {% end %} is needed.

Totals and counts

What it showsCodeExample
Number of entries in a list{{ count ListName }}{{ count ItemsWon }}
Total of a field across a list{{ sum ListName FieldName }}{{ sum ItemsWon Amount }}

Today's date

These show the current date or time in your organization's time zone, at the moment the document is generated.

What it showsCode
Today's date{{ currentdate }}
The current time{{ currenttime }}
The current date and time{{ now }}

Display options

Add # and an option after a reference to change how it's shown.

OptionWhat it doesExample
NoCents=trueShows money without cents.{{ Balance # NoCents=true }} shows $250
NoZero=trueShows nothing when the value is zero.{{ Balance # NoZero=true }}
TimestampFormat=Shows a date in the format you choose.{{ CreatedAt # TimestampFormat=MMM d, yyyy h:mm tt }} shows Oct 23, 2026 8:45 PM

Without TimestampFormat, dates show as 23-Oct 8:45 PM.

Date format codes
CodeShowsExample
dDay of the month3
ddDay of the month, two digits03
dddShort day nameFri
ddddFull day nameFriday
MMonth number10
MMMonth number, two digits10
MMMShort month nameOct
MMMMFull month nameOctober
yyyyYear2026
hHour, 12-hour clock8
HHHour, 24-hour clock20
mmMinutes45
ttAM or PMPM

Last reviewed: November 2026
ReferencesFormatting
/advanced/references/formatting_and_conditions/
advanced
references
formatting_and_conditions
Formatting and Conditions
Format money and dates, add links and images, show text only when it applies, and lay out lists in tables.
© Auctria 2013-2026