• Registered: 2014-11-18
  • Posts: 2

Topic: Calculated fields

Is there any documentation for the syntax behind calculated fields?

I want to say something like "if sentdate is null, set this field to false else set field to true" but I can't work out how to construct the calculation.

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Calculated fields

Calculated fields have SQL syntax (SQLite)

In your case:

(CASE WHEN sentdate IS null then 1 else 0 end)
Dmitry.
  • Registered: 2014-11-18
  • Posts: 2

Re: Calculated fields

Brilliant -- thanks!