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

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

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

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

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

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

MMario Barretta

Attachment

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

Add a reply

Share feedback, ideas and get community help

Restaurant Reservation BOT [PARTIALLY SOLVED]