Share feedback, ideas and get community help

Updated last year

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 -->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
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
It is hard to program Typebot to be a scheduling platform, it should be powered by another tool.
That's also why I'm currently creating a Cal.com block
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)
@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
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?
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
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
@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
Definitely not easy to do that :/
Sigh
I was hoping it was "just" a matter of formatting the output
We can do this
Give me a minute
Do not worry also some hours πŸ˜‰
Thank you
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
Let me know if that works
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
Restaurant Reservation BOT [SOLVED]
Restaurant Reservation BOT [PARTIALLY SOLVED]
@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
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. 😦
Are you sure {{Data}} is set and not empty?
Can you print it in a text bubble before to check its content?
Fairly sure because Is an input data that user input using bot but i surely better verify
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
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