- Two Adalo collections, (“Users” and “Categories”), in a many-to-many-relationship. When a user logs in for the first time, they can pick which Categories they like.
- One external collection on Airtable (“Events”). One of the columns is a multiple select drop-down that allows me to pick from a list of the same Categories from the Adalo collection.
In Adalo, I want to show a list of all the events that match the Categories selected by the user. I want to create a filter like ({Category}=‘logged in user selected categories’), but it doesn’t allow me to select the names of the selected catgories (it only shows the count). Can this be done?
Thanks,
lki