RobfromZA Posted January 4, 2019 Report Share Posted January 4, 2019 (edited) **Problem solved** Hi all, Caspio Newbie - looking to understand how to create a typical "If ... then .. " statement for a calculated field in a table. On a different thread I read about creating a case and tried the following: CASE WHEN [@field:Loss_Amount] >= 1 THEN ‘Serious’ ELSE ‘Check’ END but received the error "Invalid formula: Incorrect syntax near '‘'. Any suggestions on where I am going wrong? Edited January 4, 2019 by RobfromZA Problem solved Quote Link to comment Share on other sites More sharing options...
0 MayMusic Posted January 4, 2019 Report Share Posted January 4, 2019 Make sure to select the parameter value from picker an also do not use smart quotes. CASE WHEN [@field:Loss_Amount] >= 1 THEN 'Serious' ELSE 'Check' END Quote Link to comment Share on other sites More sharing options...
0 TsiBiRu Posted January 7, 2019 Report Share Posted January 7, 2019 Hi @RobfromZA, For more details about Caspio's Case function, and as well as all other functions. Kindly check the link below, as it contains useful information about this functions and how to use this. https://howto.caspio.com/function-reference/ I hope this helps. Regards, TsiBiRu Quote Link to comment Share on other sites More sharing options...
Question
RobfromZA
**Problem solved**
Hi all,
Caspio Newbie - looking to understand how to create a typical "If ... then .. " statement for a calculated field in a table.
On a different thread I read about creating a case and tried the following:
CASE
WHEN [@field:Loss_Amount] >= 1 THEN ‘Serious’
ELSE ‘Check’
END
but received the error
"Invalid formula: Incorrect syntax near '‘'.
Any suggestions on where I am going wrong?
Edited by RobfromZAProblem solved
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.