# Count and display number of rows in a table

**URL:** <https://community.weweb.io/t/count-and-display-number-of-rows-in-a-table/8351>\
**Category:** How do I?\
**Tags:** design, supabase\
**Created:** [April 29, 2024, 3:02pm UTC](https://community.weweb.io/t/count-and-display-number-of-rows-in-a-table/8351 "2024-04-29T15:02:15Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![BertrandG](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/bertrandg/32/5129_2.png) [@BertrandG](https://community.weweb.io/u/BertrandG)\
**Post date:** [April 29, 2024, 3:02pm UTC](https://community.weweb.io/t/count-and-display-number-of-rows-in-a-table/8351/1 "2024-04-29T15:02:15Z")

</div>

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](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/4/4e1aeb033710f1dc4fa6081042b22247ea8e29ed.png)

---

<div class="post-metadata">

**Author:** ![luka](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/luka/32/1571_2.png) [@luka](https://community.weweb.io/u/luka)\
**Post date:** [April 30, 2024, 9:44am UTC](https://community.weweb.io/t/count-and-display-number-of-rows-in-a-table/8351/2 "2024-04-30T09:44:25Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![BertrandG](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/bertrandg/32/5129_2.png) [@BertrandG](https://community.weweb.io/u/BertrandG)\
**Post date:** [April 30, 2024, 9:49am UTC](https://community.weweb.io/t/count-and-display-number-of-rows-in-a-table/8351/3 "2024-04-30T09:49:46Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![luka](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/luka/32/1571_2.png) [@luka](https://community.weweb.io/u/luka)\
**Post date:** [April 30, 2024, 10:16am UTC](https://community.weweb.io/t/count-and-display-number-of-rows-in-a-table/8351/4 "2024-04-30T10:16:38Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![archenia\_jsanchez](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/archenia_jsanchez/32/8656_2.png) [@archenia\_jsanchez](https://community.weweb.io/u/archenia_jsanchez)\
**Post date:** [May 2, 2024, 3:09pm UTC](https://community.weweb.io/t/count-and-display-number-of-rows-in-a-table/8351/5 "2024-05-02T15:09:08Z")

</div>

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](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/2/2faf22e7135f1a286f013ec7640189e738a0ffad.jpeg)