Help

Is there a way to do have CONSTANTS dadabase?

Topic Labels: Formulas
298 1
cancel
Showing results for 
Search instead for 
Did you mean: 
phmandar
4 - Data Explorer
4 - Data Explorer

Is there a way to easily setup and use “constants” across an entire Base?

For instance, the price of oil per barrel might be 40. I have a lot of formulas that depend on that price. In addition, I might have several numbers like this that need to be referred to from multiple formulas - for instance the /mile that the IRS accepts for the mileage deduction, the number of tons of gravel contained in a gravel truck, etc.

The advantage of the “constants” is that, if the price of oil changes, I need to change just one number in one place; I don’t have to hunt through tons of formulas looking for a hard-coded “40” in the formula.

Is there an easier way to do this?

1 Reply 1

Airtable doesn't natively offer that functionality, but you can hack it together using the technique that I demonstrate in this Airtable podcast episode.