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:
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
- Ingredients, includes weight to volume ratio.