wvantongeren Posted October 11, 2016 Report Share Posted October 11, 2016 Hy all, Can I do something like this, to store my score in the table? UPDATE [@field:Score] (this is the parameter) SET Score = (this is the fieldname) CASE WHEN [@calcfield:2] < 75 THEN 5 END Thanks Quote Link to comment Share on other sites More sharing options...
0 MayMusic Posted October 11, 2016 Report Share Posted October 11, 2016 In details page you can add cal field as: CASE WHEN [@calcfield:2] < 75 THEN 5 END and then for score field select hidden as form element and receive data source parameter in advanced tab, select to receive this cal field. Upon update this value will get to the table. In table you can add formula field an use this case statement as well Quote Link to comment Share on other sites More sharing options...
0 ParkLoey Posted May 23, 2022 Report Share Posted May 23, 2022 Hi! Just wanted to provide Caspio's function reference as well. It has a sample of a case statement: https://howto.caspio.com/function-reference/#:~:text=Return-,Case,-Evaluates a list Quote Link to comment Share on other sites More sharing options...
Question
wvantongeren
Hy all,
Can I do something like this, to store my score in the table?
UPDATE [@field:Score] (this is the parameter)
SET Score = (this is the fieldname)
CASE
WHEN [@calcfield:2] < 75 THEN 5
END
Thanks
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.