Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

## Knowledge Base

## Can a field calculate its own data based on data in other fields?

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")

To learn more, please see our Using Formulas in QuickBase help topic.

- 75852 reads

## Comments

## Post new comment