Is this possible? It seems like Softr allows static filters only?
e.g.
I have 3 tables:
Sessions
Applicants
Rooms
Each session is linked to certain Applicants.
Each session is linked to certain rooms.
How can I assign the Applicant attending a specific session to a qualifying session room?
Hi @PeterG
Softr does support dynamic filtering on linked record fields, so this is possible, just not fully “automatic” in the sense of the system inferring the right room on its own.
Here’s how you’d typically set it up:
On the form or list where you’re assigning a Room to an Applicant’s session, you can add a filter on the Rooms field that says “filter by” the Session’s linked Rooms. So instead of showing every room in your base, the picker only shows rooms already linked to that specific session, that’s your “qualifying rooms” filter.
The linking itself (Applicant → Session → Room) still needs a place to happen. Usually that’s a form where the user selects the Applicant and Session, and the Rooms field is dynamically filtered based on the Session chosen in that same form.
If you want this to happen without any manual selection at all (e.g. auto-assign the first available qualifying room), that’s not something the filter itself can do, you’d need a Softr Workflow to handle the assignment logic based on the linked records.
So static filters are the default, but dynamic ones (filtering by a linked field’s value) are supported.
Thanks for your detailed reply.
Yes, that’s exactly what I need. I’m still stumbling around the Softr builder. But I get an error message - see image…
As I can see, this is a particular use case that may need a detailed investigation. Please reach out to support@softr.io with the details, and we will sort this out
