5. ✱ Search a record / Powersearch & filter

End user 7 min read

1 WHAT IT IS

Search, powersearch, and filters let you narrow a long list of records down to just the ones you need. Filters can use a fixed value or a dynamic date range — a date option that is always evaluated against today's date, so a filter like "Today" or "This month" keeps showing the correct period without ever needing to be re-entered.

2 WHO IT'S FOR

Audience: End user    Reading time: 7 min

Useful for anyone working with lists of records, dashboards, or widgets who wants to find or track information quickly.

3 PREREQUISITES

It helps to already know how to open and view a record. See Edit & consult records first.

4 HOW IT WORKS

Search

The search bar lets you quickly look up records by matching the text you type against key fields in a list. Matching records appear as you type.

[Screenshot: the search bar above a record list, with a few matching results showing as text is typed]

Powersearch

Powersearch is the advanced search option. It lets you search across additional fields and combine multiple search terms, giving you more precise results than the standard search bar.

[Screenshot: the powersearch panel with multiple search fields/terms filled in]

Filtering a list

1 Open the filter panel from the list or widget toolbar.
2 Choose the field you want to filter on.
3 Choose a condition and enter a value — or, for a date field, choose a dynamic date range instead of a fixed date.
4 Apply the filter. The list updates to show only matching records.
5 Add more filters if needed, or edit and remove a filter at any time.
[Screenshot: filter panel with a field, condition, and value selected, and an "Apply" button]

Dynamic date ranges

Instead of filtering a date field to a fixed date, you can choose a dynamic date range. A dynamic range is evaluated against today's date every time the list loads, so a filter you set once keeps working correctly — every day, week, month, quarter, or year — without ever being edited.

[Screenshot: the dynamic date range option inside the filter modal, showing the available choices]
Single-day options
Today
Yesterday
Tomorrow
DirectionCombine with a period
This Day, Week, Month, Quarter, Year
Last
Next
Custom

For example, combining "This" with "Month" gives you "This month" — a filter that always shows the current month. "Custom" lets you define your own range instead of using a preset direction and period.

Where you'll find dynamic date ranges

Dynamic date ranges are available anywhere a date field can be filtered, including:

Location
Standard list filters, across collections
Activity Logs widget
Security Logs widget
General Logs widget
Reporting widget

Frequently asked questions

What happens if I use a dynamic date range instead of a fixed date?

The filter is evaluated against the current date every time the list loads, so options like "Today" or "This month" always reflect the present period without needing to be updated manually.

Can I combine a dynamic date range with other filters?

Yes. You can add a dynamic date range filter alongside other field filters on the same list, and all of them apply together.

What's the difference between search and powersearch?

Search performs a quick lookup across key fields as you type. Powersearch lets you search across additional fields and combine multiple search terms for more precise results.

Which widgets support dynamic date range filters?

Dynamic date ranges are available in the Activity Logs, Security Logs, and General Logs widgets, as well as the Reporting widget, and in standard list filters.

5 RELATED ARTICLES

Edit & consult records

Opening and working with an existing record

Consult history & track changes of a record

See what changed on a record and when

Widget: Collection List

Show a filtered list of records on a dashboard

Widget: Collection Chart

Visualize filtered records on a dashboard

6 NEXT IN TRACK

New Bizzmine employee track — next article

Consult history & track changes of a record →

Can I search across multiple collections?

Suppose you have registered a complaint but you can't remember whether it was a customer complaint or a vendor complaint.…

Suppose you have registered a complaint but you can't remember whether it was a customer complaint or a vendor complaint. Can I search in both collections at the same time?
No, the system is deliberately built in such a way that it is possible to separate things from each other.