Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Is there a way to do have CONSTANTS dadabase?

Topic Labels: Formulas
701 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.