Page blocks

Record list samples

Filtering

Record list pre-filtering supports value interpolation that is relative to the content; such as a record.

Available variables:

record: current record (when available)
recordID: current record’s recordID (when available)
ownerID: current record’s owner (when available)
userID: current user’s userID

Show only records created this year: YEAR(created_at) = YEAR().
Show only records linked to the viewed record: related_contact = ${recordID}.
Show only active contacts: is_active = '1'.
Show lost opportunities: status = 'closed/lost'.

Sorting

Sort by latest: created_at DESC.
Sort by latest and opportunity stage: created_at DESC, stage DESC.

Metric page block samples

Divide the result by 1000 to show cost in thousands: v / 1000
Round result to remove decimal places: Math.round(v)
Round result to remove decimal places (round up): Math.ceil(v)
Round result to remove decimal places (round down): Math.floor(v)
Round result to two decimal places: Math.round(v * 100) / 100

Expressions use standard JavaScript syntax, so you can use any standard JavaScript expression.

You can specify rounding with the value formatting.