I have an inventory app. It has a Products Table and a Usage table. When the users enters the usage they enter the product and the qty. (The units of the qty vary so I have a field that tells what the units are). Many products usage is by the gram. I also have Restock process that add product. Some product they order by the pound but we want to auto convert the qty to grams. Is there a way to have the user add the restock qty in lbs and then convert it to grams?
It would be nice to calculate this before submitting so they could see the conversion on screen.
I think the way to go is something like this:
- Use a custom form to add your Usage.
- When the user enters the product, you do a lookup to retrieve your unit for that product.
- Allow users to entere their own quantity with their own unit, and then convert to your standard unit using this column.
- Record the new row using your standard unit, but also store the user’s original quantity and unit for displaying purposes.