Questions about table
# 🤝help
m
Hi, Actually I'm using BotPress for my studies and I want to create a nice bot but I'm stuck somewhere. I'm explaining I have a table Celeste Table which has "chapter", "side" and "video_part". I normally ask the person to send the chapter number and the side value but it's here I don't know what to do. I want the bot to select "video_part" from the table where chapter and side are the values I asked the user to send. To be simple : -> I ask the user to insert the chapter number ( I stock it in a variable"A") -> I ask the user to insert the side value ( I stock it in a variable "B") -> The bot uses like a "SELECT video_part FROM CelesteTable WHERE chapter = A and side = B ( but I don't know how to do it ) I will send a few screenshot : one with the table, one with what I already did. I hope you'll can help and I'm always free to provide more informations.
Screenshot about my table :
a
have you tried with find instead get? You could something like FindRecords Card: Table: CelesteTable Records Filter: Chapter is A and side is B Save it to record variable Then record[0].video_part
m
It works I thank you
a
Welcome!!
c
Thanks for your help @agreeable-accountant-7248 🔥 !
4 Views