- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
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.
However I canโt seem to figure out how to easily setup constants in AirTable. Right now Iโm sticking them all in a โConstantsโ table, with each row having just โNameโ and โValueโ, where Name is something like price_of_oil_per_barrel and Value is 40.
BUUUT โฆ referring to these constants is A PAIN โฆany referring Table first needs to add a link to my โConstantsโ table, and then tediously create a new linked Field for each value that I want to refer to in any formula in that Table. So if there are 11 constants that Iโm going to use in formulas in a single Table, Iโll need to link to11 fields (then possibly hide themโฆ).
Is there an easier way to do this?