What is the correct syntrax to use if I want to set a text value if a field is not empty and if a field contains a specific text?
Example: Case WHEN {customfield} is NOT NULL THEN 'Text1' WHEN {name} contains 'text' THEN 'Text 2' ELSE 'Text 3' END
I can't get this to work. I'm getting an invalid expression error.
Any help is appreciated.