Skip to main content

Food court management

  • September 25, 2020
  • 3 replies
  • 103 views
S
Forum|alt.badge.img

Hi all,

I’m running few food courts in parallel in our company.
Each is in a different location.

I want to create a process that will help me do the following:

  • Create a menu for each day of the week (maybe even more than 1 menu per day as we have few meals) including the amount available for each item in the menu
  • Allow users to order 1 item from the menu (per day, per meal)
  • Allow the kitchen manager to review the orders
  • Allow the kitchen worker to mark orders as delivered

Later I would want to create some dashboard stats & inventory management.

I would be happy to understand if there is a template that works best for me or how do I build this?
Thanks,
Shay

Q

3 replies

Kamille_Parks11
Forum|alt.badge.img+27

Make a [Menus] table where each record has a date, and maybe another field to show the menu type (i.e. “breakfast”, “dinner”, etc. if you want multiple menus per day). Add a formula field called {Status} using a formula like: IF({Date Field} < TODAY(), "Old", IF({Date Field} > TODAY(), "Future", "Current")).

Make a [Menu Items] table where each record is an item which can be ordered.

Make a [Schedule] table where each record links to a {Menu Item} and a {Meal}, with another record for {Max Count} to store how many of that item can be ordered. Add a lookup field called {Meal Status} pointing at the [Meals] table’s {Status} field. Make a filtered view called “Available” where {Meal Status} = “Current”.

Make a [Orders] table where each record is a user’s order for a particular menu item from a particular meal/menu. Add a field linking to the [Scheduler] field which only allows selections from the “Available” view (so people can only order from current menus). Add a checkbox field to mark when the order has been delivered.

Go back to the [Schedule] table and add a count field which counts how many linked {Order} records there are. Add a formula field called {Left Available} which subtracts the count of order records from the {Max Count} field. Adjust the “Available” view to also only include records where {Left Available} > 0.

ScottWorld
S
Forum|alt.badge.img
  • Shay_Afek
  • Author
  • New Participant
  • September 26, 2020

Make a [Menus] table where each record has a date, and maybe another field to show the menu type (i.e. “breakfast”, “dinner”, etc. if you want multiple menus per day). Add a formula field called {Status} using a formula like: IF({Date Field} < TODAY(), "Old", IF({Date Field} > TODAY(), "Future", "Current")).

Make a [Menu Items] table where each record is an item which can be ordered.

Make a [Schedule] table where each record links to a {Menu Item} and a {Meal}, with another record for {Max Count} to store how many of that item can be ordered. Add a lookup field called {Meal Status} pointing at the [Meals] table’s {Status} field. Make a filtered view called “Available” where {Meal Status} = “Current”.

Make a [Orders] table where each record is a user’s order for a particular menu item from a particular meal/menu. Add a field linking to the [Scheduler] field which only allows selections from the “Available” view (so people can only order from current menus). Add a checkbox field to mark when the order has been delivered.

Go back to the [Schedule] table and add a count field which counts how many linked {Order} records there are. Add a formula field called {Left Available} which subtracts the count of order records from the {Max Count} field. Adjust the “Available” view to also only include records where {Left Available} > 0.


Thanks!
That sounds like a great place to start with.

2 quick questions:

  • How do I manage different food courts and where do I manage the end users?
  • Is there a template I can use to jump start this? or someone that can help me create it in 1/10th of the time it will take me?

Thanks again!

Kamille_Parks11
Forum|alt.badge.img+27

Thanks!
That sounds like a great place to start with.

2 quick questions:

  • How do I manage different food courts and where do I manage the end users?
  • Is there a template I can use to jump start this? or someone that can help me create it in 1/10th of the time it will take me?

Thanks again!


Q1: Make a table for [Food Courts] and a table for [Users].

Q2: Check out the Template Gallery and the Airtable Universe for any examples which could get close to what you need. If you post this in “Hire a consultant” category someone will offer to build it for you. You do have a full set of instructions though so you might as well try to build it yourself, you’ll get a much better understanding of the advantages/limitations of the platform that way.

S
S
Terms & ConditionsAccessibility statement