Enable AND Logic for Multi-Select Dropdowns in Interface Designer 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 appro
