302 Found

Found

The document has moved here.

formula

Syndicate content

Use a field of type "Formula - URL (Link)". Set the cover text to "Click Here.." and then use a formula to point to a view that selects for only one record based on the Record ID# field which is unique for every record.

The URL for a view using the API is for example:

February 5th, 2009 - 6:02 PM

There is a way to do this using Application Variables and a Formula - User field. The first thing you need to do is define the number of users that will be participating in the 'round-robin' by creating an Application Variable.

February 5th, 2009 - 6:02 PM

By using a custom formula, you can create a report that displays the records where a date field in the record is equal to the current month (or previous or next month). If you want to base a view on the [Date Created] field value, then create a new report, choose Table report, and within the Filters section select the right button to enable filtering.

February 5th, 2009 - 6:02 PM

If your boss is like my boss, she wants to know what I accomplished this week, what I accomplished last week, and what I plan to accomplish next week. Building Reports in QuickBase to help you manage this reporting requirement can be a little tricky, but with some well-built formula fields in your data table, you can get it done.

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

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

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

Here is an example of a formula that returns a different price for each of several kinds of fruit. The data type of the result is Number.

case ([Fruit Name], "Apples", .5, "Pears", 1, "Berries", 4)

If the [Fruit Name] doesn't match any of the cases, null is returned. To return a default value when there is no match, add one more Number argument to the end.

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
302 Found

Found

The document has moved here.