Formulas

Syndicate content

You can use a Formula – URL field to create a URL that takes a viewer to a specific Web page. Formula - URL fields enable you to combine information from different fields in your application into a single URL. You use the "&" symbol to combine the values of several fields into a single URL or add the value of one or more fields to a URL string.  

September 19th, 2011 - 2:09 PM

Typically in QuickBase, forms usage is determined at either the role level, or at the report level. You can, however, use a formula URL button to call upon specific forms regardless of forms usage settings. This is useful if you‘ve created multiple data entry forms, each with their own layout, that you wish to call upon at various stages of the record entry process.

August 6th, 2010 - 11:08 AM

In order to display a date in this special format, you'll need to create a new field whose job is only to display the date.

To do so, add a field to the table containing your existing date field and make its type "Formula - Text". (To learn more, please see our Add a New Field help topic.)

February 5th, 2009 - 6:02 PM

QuickBase formulas can be used within a record to compute and return a value. Generally formulas can only be used within a single record and can not span across multiple records in a table. For instance, in an employee table with a field Salary, the Salary for individuals can not be computed as a percentage against all other employees' salaries.

February 5th, 2009 - 6:02 PM

If your append only field is called "Notes" then you can create a formula text field that shows the last entry in "Notes" using the following formula:

Right([Notes],"[")

February 5th, 2009 - 6:02 PM

You can easily do this in QuickBase. You'll need to create a few new fields in both your customer and quotes tables, relate these tables and then set up a special field to capture this combination number. To do so:

1. In your Customer table, create a Numeric field called "Customer Number".

February 5th, 2009 - 6:02 PM

The total value at the bottom of a column is the total of all values above it in the report. The same is true of the average value at the bottom of a report. The average value is the average of all the values in the column above it.

February 5th, 2009 - 6:02 PM

Create a report with a custom formula column of type "Text". Use the following formula:

Case(DayOfWeek([Your Date Field's Name]), 0, "Sunday", 1, "Monday", 2, "Tuesday", 3, "Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday")

Then sort and group on the custom column.

February 5th, 2009 - 6:02 PM

The formula looks like this:

Right("00" & Left([IP Address], "."), 3) & "." &

Right("00" & Left(Right([IP Address], -1 + Length([Ip Address]) - Length(Left([IP Address],"."))),"."),3) & "." &

Right("00" & Right(Left([IP Address], -1 + Length([Ip Address]) - Length(Right([IP Address],"."))),"."),3) & "." &

Right("00" & Right([IP Address], "."), 3)

February 5th, 2009 - 6:02 PM

right("000" & floor([octet1]), 3) & "." &
right("000" & floor([octet2]), 3) & "." &
right("000" & floor([octet3]), 3) & "." &
right("000" & floor([octet4]), 3)

February 5th, 2009 - 6:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

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