Skip to main content

Is there a way to do have CONSTANTS dadabase?

  • January 7, 2024
  • 1 reply
  • 35 views

Forum|alt.badge.img+2

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

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • January 7, 2024

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