So sory but iam a bit confused
# 🌎general
k
So sory but iam a bit confused İn a proper way i can say I'm working on creating a bot that utilizes a table containing statuses. I want the bot to use the data from this table as choices. Additionally, if the status of a variable is true, the bot should not select the choices associated with a false status.
w
can you share a screenshot of your table and your current flow ?
k
I'm working on creating an order system for a restaurant using WhatsApp. I have a table with different menu options, each with a status indicating whether it's currently available (True) or not (False). I want the bot to show only the menu options that have a True status to the customer. Here's an example of my table: Menu Option Status Pizza True Pasta False Salad True Burger True How can I configure the bot to present only the available menu options (those with a True status) to the customer? https://cdn.discordapp.com/attachments/1245314410860515408/1245316225555370055/image.png?ex=66584e9d&is=6656fd1d&hm=fc09d1967a1ecdd7b9b1496d934e34fbf20eae1a522c60418c41fe92c65e6754&
w
okay i see
and how do you want your menu to be displayed ?
my filter is "dish is available"
and it returns a great array with all the dishes that are available
then you can use this array to do what you want
does it help ?
k
[ { "computed": {}, "stale": [], "id": 1, "createdAt": "2024-05-29T07:35:59.705Z", "updatedAt": "2024-05-29T09:03:50.590Z", "name": "opt1 ", "av": null }, { "computed": {}, "stale": [], "id": 2, "createdAt": "2024-05-29T07:36:09.815Z", "updatedAt": "2024-05-29T07:36:21.229Z", "name": "opt2", "av": false }, { "computed": {}, "stale": [], "id": 3, "createdAt": "2024-05-29T07:36:10.349Z", "updatedAt": "2024-05-29T07:36:25.524Z", "name": "opt3", "av": true } ] was the reply from the bot
can we let the bot to provide the dishes as multiple choises for the next node ?
'i am so thank full for your helping'
like i want the coustemer to get the availeble dishies and chose one from the
w
Yes got it
This was the first step
Will try , but not know I’m not available 😉
k
okay i am really thank full for you help when you have time
and i have a smal last qustion for also when you are availeble is there is any way to give accses to someone to change the status of the dishes from outside the botpress
w
will you have a lot of dishes ? because that's complicated to create "send messages" card when you don't know the number of messages that are available another soltution is to give to the user a text with all dishes available and then ask him to type the dish he wants (and then check again if it's ok) i think it's the easiest way
because that's not possible to iterate on carousel elements for exemple
k
thank you so much i will try to devlope it from this stage thanks alot ❤️