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.
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
Thanks,
I saw that Supabase also uses small letters in new tables,
out of curiosity, why you discourage capital letters usage ?
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.
