How to create a Simple Search in FlutterFlow using Supabase!
Vložit
- čas přidán 19. 06. 2023
- How to make a searchable list in FlutterFlow while using supabase and no more 3rd party extensions, should be fairly easy to follow, please let me know what you think in the comments. The lines are below, delete the brackets when you put your stuff in, and make it the same format as mine in the video.
[yourprojectid].supabase.co/rest/v1/[tableyou'researching]?or=([columnyoursearching].ilike.%[SearchString]%)
Authorization: Bearer [anonpublic API KEY]
apikey: [anonpublic API KEY]
Supabase, FlutterFlow, App Development, Database, Backend-as-a-Service, Rapid App Development, No Code, Low Code, Integration, Building Apps, Web Development, Mobile App Development, Cloud Database, Authentication, Realtime, APIs, Open Source, Backend, Frontend, NoSQL, SQL, Authentication, Authorization, User Management, RESTful APIs, Widgets, Firebase Alternative, Data Storage, App Hosting, Supabase Tutorials, FlutterFlow Tutorials, App Design, UI/UX Design, App Prototyping, Visual Development - Hry
I love how you get vaguely more pissed off as the tutorial goes on. More tutorial youtubers need to let their emotions show. this was very helpful btw thank you
Would love that fix for returning a single item if anyone figured it out. thanks
Hey i was running into problems similar to yours and realized that the Query Parameter was not needed and interfered with the query. That was my experience, anyway. Great video! Thank you for sharing this information!
I valid. I spent hours there before finding the problem.
Same problem here :D
2 hours until I saw your comment hahaha
my fellow victim of query paramaters hahaa
oof, I've been working on this for so long, so glad I saw your comment lol
thanks!! it took me 10 minutes thanks to you
Great!!, thank you so much, worked perfect for me and I was searching to do querys this way instead the supabase integration within FF.
Great stuff, man! I'd also be interested in seeing how you were able to implement the collapsible scroll on your details page. I have a similar detail page setup as yours (general buttons/options up top, an image, basic info, tab view). Right now on my app, everything down to the basic info stays stationary, but it looks like you figured out what seems to be a two-part collapse feature (image collapses first, then basic info collapses upon further scrolling).
To work with a single result, what you need to do is replace the JSON path entered manually to filter the results, with a JSON path that you enter manually in the flutterflow api after testing api results, and don't forget to check the "is list" box.
can you please elaborate on what you did? I am still not able to get this to work. Thank you.
how would the url look if i wanted to use "match at least one filter"?
If I want to do this with users, what parameter would i need to pass to load user information?
So 1 finding to help with "exact" text search. I set mine to follow your directions, however since I can't figure out how to do this with many to many joins ( I need to break things down by state, city, category and GIS, based on user input). I actually just created a column with multiple values in comma separated form and although it's not the most efficient on the DB side, I'm able to type pretty much exact.
I've a pretty large DB that I need to do m2m joins, if you or anyone figures it out... that'll be amazing!
Hey great video, Im building a similar app on flutterflow with listview. How do you get selectable items in your list view? After creating dynamic children, I can't assign any container to a different page? How were you able to click on an item and go to that page from listview?
awesome bro
Thanks you so much hey men to avoid URL encoding you can use * as an alias of the percent sign % for the pattern
Bro ... Thank you! I've been trying to figure this out for a while. Any idea on how to search for something based on the users location and category? My specific scenario: the user is logged in, zipcode is in DB, when they go to search for a category, I want to display results based on their location. ( Ex. User is looking for stores nearby to buy a specific fish type) not sure if I have to have two search fields or if I can get the location from DB and display filtered list.
Where I filter by id is present in ID, you can filter by Authenticated user zipcode is contained in database zip codes. Can use my search filter of ID, and add a second filter of zip code, with both filters, it should work as you expect.
Thanks again. I wasn't able to figure out visibility with two variables but I was able to do this.
I am having the same problem. it is weird, what I am searching is there but depending on what part of the word I am using will determine the success of the search.
To get rid of the error you have to use a condition to check if the json body is not null and reload the backend if it’s not empty that’s will fix the problem or the error it worked for me
Amazing video, it worked perfectly for me! Did you write the fish data yourself or did you gather it from the internet? I'm trying to build a comparison app for fish, so it would be helpful to have some data to start with.
Would love if this worked for returning a single value as opposed to just multiple.. anyone got any ideas?
never mind, figured it out.
@@richardsloan9395can you share how you got it to work? Thanks
@@richardsloan9395How??
@@richardsloan9395care to share?
@@richardsloan9395 How did you figure it out?
Here for me it returns "200", but always empty
There must be something up with your search terms, that indicates that you contacted the API correctly, but nothing matched your search.
It is the same for me, always just 200 and []. Don’t know why. Copied some select id from api documentation on Supabase and is not working.
pretty sure that you are missing a policy on your supabase table, classic mistake