302 Found

Found

The document has moved here.

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

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

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

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

Let's assume the Date field is called "My Date" and that the Time of Day field is called "My Time of Day". Let's also assume that you want the display format to be:

08-17-2001 01:01:01

Then the text formula to display the date and the timestamp fields together in one cell would be:

[My Date] & " " &

Right("0" & Hour([My Time of Day]), 2)

& ":" &

February 5th, 2009 - 6:02 PM

Assuming your date field in QuickBase is called "Your Date Field Name".

Create a text formula field and set the formula to this:

Year([Your Date Field Name]) & "-" & Right("0" & Month([Your Date Field Name]), 2) & "-" & Right("0" & Day([Your Date Field Name]), 2)

February 5th, 2009 - 6:02 PM

Here is a formula that will calculate the third Friday of the current month:

NextDayOfWeek( FirstDayOfMonth(Today()) - Days(1), 5 ) + Weeks(2)

It can be broken down to the following steps:

1) find the first day of the month containing today
2) go back one day to the last day of the previous month
3) find the next Friday (the number 5 represents Friday)

February 5th, 2009 - 6:02 PM

I have values for four fields representing a quarterly balance in an account. They are filled in successively over time, so at any given time they may not all be filled in.
---

This is a good place to use the Nz() function. It allows you to use a value if it is not null, but if it is null use an alternate value instead. You can cascade them to successively check each field.

February 5th, 2009 - 6:02 PM
302 Found

Found

The document has moved here.