Skip to main content
References let a formula read a value supplied by the current form or workflow. Reference names are case-insensitive, so [Status] and [status] point to the same value.

​
Current fields

Put a field name in square brackets:
Use the field’s configured name exactly as clients see it. If a field is unavailable in the current screen or record, its reference evaluates to null.

​
Namespaced references

​
Types stay explicit

Dsync keeps text, numbers, booleans, dates, times, timestamps, durations, locations, users, files, and lists as distinct value types. It does not silently turn text such as "2" into the number 2 during arithmetic. Use a conversion function when the source type does not match the operation:
Most comparisons require both values to have the same type. If either side is null, comparison operators return false; use IsNull or Nz when missing data needs explicit handling.

​
Rendered values

When a formula is inserted into text, its result is printed in a stable form. Use Format for client-facing number, date, time, or timestamp presentation instead of relying on the default printed form.
Last modified on September 7, 2026