Skip to main content

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

  • January 24, 2024
  • 4 replies
  • 31 views

Forum|alt.badge.img+5

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

4 replies

Marcelo12
Forum|alt.badge.img+8
  • Inspiring
  • January 24, 2024

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
Forum|alt.badge.img+35
  • Genius
  • January 24, 2024

Forum|alt.badge.img+5
  • Author
  • Inspiring
  • January 24, 2024

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.


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

   


Forum|alt.badge.img+5
  • Author
  • Inspiring
  • January 26, 2024

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.


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