? Every day, a pizza shop offers a different specialty slice pie of the day

[marcolevito]

Every day, a pizza shop offers a different specialty slice pie of the day, which I have listed on Airtables. The chat bot platform I'm using now is bad at telling time, so when someone starts using the chatbot, I would like to make an API call to my base to see

(1) what time it is and if the pizza shop is open; 

(2) if the pizza shop is serving slices [which serves between 11:30 a.m. and 2:00 p.m.]; and

(3) What specialty slice pie of the day they're serving?

I'm a newbie, but I don't mind doing research. If you can just give me a general direction, I would greatly appreciate it. thank you

[Marcelo]

Hi!

What chat bot tool are you using?

you can integrate with Make.com and create a workflow (sequence of steps) to search every "question" you mentioned. Then send the answer to chatbot

i'm an Airtable and Make consultant, you can contact me for further help.

[ScottWorld]

As @Marcelo mentioned above, your best bet is to use Make’s advanced integrations and automations for Airtable.

I give an entire demonstration on how to use Make to connect ChatBots with Airtable on this Airtable podcast episode:

https://youtube.com/watch?v=LyNdh9E7bOQ&list=PLqssva4liHRwHhQIpTXekG8WObEoyC2F1&index=14&pp=gAQBiAQB

[marcolevito]

Yes, I am using Make.com and ChatBotBuilder, or CBB. Can you give me the basic structure of how you would run this?

Right now, I do use these platforms for an appointment-setting chat bot where CBB sends an API that creates a record, and then that triggers a script that grabs all of the user's information. And that's about the only experience I have, if that helps. I've included the photos. 

I'm going to assume I would have the system timestamp element included in the base spreadsheet along with the pizza of the day and its corresponding date.

1) Would I use a filter in Make to find the open/closed time, day of week, and date parameters for pie-of-the-day, or would that be done in a formula field inside of Airtables?

2) Would I use a similar trigger setup where CBB creates a record first to get a record ID? Or is there a better way? Thanks again for your help. mark

   

[marcolevito]

 

Here's an easy question for you, I'm trying to get this formula to work tell me what's not correct. I wanna match the slice pie of the day date with the current date