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