DatabasesWork with data
Formulas
Calculated fields in Formclick Databases, with the functions you can use.
A Formula field computes its value from other fields in the same record. Refer to a field by its name in braces, like {Status}.
IF({Status} = "Won", "🎉", "")
CONCAT({First name}, " ", {Last name})
DATETIME_DIFF({Due date}, TODAY(), "days")Functions
| Kind | Functions |
|---|---|
| Logic | IF, SWITCH, AND, NOT, ISBLANK, BLANK |
| Text | CONCAT, LEFT, RIGHT, MID, LEN, FIND, CONTAINS, SUBSTITUTE, TRIM, UPPER, LOWER, REPT, TEXT, VALUE |
| Numbers | SUM, AVERAGE, MIN, MAX, COUNT, ROUND, ROUNDUP, ROUNDDOWN, FLOOR, CEILING, ABS, MOD, POWER, SQRT |
| Dates | TODAY, NOW, DATEADD, DATETIME_DIFF, DATESTR, YEAR, MONTH, DAY, WEEKDAY, HOUR, MINUTE |
Formulas recalculate automatically when the fields they use change. They never run code: they only work with the values in the record.
Still need help? Contact support or email support@formclick.io.