In our business we have customers signing up to receive multiple grocery items on a weekly basis, and then we go to their homes and refill them. They sign up for an initial amount that they want, and then we refill it to that amount each week. Then, we charge them based on how much product was needed to refill it. I am trying to figure out if there is a way to use Airtable to link the records of what the customer is subscribed too, how much we add that week to refill, and what the charge is each week.
For Example: Sharon signs up for the service and subscribes to the following:
1 dozen eggs - 1 pack
8 oz of granola - 2 packs
1 loaf of bread - 1 pack
16 oz of rice - 3 packs
When I go in to do her refill, I want to be able to go to 1 table and see what items she is subscribed to, how many packs she is subscribed to, and then also enter how much product I’m adding to get her back up to these levels, while also having it calculate the cost based on the price of each item and how much I am adding.
I’m trying to figure out if there is a way to get all this information in one easy pop up window, rather than building a tab for each customer. Any ideas would be appreciated!