Hereās what I think should work:
- Use Joined List to combine all the hours that you want to check against in a single string.
- Use ācontainsā to check whether a particular appointment hour is part of that string.
Hereās what I think should work:
Unfortunately, this didnāt work. It doesnāt check if the hour is part of the string (āinā operator), instead, it checks if the hour contains (or not) the whole string.
E.g.: Filter to show only hours that doesnāt contain ā12:00, 13:00, 14:00ā, this means all of them, in other words, no filter is applied.
Why doesnāt
All Hours
contains This Hour
work?
The problem is that the āchosen hoursā list is not on the same sheet as the choice options and I have different lists of āchosen hoursā based on stores.
A store can have multiple appointments, and Iām making an appointment on a store. I have to filter the choice options based on the already taken hours.
Iām using the screen context to get the list of appointments that are already taken for that store, and the problem is that on the left field of the filter it only shows me the āchoices sheetā fields, therefore, all hours fields.
My structure for that basically is:
A sheet with all the hours possible (Where I get the choice component data)
and
A sheet with all the appointments made for stores.
Ah, got it! Iāll see what I can do.
Iām loving this feature. Itās real value so far for me has been its ability to narrow down to the T the value required from a long list of choices. My users no longer need to select their item from a drop down choice list. Somehow it knows what the choice was. Iāve applied this to two of my templates already. Itās brilliant for the end user to see what they had selected on another tab already filled out for them on the next tab. Iām going to be brutally honest, I still have not fully grasped the mechanics of it and feel like Iām just firing the right shots in the dark. How Iām getting it to work, Iām trying to understand. But now I can have a list of 30 items on a choice component and not require the user to select theirs from that long list. Iāve noticed itās more effective with an if then combined with choice. When I have fully understood how this is all working, Iāll get back.
Iād really like to see this work for forms soon. My use case: a user can select multiple positions in the Organization but should not be able to select one that is already assigned to them. So there is an āadd a position formā that would be great if the position choice field in the form could be filtered to not contain User --> Position. This would mean the choice only includes options not already selected by the user.
Hang on! @ Let me quickly test something. I think this already possible. The form you are asking them to complete contains the list ? You just donāt want positions already applied for by a user to appear on that list ?
Correct! Iāve tried using the new method but it doesnāt work in forms.
Okay Iām testing it. Iāve been firing shots in the dark and hitting the target too
Let me just check. Tx
@kyleheney Trur doesnāt work and only works when I create a relation. If this will serve your purpose you can make a copy unless you already have this working for you.
Thanks for trying! I was hoping to use the new simpler method in forms, so hopefully it gets pushed through to forms soon!
This looks to be working more than it has been in the past. Itās still not 100% functional for dates/times though.
This seems to be part of the āis Included inā conditions that were recently added.
See screenshots of a FORM:
Dept 2 choices after selecting Dept1 in the first choice component (Dept 1 is no longer a choice)
Filter conditions for 2nd choice component (where the āDept 1ā is Screen --> Dept 1):
Still an issue ā Dates and Times! When I try to perform similar filtering with times, I donāt get the Screen condition as an option:
If the fields are not Date fields, I do get the Screen condition as a filterable option. If I change the type of my column to a Text field, I am able to filter out the previously selected option (like the first few screenshots above) by using the āIs not included inā filter, but doing that removes the āon or afterā and other date-related filtering conditions.
@Mark do you know if this is a bug, or by design? Iām just curious because having it work for Date/Time fields would be very helpful if itās possible.
Seems like a bug. Iāll look into it, thank you!