Help! Supabase data, Retool dependent downs

Looking for help!

I am trying to pull data from my Supabase table
(PostgreSQL) and place into a dropdown list.

If dropDown1 (Supabase Data Query) is “Option A”

then dropDown2 (Supabase Data Query) is “optionb,optionc,optiond)

But if dropDown1 is Option f

then dropdown2 is optione,optionf)

Thanks in advanced!! Cheers

You need two queries, one for each dropdown. The query for dropDown2 will need a WHERE condition that references {{dropDown1.value}} to generate the list dependent on the selected dropDown1 value.

Something like this?