https://discord.gg/botpress logo
Join Discord
Powered by
The find record table is not working!!
# 🤝help
p
Hello! I am trying to greet returning users via using the find record table and then an execute card to greet them. So far all is good but this free text way of finding rows is failing! It either gives me the whole array or none! I tried it for a key check and it worked. But now nothing!!
@User
I tried with Email and still no luck!
f
Hey Could you send a screenshot of your table
And try and print @workflow.PersonName before you use the find records card
p
f
Can you try with an actual email
Instead of @sdf.con
try with something like tayma@gmail.com
p
okay
but my main target is to match names
still nothing
w
Hey buddy, have you tried using the user variable instead of tables to greet existing users?
p
I did yes. But I also want to use tables to show what record there is about them
b
I see no flaws, i replicated your example. Let's see, what could be you have some other logic in the middle of all this?
p
this is so weird!
I will send more bits to the flow
@billowy-morning-42410 I can send you the bot
b
ok @purple-dream-91712 send it to me, i will check
checking
@purple-dream-91712 Are you there?? I think I saw the problem with the bot
p
Thanks!
Will message you
b
Ok anyway let's talk here remember there are many others who may get the same problem and this conversation will help them a lot.
Let me finish checking a few things and I'll get back to you.
p
As you wish :))
b
The problem is that there is an empty space at the end of the names, if you remove it, it works. I'm going to check why that blank space is going in.
I have a few recommendations and a better way to search, but wait a little
p
Really appreciate it!
b
First of all, when you save, you have a blank space that you have here. 👆🏻
That simple detail makes it not to be found, it should make a trim but it saves it with that space.
Second, improve this filter a little by placing an execute code here
Create an object type variable called findPerson to follow me here
Here in the expression just place this
And here, better place this:
As an implementation I recommend you to search by email, not by name, you can have several people with the same name. Here I am leaving it by name, but you can easily ask for their email first and do the same thing only you search in the table for the email. The email is unique the names are not, so in that implementation you do if two people have the same name you would only get the first one you find in the table.
p
ahh, that's great! Thank you so much!! Those little things really make a difference. I just wanted to make a point that's why I selected the name, but I will definitely use the email for client-related applications.
b
😉
o
Thank you!
5 Views
PreviousNext
Powered by