We use Airtable Interface to match caregivers to clients based on required skills such as Alzheimer’s care, hospice experience, and Hoyer lift. Multi-select fields are the best structure for this type of data because they are clean, scalable, and easy for our team to maintain.
In the Interface, we use multi-select dropdowns such as “Skills and Experience” to narrow down caregivers. However, when selecting multiple values in the dropdown, the behavior uses OR logic instead of AND.
For example, if we select both “Alzheimer’s Care” and “Hospice Experience,” the results show caregivers who have either skill, not those who have both.
In real workflows, we often need to find caregivers who meet multiple required criteria at the same time, such as Alzheimer’s care and hospice. The current dropdown behavior makes this difficult and not intuitive.
We understand there are workarounds such as adding multiple conditions or creating helper checkbox or formula fields for each skill. However, these approaches are not intuitive for staff, add unnecessary complexity, and require maintaining many additional fields.
What we need is simple.
We need the ability for multi-select dropdowns in Interface Designer to support AND logic when selecting multiple values.
Suggested solutions:
- Add a toggle such as “Match ANY” or “Match ALL”
- Allow multi-select dropdown selections to behave as AND instead of OR
This would significantly improve usability for teams managing matching workflows such as healthcare staffing and eliminate the need for complex workarounds.
Thank you for considering this. This would be a huge improvement for real operational use.
