How to search a Supabase table in Flutterflow

[@AldrichCarrasco]

Excellent Video, please more with supabase + flutterflow

[@Gab-mf6xq]

Thanks for this. It was so so helpful!! Can I please recommend a video for you to do on supabase and flutterflow?? It will garner a lot of interest/views. I am looking to do a 'favorite' function in an app. for example, if a user is browsing cars, I want them to be able to click on an icon to save it as favorite for them. I also would like the icon to change once they have done that (conditional formatting) annd if they see that car on any other page in the app the icon will know they have already saved it as their fav. What is the best way to do this??

[@geopopos]

This is exactly what i was looking for! Thank you so much!

[@kulumbapaul3065]

Awesome video! Thanks for sharing!!

[@camiloperezdearce1]

This is awesome, thanks for sharing

[@niceproductsinamazonsa]

thank u very much this what i was looking fo

[@moumous87]

would really appreciate to see how you came up with the custom action

[@jai_v]

thanks for the great video. i think FF allows me auto-generate the data type based on the JSON response, this is a recent feature update. I'm bit confused as to how to implement limited access to read/write of the search results depending on the user in a secure manner where one cannot access results for any user besides themselves.

[@lordcortes1]

very good video thanks.

[@markh-thai]

I would like to see a video about the correct structure for the page with regards to columns, rows, containers, primary scroll and also where to use the correct text type like camelCase and the_underscore etc. these always confuse a non coder like me.

[@rapidmvp]

That’s a good idea, I’ll put it on the list

[@duanyeloyestradagarcia1696]

Hello mate. Two things that maybe you can help me with. Does this code only works with tables that are entirely text?? I mean, all of the columns are text types. If you can response it´ll be so helpfull. Also in the website that you upload the code you put two SELECT commands in the first piece of code. But really this is good stuff, thanks for the work you´re doing

[@AutomationWithSholz]

thanks for sharing

[@markh-thai]

How do you handle the search input being like “Pringles Texas BBQ” and it will search supabase for “Pringles”, “Texas”, “BBQ” and return the list from supabase for all that contain like “Pringles”. Ive seen all the videos doing it the opposite way around but I need to take a photo input (AI extracted brand, product) and search similar products we have in our Database.

[@YashModi-b1j]

Great video , so if I have 100k database and find the name like this so what is the solution for this ? How to make scalable?

[@rapidmvp]

If you are only searching by name I would limit the search to that column then return the corresponding row. No point in searching the entire table.

[@NileshGupta-nt2ui]

Liked the Video, please more with supabase + flutterflow, as very little contents online.

[@Gab-mf6xq]

If I wanted to limit the search results to say the 30 most relevant search results, would I do that in the supabase function or the flutterflow action?

[@rapidmvp]

Look into the LIMIT clause in Postgres. It will return the number of records stated by the limit you set

[@lemn9544]

What if when I get my data I get it with an API call that paginates the data, can i still apply what you did and if yes, will the data that i searched for be also paginated?

[@marcionakanishidepieri8758]

Hello teacher I tried to find the api call in your videos but I couldn't find it. I would like information regarding the API call I tried but was unsuccessful

[@Skountrianos.george]

Hello , so i tried it in my app and it shows me an error for an unexpected null despite the fact that in dev options in the raw response it shows me the the result values correclty. please let me know if you have any idea edit: when i tap on the error in test mode the error disappears and it shows me the values correctly but still everytime i run the action the error pops up.

[@rapidmvp]

If you have an unexpected null, assuming you have mapped the json correctly to where you are displaying it, the first thing I would do is check you have default values assigned to any text objects your are using. I tend to set all of the default values to "Not Set". That way if there is a null value returned from your search it will display the default value and not crash. May not be that, but the best place to start.

[@Skountrianos.george]

i set the default values but still these errors occur (Another exception was thrown: Unexpected null value. Another exception was thrown: Assertion failed:) Note that the values are correctly displayed at the ui @@rapidmvp

[@rapidmvp]

@@Skountrianos.george for the unexpected null I have found this with a data grid using this method. A way around it is to have the data grid conditionally visible. i.e. only display it if your custom action return value is not null. Bit of a hack but it works. That may cure the issue of that one.

[@Skountrianos.george]

@@rapidmvp I tried your code and I modified it with ai in order to make something a little different . The problem is ai put as a type future string and string as return value so it displays all the data in one . I tried to put future map string dynamic and json as return type but it doesn’t work out. If you have any idea what is the problem let me know . Thank you in advance . Edit: I can show you the code if you are willing to see what’s the problem

[@Lucas.Jonathan]

Hello, I want to make a contribution and a request: Implementing the solution from this video, I couldn't get results until I put the table name in Supabase in quotes ("your_table") in the corresponding places of the function we created. That solved it, I hope it helps you. This type of search works great with exact words, but fails with words with spelling errors or phrases with mistakes. Could you improve the Supabase function so that the search is user-friendly for inexperienced users?

[@duanyeloyestradagarcia1696]

Thats obvious

[@seenawardi6817]

Just so everyone knows, this method is not secure. Your search results will be clearly visible in your browsers developer console.