Topic: (case when xyz = 1 then 'A' else 'B' end) ???

(case when xyz = 1 then 'A' else 'B' end)

=> how can i change the condition "1" to the condition "(text-)field is empty", then 'A'... if "not empty" then 'B'

Re: (case when xyz = 1 then 'A' else 'B' end) ???

here is a very easy way

Post's attachments

Attachment icon condition.zip 332.98 kb, 200 downloads since 2021-02-16 

Re: (case when xyz = 1 then 'A' else 'B' end) ???

Hi Both,
Another option is to use a calculated field (please see the attached for the syntax).
Derek.

Post's attachments

Attachment icon empty not empty.zip 338.9 kb, 230 downloads since 2021-02-16 

Re: (case when xyz = 1 then 'A' else 'B' end) ???

second example

Post's attachments

Attachment icon condition.zip 332.95 kb, 206 downloads since 2021-02-16