Hi all! I am wondering how one might create fully dynamic filtering of linked records in a single field in a conditional form in Softr.
My boss had designed a database for a client with separate fields for different linked records for different user attributes. For example, we had a user attributes table that spanned age range, income, demographics, etc. To make each option in these categories show up only for specific fields, he disaggregated them into their own fields on a user, allowing an individual to use Softr and make selections exclusive to the attribute type. For example, salary ranges would only show up in the income field, racial information on demographics, etc.
Now, we want to move all the attributes into one field and filter by the attribute type, so have all the options in one field and have it look into the linked record to filter by category. 30-40k (category: income level) next to Asian American (category: demographics) next to Works in service category: job experience) etc, all filterable by their category but all held in one field.
I’ve tried this a fair amount of ways and it’s seeming…. not possible in the “form” page type in Softr. Any ideas about how to achieve this? we need it for an upcoming integration.
Thanks!
