Restaurant Reservation BOT [PARTIALLY SOLVED]
Good morning, everyone,
Already in the past I tried to make a bot for table reservation inside a restaurant but failed to complete it due to time issues and also inability
Now I should have a little bit more time available however the inability remained the same so I try to expose you, synthetically, the flow to understand how you would realize it and if you could give some hints.
P.S. I have already created my bot for the collection of the main data and its transposition into an excel sheet but the problems arise later and during the management of the flow that I now try to expose:
1) Data collection (name -surname - phone - email - number of people - date - arrival time - end time - table number) --> DONE
2) Entering that data into a google sheet --> DONE.
3) Checking that in case you enter a date and time already occupied for the table number you select an error message is returned --> NOT DONE
4) Summary of all orders for a specific date that is manually imputed --> DONE. (thx to @Baptiste -->Restaurant Reservation BOT [PARTIALLY SOLVED])
Step 3 is necessary so that the girl who collects the customer's phone reservation and enters it on the screen cannot overlap two reservations on the same table or time
Step 4 is necessary to do a pre-check activity during the phone call with the customer asking for reservations at such a date and time so that all the reservations that are there for that day for each table are immediately seen on the screen.
Ideas and suggestions to be able to fulfill points 3 and 4?
Now with what I have accomplished I can only tell the customer to look at the excel sheet (where there are ALL reservations) and it is possible to enter equal reservations for the same table and time.
Thanks to all
Already in the past I tried to make a bot for table reservation inside a restaurant but failed to complete it due to time issues and also inability
Now I should have a little bit more time available however the inability remained the same so I try to expose you, synthetically, the flow to understand how you would realize it and if you could give some hints.
P.S. I have already created my bot for the collection of the main data and its transposition into an excel sheet but the problems arise later and during the management of the flow that I now try to expose:
1) Data collection (name -surname - phone - email - number of people - date - arrival time - end time - table number) --> DONE
2) Entering that data into a google sheet --> DONE.
3) Checking that in case you enter a date and time already occupied for the table number you select an error message is returned --> NOT DONE
4) Summary of all orders for a specific date that is manually imputed --> DONE. (thx to @Baptiste -->Restaurant Reservation BOT [PARTIALLY SOLVED])
Step 3 is necessary so that the girl who collects the customer's phone reservation and enters it on the screen cannot overlap two reservations on the same table or time
Step 4 is necessary to do a pre-check activity during the phone call with the customer asking for reservations at such a date and time so that all the reservations that are there for that day for each table are immediately seen on the screen.
Ideas and suggestions to be able to fulfill points 3 and 4?
Now with what I have accomplished I can only tell the customer to look at the excel sheet (where there are ALL reservations) and it is possible to enter equal reservations for the same table and time.
Thanks to all
Discord
Discord is the easiest way to communicate over voice, video, and text. Chat, hang out, and stay close with your friends and communities.
