I am trying to figure out the syntax for the Inbox query that filters on whether a date field is populated or not. The form is for insect trapping and date "removalDate" is populated only when the trap is taken down removalDate = calculation (if(${confirmTakeDown} = 'y', once(today()), '')), at this point I would like to remove the record from the Inbox. It seems like the query clause should be removalDate = '', but this doesn't seem to work. Any thought on this would be greatly appreciated.
Solved! Go to Solution.
Hi Brent - try
removalDate is null