I did come up with the idea to create a mirror table in Airtable, where I create a record for every follow, and add the user’s email and the group followed to each record. I then have Airtable create a field that has a string of ‘followers’ (user emails) for every event (based on the group it’s in), which I can use as a filter in Adalo.
Amazingly, this worked really well. However I got stuck with writing a single ID to a relationship field. It’s seems that it needs an Array format [“ID”] which Adalo doesn’t support. Is there any workaround for that? I’m thinking there is a way to write it as a string and have Airtable convert it back to a relationship but haven’t found a way to do that yet.