Line total
= unit_price * quantity
Result: Currency
Guide
A formula field fills itself from other fields of the same record: a line total, a margin, the days left before a deadline, a full name. Add one in the module editor, type = price * quantity and see the result before you save.
= and names other fields by their key, the lowercase name shown in the module editor: = unit_price * quantity.+ - * / % ^, comparisons = <> < <= > >=, and & to join text."Paid". A yes/no field can be used directly: IF(paid, 0, total).A locked formula is always calculated and nobody can type in it. An editable formula is calculated until someone types a value: the form then shows “Typed value” and the formula stops overwriting it. Reset to formula hands it back.
= unit_price * quantity
Result: Currency
= ROUND(unit_price * quantity * 1.19, 3)
Result: Currency (3 decimals for TND)
= total - deposit
Result: Currency
= first_name & " " & last_name
Result: Text
= DATEDIFF(due_date, TODAY())
Result: Number
= AND(NOT(paid), due_date < TODAY())
Result: Yes / No
= IF(price = 0, 0, ROUND((price - cost) / price * 100, 1))
Result: Number
= IFS(amount < 1000, "Small", amount < 10000, "Medium", TRUE, "Large")
Result: Text
Pick a template, name your workspace, and start working. Free, no credit card.