Using Virtual fields and calc fields

[jboder2]

I can't get this to work, any suggestions are greatly apprecaited!

Thanks!

 

[CoopperBackpack]

Hello @jboder2,

I can see redundant open parenthesis before [@cbParamVirtual1]. 

Also, please wrap text values in single quotes. 

You may test this:

CASE 
WHEN [@cbParamVirtual1] = 1 THEN 'Approved'
WHEN [@cbParamVirtual1] = 2 THEN 'Denied'
ELSE 'Pending'
END

 

Hope this helps.

[Kurumi]

Hi @jboder2 - in addition, you may check this online help: https://howto.caspio.com/function-reference/#:~:text=Case