How do I create a Supabase collection with a limit? (and pagination)

Ask us anything How do I?
1

The workaround being used now is to use pagination. For example if the limit should be 6, I use page size = 6.

The issue is that when using the paginator element, the paginator shows as many pages as there are results in the original supabase colleciton. So if returns 1000 items, The paginator will show 1000 % 6 pages.

What I’m seeking is a way to limit to 30 page size = 6. Therefore creating a maximum of 5 pages.

2

You can use the Workflow Actions to create your own “collection” workflow and there in the Database | Select you have an option to do limit and offset also.

1 Like