All topics

Filtering api's data

Julien

1 year ago
Hi guys,

I would like to be able to filter data displayed following an API call.

I put an input field linked to a variable, but I can't filter the data. I tried with the filter and match block, but i can't achevé this

What are the best practices for doing this?

Thanks
✅1
Erik Beuschau

1 year ago
Hi @Julien
Great question!
If I understand your question correctly, you want to filter your API data based on an input in your application?
I've recorded a quick example of how you can achieve that here.
Let me know if it's helpful 🤞
💪3
Julien

1 year ago
Thank you very much Erik !
Just try, this work fine 👇
https://un_peu_de_style-nocodenews.toddle.site/

But it's only filter the first word of my text.

Which one use to filter anywhere in a sentence ?

Can't achieve with Match 😕
Jacob Kofoed

1 year ago
Hi @Julien I think the "Includes" formula will achieve this. It states: "Test if an array or string includes a given item"
👍1
🤘1
Julien

1 year ago
I'll test this later and I'll come back to tell you if it works 😉 thank you very much Jacob
Julien

1 year ago
Yep @Jacob Kofoed ! This work perfectly, thank you very much
🎉3
Tod

6 months ago
Great energy @PeterShaw! Your continuous contribution to the toddle Community just made you advance to Community Level 1!
@Erik Beuschau
Hi @Julien
Great question!
If I understand your question correctly, you want to filter your API data based on an input in your application?
I've recorded a quick example of how you can achieve that here.
Let me know if it's helpful 🤞
Vizualinx

1 month ago
Hi @Erik Beuschau Thank you for the video. what if i want to search ion 2 fields? for example i have first name and last name, how could i search in both fields?
Lucas G

1 month ago
Use an OR node
@Vizualinx
Hi @Erik Beuschau Thank you for the video. what if i want to search ion 2 fields? for example i have first name and last name, how could i search in both fields?
Erik Beuschau

1 month ago
What Lucas said 👆
With an Or formula, you can have as many conditions as needed. And only one of them has to be true for the item to be included 👍
@Lucas G
Use an OR node
Vizualinx

1 month ago
thanks that worked🙏🏻
but see in the video, when i type both names (records from both fields) it wouldn't shop up. How can i fix this?
@Vizualinx
thanks that worked🙏🏻
but see in the video, when i type both names (records from both fields) it wouldn't shop up. How can i fix this?
Lucas G

1 month ago
That's due to however you set up your condition
It should be something liek does first name include this or does last name include this
If they are different columns, then it should be showing up
@Lucas G
That's due to however you set up your condition
Vizualinx

1 month ago
What am i doing wrong?
@Vizualinx
What am i doing wrong?
Max

1 month ago
You are saying "If ellie includes ellie grossman". This will always be false
@Max
You are saying "If ellie includes ellie grossman". This will always be false
Vizualinx

1 month ago
So how can i make this work?
@Vizualinx
So how can i make this work?
Max

1 month ago
What is it that you want to say? If you can say it in English, you can translate it to nodes 😊
@Max
What is it that you want to say? If you can say it in English, you can translate it to nodes 😊
Vizualinx

1 month ago
thats why i made i screen recording cuz it's hard to explain in words...🫣
@Vizualinx
thats why i made i screen recording cuz it's hard to explain in words...🫣
Max

1 month ago
Well, then it is hard to implement. First you need to be clear what you want to do and be able to communicate it. After that, it is just translation
@Vizualinx
What am i doing wrong?
Lucas G

1 month ago
The 'space' and full name together is breaking it
As Max pointed out, you are checking if ellie or grossman includes ellie grossman
You can concat them for a 3rd check if you want
I suggest also lower casing the search input otherwise it'll break
Vizualinx

1 month ago
I understood the problem, but i can't understand how to fix it.
@Lucas G
I suggest also lower casing the search input otherwise it'll break
Vizualinx

1 month ago
Thanks. i'll do that.
Lucas G

1 month ago
"You can concat them for a 3rd check"
Vizualinx

1 month ago
Sounds like i'm too dumb...🫣
do i just need to remove the space?
Lucas G

1 month ago
You can have a 3rd check in your OR node that checks for the full thing
@Lucas G
Vizualinx

1 month ago
Ooohh, now it makes sense!
Thanks!!🙏🏻
Vizualinx

1 month ago
Thank you @Lucas G, it works!!
🙌1

Filtering api's data

Julien

Erik Beuschau

Julien

Jacob Kofoed

Julien

Julien

Tod

Vizualinx

Lucas G

Erik Beuschau

Vizualinx

Lucas G

Vizualinx

Max

Vizualinx

Max

Vizualinx

Max

Lucas G

Vizualinx

Vizualinx

Lucas G

Vizualinx

Lucas G

Vizualinx

Vizualinx

Stop scrolling. Start building.

Chat with @team-toddle

Video call our CEO

Get in touch!

Product

Company

Resources

Community