Mar 22, 2020 08:10 AM
I am very new to airtable so I don’t know if my question makes any kind of sense. I hope that you will bear with me. I make bath & Body products. So far I have 3 tables with their related fields
Mar 22, 2020 10:13 AM
Mar 22, 2020 11:47 AM
Thank you so much Bill! I will go there now!
Mar 22, 2020 10:35 PM
In addition to what @Bill.French said, I do think you are having problem because you are adding the amount and the PU in the same field, making this field not recognizable as a number, but rather a single line text (correct me if I’m wrong). You should separate the amount and the PU and make sure the amount field is a Number field so you can use it in the formula.
If you need more help, let me know.
Mar 23, 2020 07:57 AM
Thank you so much for your response. In fact, the “Amount/PU” is just the title. It’s only one value, i.e it is the amount of ingredient in a bottle or a box or a jar as it is packaged. So for instance, when I buy coconut oil from the store, it comes in an 84 oz jar. and this field is a number field in my table.Then the Price/PU is a $field, and corresponds to the price of the 84 oz jar. After spending 3 hours (!!!) on it, my husband was finally able to find the answer by using “Lookup” and linking “ingredients” (where I had already entered the list of ingredients with the corresponding Amount/PU and price per PU) with a new formula field in the same table called “unit cost of ingredient” : Fx Unit Cost = Price per PU/Amount per PU.
As I go along using the database and filling the forms, I will probably come across something I will need help with. When that happens, I will be sure to take you up on your offer.
Thanks again and be safe!