Tables & field types — Formula fields: compute a value from an expression

A Formula field computes its value from an expression instead of storing one. Type it in curly braces to reference other fields, combine them with operators and functions, and RowFold recalculates the result every time the record — or a field it depends on — changes. • Reference a field on this table by name: {Amount} * {Probability} / 100. • Do date maths with - and + — {Check Out} - {Check In} is the number of days between two dates, and {Start} + 7 is the date a week later. When the field carries a time the answer keeps the part-day, so wrap it: ROUND({Check Out} - {Check In}, 0) for nights, DATEDIF({Check In}, {Check Out}, "hours") for hours (it also takes "minutes", and is exact where multiplying a day count by 24 leaves a rounding tail).