When setting up a new collection, I want the collection to contain data from two tables. So I was trying to use the advanced mode to join the tables (as explained https://docs.weweb.io/plugins/data-sources/supabase-data.html#advanced-mode) (RLS is right now set up for testing so that every authenticated user could do anything). However, as soon as I click “Advanced” the option disappears and I cannot select “Guided” mode any more (so no selection of columns possible). Why is that? How to fix this?
Hhm, are you sure? I’m having this problem for quite a long time already with every collection that I try to set up in Advanced mode. I tried it just now 7 times - and it does not change anything. If it’s a bug, there should still be some logic behind and not only work randomly, I guess.