How to display a large Table / Grid?

I am using the Table / Grid plugin (just getting started). Nice work @Thimo !

I want to fetch data from an external DB, but I realize bubble has a 100 row limit per query. What’s the best way to deal with larger tables? If i have (say) a 1000 row table, is there a way to page through the results via the DB connector?

If you add a parameter and filter based on this parameter you can indeed page through the results, it should look something like this:

Use the value of field id from the last entry in the result set as input for the next SQL query.

1 Like

Alright thanks - I was worried if the user changes the sort order, which would change the pagination, etc. I play around with it!