- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 24, 2024 01:12 AM - edited ‎Jan 24, 2024 01:14 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 24, 2024 04:47 AM - edited ‎Jan 24, 2024 04:48 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 24, 2024 05:48 AM - edited ‎Jan 24, 2024 05:49 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 24, 2024 12:53 PM
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
   
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 26, 2024 02:53 AM - edited ‎Jan 26, 2024 02:56 AM
 
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