BrianHunot1

3 years agoQrew Cadet

# Formula field that is unique to each record in a table

Is there a way to have a formula field be unique to and have different values for, each record? Each of the 40 records in our Locations table has fields that describe the location and these are unique to each record. For instance, the address field. However, the formula fields in this table are 'universal' by Quickbase design; the formula field has the same value and performs the same calculation across all records using values in fields that change with each record. Is there a way though to have the ability to put a different formula in the same field in each record so that it will use the right numbers for each individual record?

We have 40 locations that have tanks for liquid storage. Every location has different size tanks. We measure the tanks with yardsticks, such that each inch of height equals a specific volume. I made a simple CASE formula that will return a volume for each tank given an inch measurement. I found that the numeric entry fields would change with each record but the formula field was the same, because there can only be one value in that field for the table.

In another table, with a somewhat similar scenario, I put an IF formula in front of the CASE formula that would only perform the calculation on the field if current record matched a certain Location name. The problem is that I would have to create over 120 of these fields, once for each tank at each location.

The other solution I thought of was just to have a formula field that housed the IF and CASE formulas for each location all in one field. This field however would have thousands of lines of data, which seemed excessive.

So I figured that I would ask to see if there was a simpler solution.

------------------------------

Brian Hunot

------------------------------

We have 40 locations that have tanks for liquid storage. Every location has different size tanks. We measure the tanks with yardsticks, such that each inch of height equals a specific volume. I made a simple CASE formula that will return a volume for each tank given an inch measurement. I found that the numeric entry fields would change with each record but the formula field was the same, because there can only be one value in that field for the table.

In another table, with a somewhat similar scenario, I put an IF formula in front of the CASE formula that would only perform the calculation on the field if current record matched a certain Location name. The problem is that I would have to create over 120 of these fields, once for each tank at each location.

The other solution I thought of was just to have a formula field that housed the IF and CASE formulas for each location all in one field. This field however would have thousands of lines of data, which seemed excessive.

So I figured that I would ask to see if there was a simpler solution.

------------------------------

Brian Hunot

------------------------------