Filter dropdown options by another list (supabase)

Widgets & Design

I have a dropdown field. It gets the options from supabase. But for each user, I want that each option is only selectable once.

I have one table, where all options are listed and another table, where the option together with the user ID is written, after it has been selected.

I can't figure out, how to tell supabase to compare the lists and filter the options accordingly.

Much appreciated 😄

(Category may be wrong, dunno where to put it)

What have you tried so far?

My favourite solution would be to just set the filter condition, but it doesn't seem to allow a comparison between the two lists. I simply can't choose the column.

I also tried to filter beforehand with custom functions. Or throw an error when the selected dropdown value had been picked before, but that's not working either and doesn't seem like the fanciest solution.

Did you check FlutterFlow's Documentation for this topic?

Yes