Advanced Airtable Workflow Automation and data organisation
Budget: $750 – $1,500 USD
I have an Airtable that i'd like to take to the next level.
I'm working for a small restaurant chain and our internal product management is pretty chaotic.
I'd like our Airtable to manage the following data sets:
- Supplier ingredients,
- Homemade Ingredients,
- Suppliers,
- Recipes that we sell to customers.
- Recipe that we make internally to use in other dishes,
- Prep schedules and prep tasks
The objectives are
1. Dynamically calculate costing of any ingredient, so if one recipe or ingredient is changed, all costing changes correctly with it, so we always knows our margins.
2. Dynamically calculate all nutritional information, (cal, kcal, fats, proteins, carbs), so if one recipe or ingredient changes, everything else changes with it, so we always know the health impact from our dishes.
3. Correctly manage the prep workflows for our staffs, so the system issue tasks, and ideally things prints on a label printer, that staffs physically can stick on containers.
4. Have the data sit in a good format and achieve a single source of truth for any descriptions, images or anything that goes into our products, so we can e.g. sync with our webflow menu and have one less menu to maintain (for example - having good data completeness, so we can draw from the database.
We have all information gathered, but i'm struggling to make the base work smarter for me. Here's a link to our base: https://airtable.com/appIY3uLswa3ZDrmG/shrm1M8JtmRXNkb9f
I'm working for a small restaurant chain and our internal product management is pretty chaotic.
I'd like our Airtable to manage the following data sets:
- Supplier ingredients,
- Homemade Ingredients,
- Suppliers,
- Recipes that we sell to customers.
- Recipe that we make internally to use in other dishes,
- Prep schedules and prep tasks
The objectives are
1. Dynamically calculate costing of any ingredient, so if one recipe or ingredient is changed, all costing changes correctly with it, so we always knows our margins.
2. Dynamically calculate all nutritional information, (cal, kcal, fats, proteins, carbs), so if one recipe or ingredient changes, everything else changes with it, so we always know the health impact from our dishes.
3. Correctly manage the prep workflows for our staffs, so the system issue tasks, and ideally things prints on a label printer, that staffs physically can stick on containers.
4. Have the data sit in a good format and achieve a single source of truth for any descriptions, images or anything that goes into our products, so we can e.g. sync with our webflow menu and have one less menu to maintain (for example - having good data completeness, so we can draw from the database.
We have all information gathered, but i'm struggling to make the base work smarter for me. Here's a link to our base: https://airtable.com/appIY3uLswa3ZDrmG/shrm1M8JtmRXNkb9f