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") For more, please see our Using Formulas in QuickBase help topic.

- 42299 reads

## Rate This

## Similar Articles

## Browse by Category

### Knowledge Base Categories

- Accounts (31)
- Application (57)
- E-Mail (7)
- Fields (38)
- Forms (18)
- Formulas (18)
- General (71)
- Other Product (7)
- Pages (1)
- Product (5)
- Reports (14)
- Roles (4)
- Search (1)
- Tables (5)

## Comments

## Post new comment