To whom it may concern,
I run a small (one-man) catering business with dozens of menu items.
I need a way of capturing my customers’ orders into a table, in such a way that I can use Airtable’s blocks feature to generate a job sheet for each particular order, detailing all the foods a given customer has ordered.
The tricky bit comes as I need the job sheet to not only tell me the foods the customer has ordered, but to also tell me the ingredients and quantities I require to make a the various items on the job sheet.
This get very tricky in Airtable as a number of our products are composite items – meaning something that we make ourselves from a bunch of other products.
For example, if my customer has ordered 100 portions of Greek salad, I need to record that on the job sheet, and then I need the job sheet to spit out the ingredients for me, which in the case of 100 portions of Greek salad would be:
Lettuce Heads x 3.33
Greek Feta 180G x 6.67
Kalamato Olives 250G x 3.33
Cherry Tomatoes 220G x 10.00
Red Onion Loose x 6.67
Cucumber Whole x 3.33
Yellow Pepper Whole x 6.67
Previously I used to do this in Excel, but I decided to bring the system into Airtable instead, since I have a whole bunch of other workflows which Airtable is already helping me manage.
The problem I have is that, the only way I could figure out to do this in Airtable, is by having many dozens of columns for my products, and then many hundreds of columns calculating the ingredients for each product.
Having to work with these hundreds of columns is busy becoming unmanageable, and so I am hoping to find somebody to help me improve the system and make it more streamlined and friendly.
Please do let me know if you can help.
Many Thanks, Charles
+44 78 2575 2596