Case in calculated field

[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

[MayMusic]

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

 

[ParkLoey]

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