Typebot
Log in to community

Share feedback, ideas and get community help

D
F
M
a
g
Join

Restaurant Reservation BOT [PARTIALLY SOLVED]

MMario Barretta
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 -->https://discord.com/channels/1155799591220953138/1181878805787320330/1182339090964820128)

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
Attachment
httpsthdaily.s3.us-west-1.amazonaws.comfinal_size-Restaurantbots_20231030220954.png
B
M
27 comments
BBaptiste
What I would do is using a fully-fledge booking system for restaurant. Something like: Zenchef.

Use an embed bubble to display the Zenchef calendar
BBaptiste
It is hard to program Typebot to be a scheduling platform, it should be powered by another tool.
BBaptiste
That's also why I'm currently creating a Cal.com block
MMario Barretta
Thank you very much for suggest but client do not want to have a recurrency paid system and he love the typebot flow that i've shown him so i've thought to try to create this in some way (if possibile)
MMario Barretta
@Baptiste Is not there a way to can have an output that recover alla records joined to a date?
In my sheet i've all reservations on a specific date but when i get row and i set to show me result it only show the first row and not alla (also if i've set)
Attachment
image.png
BBaptiste
It should work in theory have you checked the format of {{DATACONSULTAZIONE}}? How does it look? Does it really match the format of the Date values in your spreadsheet?
MMario Barretta
Yes it is the same dd/MM/yyyy format also because if it wasn't I don't think I would have even received the first result of the reservations I have in my sheet.
Now anyway I am recreating the flow from scratch to try to have a clean situation to share with all people on this channel
MMario Barretta
https://app.typebot.io/typebots/clptl58og0009jx0gspmaynvb/edit

Here my Bot shared

@Baptiste now with a recreated and clean flow i see a begin of good result on that i see my info based on specific date but in a not good format because they are all in line and not on column how i'd like so to see exactly name and data and table etc
Attachment
image.png
MMario Barretta
@Baptiste
so to give all info this is my Bubble text code :

PRENOTAZIONI GIORNO (Reservation Date) {{Data}}

Nome e Cognome (Name Surname)
{{Nome Cognome}}

Tavolo (Number Table )
{{Tavolo}}

Persone (Number people)
{{Persone}}


And the Output that result is not good becasue i'd need to have

PRENOTAZIONI GIORNO (Reservation Date) {{Data}}

Nome e Cognome (Name Surname)
{{Nome Cognome}}

Tavolo (Number Table )
{{Tavolo}}

Persone (Number people)
{{Persone}}
-------
Nome e Cognome (Name Surname)
{{Nome Cognome}}

Tavolo (Number Table )
{{Tavolo}}

Persone (Number people)
{{Persone}}
------
Nome e Cognome (Name Surname)
{{Nome Cognome}}

Tavolo (Number Table )
{{Tavolo}}

Persone (Number people)
{{Persone}}
----
etc etc
Attachment
image.png
BBaptiste
Definitely not easy to do that :/
MMario Barretta
Sigh
I was hoping it was "just" a matter of formatting the output
BBaptiste
We can do this
BBaptiste
Give me a minute
MMario Barretta
Do not worry also some hours 😉
Thank you
BBaptiste
Here is what you could provide to a Set variable:

Plain Text
let text = 'PRENOTAZIONI GIORNO (Reservation Date) ' + {{Data}}[0]
{{Data}}.forEach((date, index) => {
  text += '\n\nNome e Cognome\n' + {{NomeCognome}}[index]
  text += '\n\Tavolo\n' + {{Travolo}}[index]
  text += '\n\Persone\n' + {{Persone}}[index]
})
return text
BBaptiste
Let me know if that works
MMario Barretta
reallly thank you

In your code there were two typo about Nome Cognome (was written all in a wingle word and i separated theme "Nome Cognome" and "Tavolo" was "Travolo" (so i corrected and now it work perfectly)

have a nice day
Attachment
image.png
MMario Barretta
Restaurant Reservation BOT [SOLVED]
MMario Barretta
Restaurant Reservation BOT [PARTIALLY SOLVED]
MMario Barretta
@Baptiste sorry to disturb you newly but in my flow happen that the iutput result do not whow the same view and i see only the variable text that you have sent me in the past days:

let text = 'PRENOTAZIONI GIORNO (Reservation Date) ' + {{Data}}[0]
{{Data}}.forEach((date, index) => {
text += '\n\nNome e Cognome\n' + {{Nome Cognome}}[index]
text += '\n\Tavolo\n' + {{Tavolo}}[index]
text += '\n\Persone\n' + {{Persone}}[index]
})
return text
Attachment
image.png
MMario Barretta
Attachment
image.png
MMario Barretta
here my new shared bot https://app.typebot.io/typebots/clptl58og0009jx0gspmaynvb/edit on that i've these problems,
I'm trying to do a lot of variations but without to reach the previous result. 😦
BBaptiste
Are you sure {{Data}} is set and not empty?
BBaptiste
Can you print it in a text bubble before to check its content?
MMario Barretta
Fairly sure because Is an input data that user input using bot but i surely better verify
MMario Barretta
Yes it's printed on bubble and the data row has info (if you want you can see on google sheet --> https://docs.google.com/spreadsheets/d/1I0WZUXTP0Mml7y_ayMTeYnPQVU9_IrHyxtMomtaGaz0/edit?usp=sharing)

I really do not understand what's happening and what i've done to break the output on my bot --> https://app.typebot.io/typebots/clptl58og0009jx0gspmaynvb/edit
MMario Barretta
Just to update that now i see this result (whn i've more of one record for a data)
First i had only a single reservation for a date.
Now i've added a new reservation for same date and the output look like "correct" (i've to correct somie spaces but it s readable)
Attachment
image.png
Add a reply
Sign up and join the conversation on Discord
Join