Reply to comment
Yes. QuickBase supports formula fields. The value of a formula field in a particular record is calculated from the value of other fields in the record. There are many types of formulas. A numeric formula results in a numeric value and uses numeric operations and functions. You can also create text formulas, check box formulas, date formulas, and URL formulas. Example 1: This numeric formula creates a "diameter" field that calculates its value as: [radius]*2 Note: The square brackets are used to specify that the value of the field named "radius" should be used. Example 2: This numeric formula calculates the number of weeks remaining until something is due: ToWeeks([Date Due] - Today()) Example 3: This text formula creates a "full name" field: [First Name] & " " & [Last Name] Example 4: This text formula displays a message about overdue status: If(ToWeeks([Date Due] - Today()) < 0, "Overdue", "Okay") For more, please see our Using Formulas in QuickBase help topic.