Knowledge Base

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

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.

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit