Complete Beginners Guide to Implementing DataTable Widget with Flutterflow and Supabase

[@nehra88]

great video thanks! can you how to achieve this the same via a selected date range as well?

[@hopperpa5585]

Can you use Supabase query on this method

[@impossiblewords130]

Great video! I was able to follow easily and applied the same filter technique to a listview and to a gridview. Subscribed and looking forward to more! I had a question about the "ilike" statement, but a quick search revealed that it's an operator.

[@just_xolotl]

Thanks great to hear it helped!

[@sostine_waliaula]

Great tutorial, just an inquiry how can i achieve the same thing but with radio buttons instead of the drop down list

[@just_xolotl]

You can still access the selected option of the radio button in the widget state.

[@inzimamali]

Hi , ❤ your videos are really informative as well as easy to pick , can you please make at leat 2 or 3 more no that much advanced apps from scratch, the way you create the simpleNotes app project. Because to create UI is easier then the backend, wo please focus more on backend like quiries, data tables, connecting data etc

[@just_xolotl]

Sure thing! Do you have any specific suggestions you would like to see?

[@jimvh7557]

An interesting extension to this would be to have just one datatable component that will display the result of any json you feed it. It should be possible with custom actions right?

[@just_xolotl]

That’s cool it shld definitely be possible

[@ivanxam7093]

I love how you explain it, step by step and easy to follow. You already have one more follower 🙂 At minute 07:37 I get Status:200 (success) but it doesn't show me any array, it only shows [] What must be the error I have? Thank you very much and please continue teaching us [SOLUTION] The problem is because the table is created with Enable Row Level Security (RLS). Which is how it should be, but need to create an access policy before. If you take out the RLS it works and shows as in the example.

[@just_xolotl]

Thanks a lot!

[@kayzchronicupturn1015]

Thanks for the tutorial, I wanted to ask you how do I do so that when I open my page or reload it, the list of users appears by default. At the moment I have to search for something in the text field and then delete it so that the whole list of users appears.

[@just_xolotl]

Hi! You could create a default api call action (setting the searchString and columnName to be null) in the on page load action. This ensures that whenever the page is loaded/reloaded, an api call will be done to get the whole list of users. If it still doesn’t work, try changing the columnName variable to any one of the columns. Hope this helps!

[@jovichow4494]

great tutorial!

[@just_xolotl]

thanks!

[@lucianaribeirocorrea9088]

Hello! I'm from Brazil. Congratulations on the video. Could you teach me how to configure DataTable pagination? It loads 1000 lines and I need it to load more lines. In supabase I have a table with 10 thousand rows and FlutterFlow only displays the first 1000, it doesn't load more than that.

[@just_xolotl]

Hi this is likely due to Supabase itself imposing a max of 1000 rows being fetched at one time. Have you tried changing the max rows in Supabase settings? You can refer to this: supabase.com/docs/reference/dart/select Under the Fetch Data section

[@sostine_waliaula]

The flutterflow link is not working, it says project access restricted

[@just_xolotl]

unfortunately FlutterFlow disabled project sharing for free accounts. Will be working on getting a paid account soon. :)

[@DeSofSistemas]

NO! Is it possible to load more than 1000 records into DataTAble from Supabase?

[@just_xolotl]

Not too sure about the limits of the DataTable widget and don’t think it’s documented anywhere too. But it should be able to input 1000+ rows

[@DeSofSistemas]

Sin embargo no puedo. Estoy a punto de desestimar el uso de este control porque no encuentro solución. Si lo pudieras probar sería interesante saber. Gracias

[@haroldolontrajr4650]

Hi, Very good explanations! Could you share ( this project ) with us? Thank you in advance!

[@just_xolotl]

Sure! Here's the link to clone the exact project! app.flutterflow.io/project/datatable-tutorial-97br3v I also added it into the description!