# Filtering choices based on other field **URL:** \ **Category:** Ask for Help\ **Created:** [January 29, 2026, 10:25pm UTC](https://community.glideapps.com/t/filtering-choices-based-on-other-field/86191 "2026-01-29T22:25:40Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![costarica](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/costarica/32/86266_2.png) [@costarica](https://community.glideapps.com/u/costarica)\ **Post date:** [January 29, 2026, 10:25pm UTC](https://community.glideapps.com/t/filtering-choices-based-on-other-field/86191/1 "2026-01-29T22:25:40Z")
Hi there, I’m building a scheduling app and I’m trying to prevent double-booking an employee. I’ve created a choice field that hides the staff member from being assigned a role if they are already assigned to a role. It works fine for one role, but if I use ‘or’ it doesn’t work. Screenshot attached. Any tips would be appreciative. ![Screenshot 2026-01-29 at 12.22.12 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/2/62cdaef2cdb1357671be5a2e636074ac78b0804c.jpeg) ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [January 30, 2026, 12:51am UTC](https://community.glideapps.com/t/filtering-choices-based-on-other-field/86191/2 "2026-01-30T00:51:21Z")
I would add a conditional for name not in guide 1 as well. ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [January 30, 2026, 12:54am UTC](https://community.glideapps.com/t/filtering-choices-based-on-other-field/86191/3 "2026-01-30T00:54:38Z")
Use different sources for each picker. If all three use the same source, selecting a person in one can remove them from the shared list. Then the picker may clear because the selected value is no longer in its list. Once cleared, the name can show up again. Can you show which source is connected to each choice component? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 30, 2026, 12:58am UTC](https://community.glideapps.com/t/filtering-choices-based-on-other-field/86191/4 "2026-01-30T00:58:44Z")
Why don’t you have a multi-choice component? ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [January 30, 2026, 1:00am UTC](https://community.glideapps.com/t/filtering-choices-based-on-other-field/86191/5 "2026-01-30T01:00:02Z")
That would also work, except if he wants the seperate choices for UI experience. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 30, 2026, 1:35am UTC](https://community.glideapps.com/t/filtering-choices-based-on-other-field/86191/6 "2026-01-30T01:35:01Z")
> [@costarica](#): > > but if I use ‘or’ it doesn’t work Think about what the filter statement is actually saying. It doesn’t work because it should be an AND. You want to check if Name is not in Guide2 AND not in Guide3. If you use OR, then only one of those conditions has to be true instead of both to include the name in the list. Meaning if the Name is not in Guide2 OR the name is not in Guide3, then the name is included in the list. The only time it would work to filter out the name would be if the same name was in both Guide2 and Guide3.