Airtable + Adalo referencing

  1. 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.
  2. 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?


@lki, you can get the listify component created by @knight and convert the many to many relationship as a csv. :