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.

- 80755 reads

## Rate This

## Similar Articles

## Browse by Category

### Knowledge Base Categories

- Accounts (29)
- Application (54)
- E-Mail (7)
- Fields (40)
- Forms (19)
- Formulas (19)
- General (66)
- Other Product (7)
- Pages (1)
- Product (4)
- Reports (15)
- Roles (4)
- Search (1)
- Tables (5)

## Comments

## Post new comment