We have the same issue in several places on our sites. The workaround is painful - we have to manually populate multiple conditional filter lists, then keep them up to date.
“Sync options with data source” in conditional filters does not work when the AirTable field is a lookup field based on a linked record. Can you extend this functionality to populate the conditional filter list from the lookup field?
This is critical for us, as the linked record lookup is the Client name. Therefore we currently cannot filter lists automatically by client.
Just bumping this up the list to see if there’s any indication on when it will be possible? Have a lot of lookup fields that I need to use as dynamic filters in table view and link the option to data source (I’m using Softr DB as the source)
@softr we have been requesting this for years and it’s still not possible. I just submitted a feature request in the form, and I would like to know if and when it will be put on the roadmap.
This feature is absolutely crucial. It’s more important than push notifications and page management and all the other lovely features you’ve rolled out recently.
We have had to introduce a lot of duplication (and drift risk), as well as hundreds of lines of automation scripts, to create pseudo-single select fields for dozens of columns across different tables, all to deliver a picklist experience on the frontend of our Softr apps.
Every time a new column is added, new scripts have to be written/repurposed and yet-more duplication and drift introduced, just to add new picklist fields. The admin burden caused by this is very high, and significantly detracts from the benefit of having related records / relational data structures. A quick request to improve or update the frontend requires hours of work and more duplication to be introduced.
We would very much love to have lookup fields available in the frontend. Our data sources are Airtable and Softr DB.