I am trying to use Airtable as a datasource for a Softr website.
I have a table called Museums and another called Users.
A third table, Museum User Follows, contains records that note when a user follows a museum.
In the Museums table I have a look-up field for User IDs that correspond with users who have followed that museum. This is a two stage look-up from Users to Museum User Follows and then to Museums.
In Softr I now want to conditionally filter the list of Museums to show all and only the museums that a given user follows.
I’ve tried to do this in numerous ways but none of them work. Sigh!
Am I missing something. Surely this should be possible.
P.S. BTW I had this working in the previous version of Softr. Now it’s broken.