The Appointments tab allows you to search for appointments.
Full Text Search
By default, Apptoto will perform a “full text search” on appointments on your calendar.
For example, to find all appointments with “fred” in them… enter the following into the search box and hit .
To find all appointments with “fred” and “smith” in them:
To find all appointments with the phrase “fred smith” in them:
The fields that are searched by default are the following:
- event.title: Event’s title
- event.location: Event’s location
- event.content: Event’s content
- name : Participant’s Name
- email: Participant’s Email
- phone: Participant’s Phone
- normalized_phone: Participant’s normalized Phone
To find all appointments that do not contain the word haircut in them:
You can search a specific field by specifying the field first. For example, to search for appointments whose’s participant name has “fred” in it:
To find all appointments with the word “haircut” in the title:
If you want to find all appointments whose event’s title is exactly “Haircut with Fred”, do:
event.title="Haircut with Fred"
= in the above examples are called search “operators”. The following operators are available:
|text, date, number||For text fields, this operator performs a “full text search”. For Date fields, it searches the entire day specified. For other fields, it does an exact match|
|=||text, date, number, boolean||Does an exact match. You can use “*” as a wildcard for text fields|
|!=||text, date, number, boolean||Not Equal|
|>||date, number||Greater than.|
|>=||date, number||Greater than or equal|
|<||date, number||Less than|
|<||date, number||Less than or equal|
Use the special keyword “empty” to search for fields that are empty. For example you can search:
event.custom.cancellation_reason != empty
event.location = empty
Special Date Phrases
For date fields, you can use special phrases for “today”, “tomorrow”, and “yesterday”.
For example, if you want to find all the appointments after today:
start_time > today
If you want to find all the appointments on or after today:
start_time >= today
If you want to find all appointments on today:
start_time = today
Other dates can be specified in human readable format. e.g.
start_time > "January 20th, 2018" and start_time < "January 30th, 2018"
Would find all the appointments whose start time was between “January 20th, 2018” and “January 30th, 2018”. You could also use “2018-01-20” and “2018-01-30” for that as well.
If you want to find all the appointments on one specific day, you can use the “:” operator. For example, the following would find all the appointments on March 2nd, 2018.
By default, all terms are searched assuming an AND query. For example, “Fred Smith” looks for all appointments containing both “Fred” AND “Smith”.
To find all appointments with “fred” OR “smith”:
fred or smith
The “or” operator takes precedence. For example the following would find all appointments who have “fred” in them or all appointments with both “smith” and “bob in them:
fred or smith and bob
So that is equivalent to:
fred or (smith and bob)
If you want to change how the query is evaluated, you can move the parenthesis. For example, to find all appointments that have “bob” in them and either “fred” or “smith”, do:
(fred or smith) and bob
Of course, you can use field specific queries with boolean logic as well. For example
(event.title:haircut or event.title:coloring) and nancy
If your events contain custom fields, you can search for them easily using the “event.custom” prefix. For example:
event.custom.appointment_type = haircut
would find all the appointments whose custom field appointment_type is set to haircut.
Besides the default fields specified above and the “custom” fields… Apptoto also provides some interesting default fields that you can use to customize your searches. Here are some of those fields and example uses.
|participants||number||The number of actual participants the event has|
|attempts||number||The number of attempted automatic messages that have been sent|
|booking_sent||boolean||If the participant has been sent an invite|
|reminded||boolean||If the participant has been reminded|
|confirmed||boolean||If the participant has confirmed|
|cancelled||boolean||If the participant has cancelled|
|not_coming||boolean||If the participant has cancelled|
|reschedule_requested||boolean||If the participant has cancelled|
|check_in_state||text||The participant’s check in state|
|noshow||boolean||If the participant was a no show|