We are working in catering and would like to use our Airtable database to help us with the following:
- Shopping list
- Prep list
- packing list
- menu printing for selected events
the table is in read-only at:
[login to view URL]
Your work would consist of creating blocks using the Airtable Block feature (NO API to Airtable)/(tables) to handle the following:
Blocks requirements:
0/ all blocks shall be printable to printer or pdf file
1/ Shopping List: list of supplies and quantity for selected events, sorted by suppliers.
2/ Prep List: supplies quantities for selected events, based on recipes popularity out of total recipe factor. List to be sorted by ingredients, measurements in weight or packing unit if different from weight
3/ Packing list: list of ingredients for selected events, sorted per event or for all selected events, quantities in GNs (Volumes) if Weight per Volume ratio available, otherwise use packing unit, calculated based on recipes popularity out of total recipe factor.
4/ pizza & Gelato menu printing for selected events from a template with a company name and customisable header and logo, choice font (Fat Frank)
L GN = 5.50 l
M GN = 2.25 l
S GN = 1.40 l
If weight to volume ratio exists, convert weight to multiples of GNs: ie:
if volume < 1.40l, need 1 S GN
if 1.40l <= volume < 2.25l, need 1 M GN
if 2.25l <= volume < 3.65l, need 1 M GN + 1 S GN
if 3.65l <= volume < 5.50l, need 1 L GN
if volume >= 5.50l, displays multiples of L GN rounded to the upper 0.5 L GN
Existing tables:
- Supplies
- Ingredients, includes weight to volume ratio.
- Recipes
- Events
Hi there, this is Saima. I have 10 years of experience in content management on various platforms and websites, and I have worked a lot on Wikipedia and created many pages. Would you like to see my some sample link? We can negotiate more about work, delivery time and price. Good luck Regards; Saima.