Hi! I’m hoping to use Airtable to help manage crafting materials. I’d like to record purchased amounts using the unit of sale (say, yards of fabric, or pounds of flour) and set up a way to automatically convert that to the actual unit used when crafting (like inches/feet of fabric, or ounces/cups of flour). Ideally, of course, I’d be able to enter such conversions once somewhere, and have a formula field automagically apply them.
I figure the solution is either:
- A “Conversions” table with fields Unit1, Equals#, Unit2 and some sort of Lookup/Rollup automagic in the Materials table
- Some sort of funky formula with a ton of nested IFs (blech!)
Any ideas? I’ve tried searching both Google and the forums here but haven’t turned up anything.