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.