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.
I would add a conditional for name not in guide 1 as well.
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?
Why don’t you have a multi-choice component?
That would also work, except if he wants the seperate choices for UI experience.
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.
2 Likes