Count and display number of rows in a table

Ask us anything How do I?
,
1

There are several tables on my dashboard: Projects without a delivery date, Tasks without a delivery date and Jobs without a delivery date. This can get very confusing and that’s why I would like to just show the number of rows in the table headings. On clicking on the number, the complete table is then displayed (with a display formula). How can I get the number of rows?
image

2

Are you using Supabase? Are you using back-end pagination?

3

Yes, I’m using Supabase with back-end pagination.

4

I’m not a Supabase expert, but I think often you have to do a separate request to Supabase to get the total item count from SQL editor

5

I’m assuming this is my lack of understanding between back-end and front-end pagination, but I’m using Supabase to populate a collection from which I get the total to display in my “25 of 574” text.

image
image1898×632 122 KB