Feb 07, 2020 06:41 AM
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
Feb 07, 2020 07:28 AM
I’d be happy to discuss some ideas with you, as well as getting a better understanding of how the Airtable will be an asset to your team and business.
Once we’ve discussed your vision and goals, I can then provide you an accurate price and timeframe to get the project started!
Schedule a free phone consultation via this link: www.wisedesign.co/schedule
To learn a little more about myself, please visit my website: www.wisedesign.co
If you’d like to connect with me on LinkedIn, please do so here: https://www.linkedin.com/in/eckline/
I look forward to hearing form you!
Feb 07, 2020 08:21 AM
What you are wanting done is well within my area of expertise and I would be happy to get on a call with you to discuss some of my ideas.
Feel free to reach out to me on email@example.com
Feb 09, 2020 10:13 PM
PM sent . please check.
Feb 10, 2020 10:24 AM
Would love to chat more about what you’re looking to achieve here.