Dynamic dropdown: populating & selected using Supabase

Hey all,

I'm new to FF & Supabase. I've searched a lot of the answers on this forum & youtube, but seems everyone that encountered this issue I found was using Firebase, so here it is:

So far, I have two problems:

1) I can't populate dropdowns when they come directly from a table. I can populate them when im refencing a view I created joining two tables together. I can't understand why, since my RLS is set to all for now in public. I have tried referencing the user ID in the tables that are failing to query, and also leaving user ID blank. But the view, which is read only works. Why?

2) How to properly store the selected value of the ID rather than the name, so I can make a backend query to create / update the row referencing the ID?

So far, I have tried a few approaches - both have failed.

  • Update component state and set component variable selectedLifeArea (integer) value to life_area_id

  • Another component variable, this time with a supabase row.

Whats wrong with my reasoning?

Thx in advance!

Supabase RLS

Example table that I can't display records

Dropdown list items

Dropdown Supabase query

Dropdown set variable action

1
1 reply