I need a pre- order sheet for our food truck
Budget: $30 – $250 USD
We work with different schools regularly and they pre-order their crepes for a particular pickup time so they are hot and fresh when they pick them up fro our food truck.
We tried a regularly spreadsheet but people kept messing up other entries. This means we want to email the sheet to each teacher or participant and they can enter or edit their order only and select a time for pick-up.
I have a link to an attempt at this that didn't work for us because it had the option of 6 creapes per order, we only want one per participant.
The orher issue is we can only make about 10 crepes every 30 minutes. Can we make the sheet so the participant can select a time, however when that time is taken no one else can take it? Looking for ideas how this can work.
Here is an example of a sheet someone tried to build, but again it has 6x crepes per order. We only want one:
https://docs.google.com/forms/d/1S6LucqmFAhMnGHa15XMXZ6bpwCNu0SbsupRJIKKCzZs/edit?usp=sharing_eil_m&ts=643d54fa
We tried a regularly spreadsheet but people kept messing up other entries. This means we want to email the sheet to each teacher or participant and they can enter or edit their order only and select a time for pick-up.
I have a link to an attempt at this that didn't work for us because it had the option of 6 creapes per order, we only want one per participant.
The orher issue is we can only make about 10 crepes every 30 minutes. Can we make the sheet so the participant can select a time, however when that time is taken no one else can take it? Looking for ideas how this can work.
Here is an example of a sheet someone tried to build, but again it has 6x crepes per order. We only want one:
https://docs.google.com/forms/d/1S6LucqmFAhMnGHa15XMXZ6bpwCNu0SbsupRJIKKCzZs/edit?usp=sharing_eil_m&ts=643d54fa