DayBackForFileMaker

Filter Options

DayBackForFileMaker.FilterOptions History

Hide minor edits - Show changes to output

May 19, 2018, at 05:56 PM by 192.88.134.15 -
Added lines 77-80:

-> Comparison operators let you see through the noise of your schedule to focus on what matters most:

%center% %newwin width=500% [[https://www.seedcode.com/rootimages/stikipad/daybackonline/ComparisonOperators2.png | https://www.seedcode.com/rootimages/stikipad/daybackonline/ComparisonOperators2.png]]
May 19, 2018, at 04:03 PM by 192.88.134.15 -
Changed line 74 from:
--> '''Status= -cancelled''' ...would show all items except those that are cancelled
to:
--> '''Status: -cancelled''' ...would show all items except those that are cancelled
May 15, 2018, at 06:58 PM by 192.88.134.15 -
Changed lines 19-24 from:
--> '''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 )
to:
--> '''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 )
Changed lines 31-38 from:
--> '''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.
to:
--> '''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.
Changed lines 47-52 from:
--> '''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.
to:
--> '''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.
Changed lines 57-60 from:
--> '''(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
to:
--> '''(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
Changed lines 74-76 from:
--> '''Status= -cancelled''' - would show all items except those that are cancelled

--> '''- Workload Shared''' - show everything except the calendar named "Workload Shared". To be more explicit you could also use '''source: -Workload Shared'''
to:
--> '''Status= -cancelled''' ...would show all items except those that are cancelled

--> '''- Workload Shared''' ...shows everything except the calendar named "Workload Shared". To be more explicit you could also use '''source: -Workload Shared'''
May 15, 2018, at 06:54 PM by 192.88.134.15 -
Added lines 52-76:

!!! Parentheses

-> 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

!!! Comparison Operators

-> DayBack's filters also understand comparison operators like these:

--> >
--> <
--> &#8805;
--> &#8804;
--> =
--> -

-> The last one is perhaps the most useful as it omits the matching value.

--> '''Status= -cancelled''' - would show all items except those that are cancelled

--> '''- Workload Shared''' - show everything except the calendar named "Workload Shared". To be more explicit you could also use '''source: -Workload Shared'''
April 09, 2018, at 07:29 PM by 192.88.134.15 -
Added lines 42-51:

!!! Wildcards

-> 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.
April 06, 2018, at 11:18 PM by 192.88.134.15 -
Added lines 40-41:

-> To filter on a contact or project name, use '''contactName: something''' or '''projectName: something'''
April 04, 2018, at 05:55 PM by 192.88.134.15 -
Changed line 43 from:
If you'd like to add filter criteria like this ''behind the scenes'', so some users' are already constrained in what the can see, you can [[https://www.seedcode.com/pmwiki/index.php?n=DayBackForFileMaker.Filters#prefilter | pre-filter the calendar]] by editing one of DayBack's FileMaker scripts.
to:
If you'd like to add filter criteria like this ''behind the scenes'', so some users are already constrained in what the can see, you can [[https://www.seedcode.com/pmwiki/index.php?n=DayBackForFileMaker.Filters#prefilter | pre-filter the calendar]] by editing one of DayBack's FileMaker scripts.
April 04, 2018, at 04:24 PM by 192.88.134.15 -
Changed lines 39-43 from:
-> For additional fields, use the actual field name from FileMaker in your filter, not the label you've assigned the field.
to:
-> For additional fields, use the actual field name from FileMaker in your filter, not the label you've assigned the field.

!! Going Further

If you'd like to add filter criteria like this ''behind the scenes'', so some users' are already constrained in what the can see, you can [[https://www.seedcode.com/pmwiki/index.php?n=DayBackForFileMaker.Filters#prefilter | pre-filter the calendar]] by editing one of DayBack's FileMaker scripts
.
April 04, 2018, at 01:51 PM by 192.88.134.15 -
Changed line 3 from:
%25center%25''Introduced in DayBack [[version history | version 10.27]]''
to:
''Introduced in DayBack [[version history | version 10.27]]''
April 04, 2018, at 01:51 PM by 192.88.134.15 -
Added lines 2-3:

%25center%25''Introduced in DayBack [[version history | version 10.27]]''
April 04, 2018, at 01:53 AM by 192.88.134.15 -
Changed lines 17-24 from:
--> 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
to:
--> '''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
Changed lines 29-33 from:
--> 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
to:
--> '''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.
April 04, 2018, at 01:51 AM by 192.88.134.15 -
Changed lines 15-23 from:
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
to:
-> 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 Names

-> You can also filter against specific field names in the form filename: value. Source names 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
April 04, 2018, at 01:44 AM by 192.88.134.15 -
Changed lines 1-23 from:
Coming Soon!
to:
%center% %width=440% https://www.seedcode.com/rootimages/stikipad/daybackonline/textfilter.png

!! How can I use the text filter?

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, so include a whole calendar by including its name;

-> - In any [[additional 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
March 06, 2018, at 07:14 PM by 192.88.134.15 -
March 06, 2018, at 07:14 PM by 192.88.134.15 -
Added line 1:
Coming Soon!
(855) SEEDCODE
support@seedcode.com
Follow us: