• Registered: 2021-02-15
  • Posts: 5

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'

  • Registered: 2021-02-09
  • Posts: 23

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, 196 downloads since 2021-02-16 

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,674

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, 226 downloads since 2021-02-16 

  • Registered: 2021-02-09
  • Posts: 23

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

second example

Post's attachments

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