# Populate page dynamically from Supabase using a URL param

**URL:** <https://community.weweb.io/t/populate-page-dynamically-from-supabase-using-a-url-param/15879>\
**Category:** Ask us anything\
**Tags:** supabase\
**Created:** [January 27, 2025, 9:52am UTC](https://community.weweb.io/t/populate-page-dynamically-from-supabase-using-a-url-param/15879 "2025-01-27T09:52:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![pkontopoulos](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/pkontopoulos/32/12315_2.png) [@pkontopoulos](https://community.weweb.io/u/pkontopoulos)\
**Post date:** [January 27, 2025, 9:52am UTC](https://community.weweb.io/t/populate-page-dynamically-from-supabase-using-a-url-param/15879/1 "2025-01-27T09:52:05Z")

</div>

Hi,

I am trying to create a dynamic page that will display information from a Supabase record,  
I am passing a URL param with the record Id,  
I am setting up a Supabase Select action in page load workflow to fetch the record so I can populate the form fields,  
I managed to bind the URL param to the value,  
but I don’t know how can I define the table column Id to be used for filtering the record based on URL param.

Any help is appreciated.

 ![Screenshot 2025-01-27 at 11.48.49 AM](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/4/4059f94ff373c034a87776d7dbd8eae4b058b200.png)

---

<div class="post-metadata">

**Author:** ![Broberto](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/broberto/32/5918_2.png) [@Broberto](https://community.weweb.io/u/Broberto)\
**Post date:** [January 27, 2025, 9:21pm UTC](https://community.weweb.io/t/populate-page-dynamically-from-supabase-using-a-url-param/15879/2 "2025-01-27T21:21:51Z")

</div>

It should be the column name of the ID you’re binding as a value. So if you have an Exams.exam\_id column in Supabase and you want to filter by that, you just type in exam\_id in plain text. Also I highly discourage calling tables with capital letters like you did for the Exams table

---

<div class="post-metadata">

**Author:** ![pkontopoulos](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/pkontopoulos/32/12315_2.png) [@pkontopoulos](https://community.weweb.io/u/pkontopoulos)\
**Post date:** [January 28, 2025, 6:12pm UTC](https://community.weweb.io/t/populate-page-dynamically-from-supabase-using-a-url-param/15879/3 "2025-01-28T18:12:25Z")

</div>

Thanks,  
I saw that Supabase also uses small letters in new tables,  
out of curiosity, why you discourage capital letters usage ?

---

<div class="post-metadata">

**Author:** ![Broberto](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/broberto/32/5918_2.png) [@Broberto](https://community.weweb.io/u/Broberto)\
**Post date:** [January 29, 2025, 2:08pm UTC](https://community.weweb.io/t/populate-page-dynamically-from-supabase-using-a-url-param/15879/4 "2025-01-29T14:08:18Z")

</div>

Because SQL interprets everything in lowercase and if you want to have uppercase tables, you have to explicitly do certain precautions which are annoying. Also WeWeb Supabase integration sometimes misbehaves. Basically, it just causes useless issues.