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.
My Visual Database → General → 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.
Calculated fields have SQL syntax (SQLite)
In your case:
(CASE WHEN sentdate IS null then 1 else 0 end)
Brilliant -- thanks!
My Visual Database → General → Calculated fields
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi