Different field types support different operators. A full list of supported operators is available below.
Address
- [address]== — Street Address is equal to.
- [address]!= — Street Address is not equal to.
- [address]% — Street Address contains substring.
- [address]!% — Street Address does not contain substring.
- [address]? — Street Address is not empty.
- [address]!? — Street address is empty.
- [city]== — City is equal to.
- [city]!= — City is not equal to.
- [city]% — City contains substring.
- [city]!% — City does not contain substring.
- [city]? — City is not empty.
- [city]!? — City is empty.
- [postcode]== — Postal Code is equal to.
- [postcode]!= — Postal Code is not equal to.
- [postcode]% — Postal Code contains substring.
- [postcode]!% — Postal Code does not contain substring.
- [postcode]? — Postal Code is not empty.
- [postcode]!? — Postal Code is empty.
- [region]== — Region is equal to.
- [region]!= — Region is not equal to.
- [region]% — Region contains substring.
- [region]!% — Region does not contain substring.
- [region]? — Region is not empty.
- [region]!? — Region is empty.
- [country]== — Country is equal to.
- [country]!= — Country is not equal to.
- [country]% — Country contains substring.
- [country]!% — Country does not contain substring.
- [country]? — Country is not empty.
- [country]!? — Country is empty.
Attachment
- ? — Attachment is not empty.
- !? — Attachment is empty.
Barcode
- == — Barcode is equal to.
- != — Barcode is not equal to.
- % — Barcode contains substring.
- !% — Barcode does not contain substring.
- ? — Barcode is not empty.
- !? — Barcode is empty.
Boolean
- == — Boolean is equal to (true or false).
- != — Boolean is not equal to (true or false).
- ? — Boolean is not empty.
- !? — Boolean is empty.
Checkbox
- == — Checkbox is equal to (true or false).
- != — Checkbox is not equal to (true or false).
- ? — Checkbox is checked.
- !? — Checkbox is unchecked.
Connection
- == — Connection matches. Checks if any of the connected responses match Query JSON passed to the value.
- != — Connection does not match. query. Checks that none of the connected responses match Query JSON passed to the value.
- % — Connection values match. Checks if any of the connected response permalinks or primary fields match the value provided.
- !% — Connection values do not match. Checks if all of the connected response permalinks and primary fields do not match the value provided.
- ? — Connection is not empty.
- !? — Connection is empty.
Date & Time
- == — Date & Time is equal to.
- != — Date & Time is not equal to.
- > — Date & Time is greater than.
- >= — Date & Time is greater than or equal to.
- < — Date & Time is less than.
- <= — Date & Time is less than or equal to.
- ? — Date & Time is not empty.
- !? — Date & Time is empty.
Dropdown (Multiple Choice)
- == — Dropdown option is equal to.
- != — Dropdown option is not equal to.
- ? — Dropdown is not empty.
- !? — Dropdown is empty.
Formula
- == — Formula is equal to.
- != — Formula is not equal to.
- % — Formula contains substring.
- !% — Formula does not contain substring.
- ? — Formula is not empty.
- !? — Formula is empty.
Number
- == — Number is equal to.
- != — Number is not equal to.
- > — Number is greater than.
- >= — Number is greater than or equal to.
- < — Number is less than.
- <= — Number is less than or equal to.
- ? — Number is not empty.
- !? — Number is empty.
Phone Number
- == — Phone Number is equal to.
- != — Phone Number is not equal to.
- % — Phone Number contains substring.
- !% — Phone Number does not contain substring.
- ? — Phone Number is not empty.
- !? — Phone Number is empty.
Rating
- == — Rating is equal to.
- != — Rating is not equal to.
- > — Rating is greater than.
- >= — Rating is greater than or equal to.
- < — Rating is less than.
- <= — Rating is less than or equal to.
- ? — Rating is not empty.
- !? — Rating is empty.
Signature
- == — Signature signed by.
- != — Signature not signed by.
- ? — Signature is not empty.
- !? — Signature is empty.
Text Area
- == — Text Area is equal to.
- != — Text Area is not equal to.
- % — Text Area contains substring.
- !% — Text Area does not contain substring.
- ? — Text Area is not empty.
- !? — Text Area is empty.
Text
- == — Text is equal to.
- != — Text is not equal to.
- % — Text contains substring.
- !% — Text does not contain substring.
- ? — Text is not empty.
- !? — Text is empty.
User
- == — User includes username.
- != — User does not include username.
- ? — User is not empty.
- !? — User is empty.