## formula

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

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

February 5th, 2009 - 6:02 PM
Tags:

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. For this example let s call the variable [number_of_reps]

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
Tags:

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

This can happen because the field property for [num1] called "Treat blank as zero in calculations" is checked. This is checked by default, so you can do things like add and subtract lists of values which contain some blanks.

February 5th, 2009 - 6:02 PM
Tags:

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
Tags: