Report Records and Fields
Understand field types
The picker may offer these kinds of fields:
Text — names, labels, and other words. Use text conditions to find or exclude values.
Enum — a defined choice such as a status or member type. Choose from the available
options instead of guessing the stored wording.
Date — a date or time used for filters and time-based grouping. Check which date answers
your question: a member’s Signed Up On date is not necessarily the date a membership
started.
Number or Currency — quantities and money. Sum, average, minimum, and maximum are
available only when the chosen field supports that calculation.
Boolean — a true/false choice. Use the field’s true or false condition.
Related record — information reached through a connection, such as a member’s
membership or a booking’s class. The picker lets you follow available connections; some
connections can contain several records and may be offered as a list or count.
The exact fields and conditions vary by record type. If you cannot find a field, check that
you chose the right record type and ask an administrator to verify your role’s access.

Search terms: