# šŸ†• New containing screen context for conditions **URL:** \ **Category:** General\ **Created:** [July 11, 2020, 5:07pm UTC](https://community.glideapps.com/t/new-containing-screen-context-for-conditions/12316 "2020-07-11T17:07:42Z")\ **Posts on this page:** 15\ **Page:** 3
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [August 12, 2020, 1:51pm UTC](https://community.glideapps.com/t/new-containing-screen-context-for-conditions/12316/41 "2020-08-12T13:51:08Z")
Hereā€™s what I think should work: 1. Use Joined List to combine all the hours that you want to check against in a single string. 2. Use ā€œcontainsā€ to check whether a particular appointment hour is part of that string. ---
**Author:** ![Gabriel\_Sobral](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gabriel_sobral/32/6513_2.png) [@Gabriel\_Sobral](https://community.glideapps.com/u/Gabriel_Sobral)\ **Post date:** [August 12, 2020, 5:37pm UTC](https://community.glideapps.com/t/new-containing-screen-context-for-conditions/12316/42 "2020-08-12T17:37:01Z")
> [@Mark](#): > > - 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. 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. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [August 12, 2020, 7:18pm UTC](https://community.glideapps.com/t/new-containing-screen-context-for-conditions/12316/43 "2020-08-12T19:18:35Z")
Why doesnā€™t `All Hours` contains `This Hour` work? ---
**Author:** ![Gabriel\_Sobral](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gabriel_sobral/32/6513_2.png) [@Gabriel\_Sobral](https://community.glideapps.com/u/Gabriel_Sobral)\ **Post date:** [August 12, 2020, 8:01pm UTC](https://community.glideapps.com/t/new-containing-screen-context-for-conditions/12316/44 "2020-08-12T20:01:01Z")
> [@Mark](#): > > `All Hours` contains `This Hour` 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. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b27a2b4c8bf3dca660bd7980b6af4f85496bb09d.png) 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. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [August 12, 2020, 8:31pm UTC](https://community.glideapps.com/t/new-containing-screen-context-for-conditions/12316/45 "2020-08-12T20:31:28Z")
Ah, got it! Iā€™ll see what I can do. ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [August 16, 2020, 11:21am UTC](https://community.glideapps.com/t/new-containing-screen-context-for-conditions/12316/46 "2020-08-16T11:21:10Z")
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. ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [August 16, 2020, 11:28am UTC](https://community.glideapps.com/t/new-containing-screen-context-for-conditions/12316/47 "2020-08-16T11:28:01Z")
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. ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [August 16, 2020, 11:39am UTC](https://community.glideapps.com/t/new-containing-screen-context-for-conditions/12316/48 "2020-08-16T11:39:17Z")
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 ? ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [August 16, 2020, 11:54am UTC](https://community.glideapps.com/t/new-containing-screen-context-for-conditions/12316/49 "2020-08-16T11:54:31Z")
Correct! Iā€™ve tried using the new method but it doesnā€™t work in forms. ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [August 16, 2020, 12:08pm UTC](https://community.glideapps.com/t/new-containing-screen-context-for-conditions/12316/50 "2020-08-16T12:08:23Z")
Okay Iā€™m testing it. Iā€™ve been firing shots in the dark and hitting the target too šŸ˜‚ Let me just check. Tx ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [August 16, 2020, 1:33pm UTC](https://community.glideapps.com/t/new-containing-screen-context-for-conditions/12316/51 "2020-08-16T13:33:53Z")
@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. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/43cc10d9910bb5bf92cbbe4651c5a1e15399d3c9.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a7652f8e7ff56285fc76a1f3d43db156cf8f69b7.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/cda2279593414f179758d913b3a56b97c426892b.jpeg) ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [August 16, 2020, 5:16pm UTC](https://community.glideapps.com/t/new-containing-screen-context-for-conditions/12316/52 "2020-08-16T17:16:03Z")
Thanks for trying! I was hoping to use the new simpler method in forms, so hopefully it gets pushed through to forms soon! ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [September 8, 2020, 6:29pm UTC](https://community.glideapps.com/t/new-containing-screen-context-for-conditions/12316/53 "2020-09-08T18:29:46Z")
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: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c9aedc287421971cb50d0dba6d3f2b156fdee871.png) Dept 2 choices after selecting Dept1 in the first choice component (Dept 1 is no longer a choice) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/fb1e071cf6c1156b589fe9aa4145057410859c2e.png) Filter conditions for 2nd choice component (where the ā€œDept 1ā€ is Screen --\> Dept 1): ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/807abbb146fca382f928ca4d788968f0a74e893e.png) 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: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b5236939b2dafaf949b2e73960bb16ba48d53e9e.png) 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. ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [September 9, 2020, 12:14am UTC](https://community.glideapps.com/t/new-containing-screen-context-for-conditions/12316/54 "2020-09-09T00:14:21Z")
@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. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [September 9, 2020, 12:15am UTC](https://community.glideapps.com/t/new-containing-screen-context-for-conditions/12316/55 "2020-09-09T00:15:54Z")
Seems like a bug. Iā€™ll look into it, thank you! [Previous page](https://community.glideapps.com/t/new-containing-screen-context-for-conditions/12316.md?page=2)