...
[empty] | To match empty values for particular field. Example: field1:[empty] - will match records where field1 is empty (does not have a value, but the form defines this field) | ||||||||||
[now] | Current time and date, useful with '<' and '>' for comparing with dates stored. Example: someDateField:<[now] - will match records where field 'someDateField' has value which is in the past compared to now (current time) | ||||||||||
[today] | Same as [now], but without time | ||||||||||
[tomorrow] | To compare against tomorrow's date. Also something like [today]+1 could be used instead | ||||||||||
[yesterday] | To compare against yesterday's date. Also something like [today]-1 could be used instead | ||||||||||
[dateyyyyMMdd] | To compare against given date in the format: yyyyMMdd, example: [date20150130] to give a date as Jan 30 2015 | ||||||||||
[datetimeyyyyMMdd HH:mm] | To compare against given date with time in the format: yyyyMMdd HH:mm, example: [date20151231 12:13] to give a date as Dec 31 2015 12:13 | ||||||||||
[date timetoday hh:mm] | You can use a shortcut to "today" with given construction | ||||||||||
'<' and '>' (and '<=' and '>=') | Can be used together with date and datetime fields, as well as to compare values for numeric fields stored | ||||||||||
! | To reverse the filter condition. Example: !field1:[empty] - will find records that have 'field1' field filled | ||||||||||
| |||||||||||
hasChanged(fieldName)
| See explanation in Virtual functions
| ||||||||||
_previousState.fieldname | See hasChanged function in Virtual functions
You can access ANY property of the ConfiForms record that was there before the update. But ONLY in the IFTTT conditions | ||||||||||
Supports for "records count" evaluation
|
Some examples:
- field1:[today]-5 - assuming field1 is of type date (or datetime) this filter will return records where field1 value is not older than 5 days from now
- field1:[today]+10 - assuming field1 is of type date (or datetime) this filter will return records where field1 value is not after 10 days from now
...