Calculated Columns
There are various calculations and commands which can be executed through these custom fields.
The 'Calculated Columns' editor can be used to create a custom function for a particular field.
📋 Steps to Create a Calculated Columns
Click on
columns
Click on the 'Add Custom Column' icon.

Click on 'Calculated Columns'
Enter the field name in the respective space provided.
Click on the blank space below to write a custom function. The function needs to be written in PostgreSQL.
These are the commands available under the 'String' format along with its Syntax.
Character Length
char_length([field_name])
All characters in Lower Case
lower(string)
All letters in Upper Case
upper(string)
String Concatenation 2
'String: ' || integer
Last updated
Was this helpful?