Text Filter Options
DayBack will filter its view against anything you type into the text filter and will look for your string in the following places:
- In any field in an event (anything you can "see" in the calendar or when you click on an event);
- In the event's calendar name (source), so include a whole calendar by including its name;
- In any custom fields.
Operators: AND & OR
You can also use AND and OR operators in your filters. When filters are chained together, the calendar will infer parentheses like this:
Tim and Beth and Urgent ...will return only events that have all three attributes
Tim or Beth or Urgent ...will return events that have any of these three attributes
Tim or Beth and Urgent ...will return Tim or ( Beth and Urgent )
Tim and Beth or Urgent ...will return (Tim and Beth) or Urgent which means events containing Tim and Beth, alongside any events containing Urgent
Field and Source/Calendar Names
You can also filter against specific field names in the form filename: value. Source names (the names of your calendars) work the same way. Here are some examples:
status: Hot ...would find items where the status is Hot and items where the status is Hotter
source: shared ...would only pick up the source (calendar) named "Workload Shared", not an event in another source with "share" in the description
Title: error OR Holidays In the United States ...would return items with error in the title alongside all items in the calendar named: Holidays In the United States
Status: done OR Resource: Ann ...would return its where the status is done or the resource is set to Ann.
For additional fields, use the actual field name from FileMaker in your filter, not the label you've assigned the field.
Include * (an asterisk) in your filters to represent zero or more characters.
location:* ...would return only items that have a location entered.
Workload Shared: * ...would return everything in the "Workload Shared" calendar.
Meetup OR Workload Shared: * ...would return any events with "Meetup" in their text along with all events in the Workload Shared calendar.
If you're filtering on a checkbox field, use the field name and then True.
done: -True...would return all the To-Dos in Basecamp that are not marked done.
Make logical groupings with parentheses, for example:
(vacation OR off) and James' ...would return any instances where James is on vacation of "off" for the day.
(Proposed Value: > 50000 OR Status: = urgent) and Customer: Acme ...would show the Acme events with more than $50k and those marked urgent
DayBack's filters also understand comparison operators like these:
Don't forget to include the colon, like this;
Hrs Remaining: > 6
The last one is perhaps the most useful as it omits the matching value.
Status: - canceled ...would show all items except those that are canceled.
Status: -* ...would show all items where the status is blank, i.e. "not (-) any value (*)"
- Workload Shared ...shows everything except the calendar named "Workload Shared". To be more explicit you could also use ''source: -Workload Shared.''
Rooms: Room 1 and Rooms: -Room 2 and Rooms: -Room 3 ...Is for a multi-value picklist to return items where the Room field is just the single Room 1 value and items that have both Room 1 and Room 2 values selected are not returned.
Comparison operators let you really focus on what matters most: