Build a new column/field in a table with a formula. Is there a way to use an IF logic?

[Maria]

Hello,

I am quite new to Caspio and  I am not sure if what I want to accomplish is possible.

I have a table in which I want to add a new field/column. That new column is going to combine/concatenate few of the other columns in the same table, but I need to use an if logic to complete what I want.
I did not see an IF option as a text formula. This is what I have written, but the formula is not correct:

[CoopperBackpack]

Hello @Maria,

Since SQL syntax is supported in the Formula field, please use the SQL CASE statement instead.

The syntax should be like:

CASE
WHEN Len([@field:Text]) < 2 THEN '0' + [@field:user_email]
WHEN Len([@field:Text]) > 2 THEN '1' + [@field:user_email]
ELSE [@field:user_email]
END

The ESLE part is optional.

The important note: each THEN/ELSE should return the value of the same data type.

You may refer to these articles:

https://howto.caspio.com/function-reference/

https://howto.caspio.com/tables-and-views/data-types/formula-fields/

Hope this helps.

[NiceDuck]

I'm not sure what you mean by creating a new field. You can use the formula field on the table design to generate values base on what you currently have on your table but we cannot use that to create a new field/column.