# Cannot Get Filters to Work Anymore **URL:** \ **Category:** Ask for Help\ **Created:** [September 11, 2024, 6:15pm UTC](https://community.glideapps.com/t/cannot-get-filters-to-work-anymore/76303 "2024-09-11T18:15:01Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![mustangTC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mustangtc/32/91321_2.png) [@mustangTC](https://community.glideapps.com/u/mustangTC)\ **Post date:** [September 11, 2024, 6:15pm UTC](https://community.glideapps.com/t/cannot-get-filters-to-work-anymore/76303/1 "2024-09-11T18:15:01Z")
Good afternoon everyone! I am at my wit’s end trying to figure out why these filters will not work. Especially when I first attempted this in a different area of my app, it worked perfectly, but the same data on a different screen with the same setup and filters won’t for some reason. Backstory: My app is for the employees of the school I work for. One of the many things they can do on it is to submit their absence requests. I currently have the logic/actions to send the requests to their supervisors, and if the supervisor approves them AND they requested a substitute teacher as part of their request, it sends a notification to our sub’s apps that a day is available. The subs can go to their version of the app, view the available days, and mark themself as Interested or Not Interested in working that day. The employees responsible for choosing what sub to use have a screen on their app that shows a calendar. The calendar only displays requests that have been approved by the supervisor, and have a Sub Scheduled status as Pending. What I’m Trying To Do: When these employees select one of the choices on the calendar, I have an overlay pop up with a summary of that request in a Fields component. Below that is a Collection that displays the list of subs that marked themself Interested in working that request. The filter for that collection is supposed to show only the interested ones where the date of the request matches the date that pulls when the sub completes the Interested/Not Interested submission, and where the Requester on the sub submission matches the Employee name of the absence request. This setup worked flawlessly when I had it located in a different section of the app, but I had to move it once I realized the area I originally had it in wasn’t meant to be accessible by the employees that choose the subs. Once I moved it though, the filters failed. I have checked everything I can think to check. When I remove the two filters that reference screen data, it shows names again, but they aren’t filtered to show only the ones for that person and date. ![Sub Interested](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/a/cad2d9d6cd32e61acf5ab545404e4c5c369f599f.jpeg) ![Absence Form](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/6/36681df8aea2a7256b0b831eefca1e8d0d474f14.jpeg) ![Removing Filters](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/e/7eb17f514d75f568690553c18edd93b1d1283e43.jpeg) ![Filters Failing](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/d/8d1e3da6eb04e89be69884c80f014226fccd6676.jpeg) Any suggestions? I can attach more screenshots as necessary, please excuse the edits on them as I have to protect some of the information displayed. ---
**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:** [September 11, 2024, 6:21pm UTC](https://community.glideapps.com/t/cannot-get-filters-to-work-anymore/76303/2 "2024-09-11T18:21:24Z")
Very likely the dates don’t match. Don’t forget that there is always an underlying time associated with a date. The days may match, but the times may not. Are you sure the filters are identical for the dates? Is one possibly using ‘Within’ instead of ‘Is’? Can you show the data from the data editor instead of the sheet? Can you show screenshots of filter on the screen that works? ---
**Author:** ![mustangTC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mustangtc/32/91321_2.png) [@mustangTC](https://community.glideapps.com/u/mustangTC)\ **Post date:** [September 11, 2024, 6:28pm UTC](https://community.glideapps.com/t/cannot-get-filters-to-work-anymore/76303/3 "2024-09-11T18:28:20Z")
![Date Setup for Sub Screen](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/1/91de49650f76141d1da1c941cccf991d795a7598.jpeg) ![Date Setup for Absence Screen](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/7/d70d9d066ae3a9f80ef4e7b38e59027df774004d.jpeg) ![Filter Detail](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/5/45cd76783b8c2f0e8aaaefaae32118e1bbd69659.jpeg) ---
**Author:** ![mustangTC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mustangtc/32/91321_2.png) [@mustangTC](https://community.glideapps.com/u/mustangTC)\ **Post date:** [September 11, 2024, 6:31pm UTC](https://community.glideapps.com/t/cannot-get-filters-to-work-anymore/76303/4 "2024-09-11T18:31:03Z")
They are both setup as Short Dates and Date Only. The Sub Interested submission actually copies the date field from the absence request they are marking their interest on and shows up in the date field on the sub data. I can’t show a screenshot of the screen where it was working, because with my confidence that it would work correctly when moved, I went ahead and deleted that Container a couple days ago… Sorry! ---
**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:** [September 11, 2024, 6:38pm UTC](https://community.glideapps.com/t/cannot-get-filters-to-work-anymore/76303/5 "2024-09-11T18:38:59Z")
Can you change the date formatting for both date columns to long, so we can see the times that are attached to those dates? ---
**Author:** ![mustangTC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mustangtc/32/91321_2.png) [@mustangTC](https://community.glideapps.com/u/mustangTC)\ **Post date:** [September 11, 2024, 7:03pm UTC](https://community.glideapps.com/t/cannot-get-filters-to-work-anymore/76303/6 "2024-09-11T19:03:30Z")
They’re both set to Date Only, so if I switch them to include the time they all just say 12 AM. ---
**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:** [September 11, 2024, 7:13pm UTC](https://community.glideapps.com/t/cannot-get-filters-to-work-anymore/76303/7 "2024-09-11T19:13:59Z")
Can you trying changing your date filter from ‘Is’ to ‘Is Within’? ---
**Author:** ![mustangTC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mustangtc/32/91321_2.png) [@mustangTC](https://community.glideapps.com/u/mustangTC)\ **Post date:** [September 11, 2024, 7:25pm UTC](https://community.glideapps.com/t/cannot-get-filters-to-work-anymore/76303/8 "2024-09-11T19:25:11Z")
![Filter Within Date](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/b/1ba2977fda88ce3ba97021fb7151fb4999837ce4.jpeg) ![Filter Without Date](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/d/ddf8e3dd75c9778242cbdb5e3718a4f063e3bf2f.jpeg) ![Status Only](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/a/1aca5ef66d22c8152b6465a33b1152c040ea2592.jpeg) No dice. Even if I remove the date filter it won’t work. It only displays data now if I remove both the filters that reference In Screen data points. But without those two, the list shows all Interested entries for all requests, not just the ones pertaining to the displayed request. ---
**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:** [September 11, 2024, 7:39pm UTC](https://community.glideapps.com/t/cannot-get-filters-to-work-anymore/76303/9 "2024-09-11T19:39:22Z")
What if you just remove the Requestor filter, but keep the Date filter? ---
**Author:** ![mustangTC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mustangtc/32/91321_2.png) [@mustangTC](https://community.glideapps.com/u/mustangTC)\ **Post date:** [September 11, 2024, 7:40pm UTC](https://community.glideapps.com/t/cannot-get-filters-to-work-anymore/76303/10 "2024-09-11T19:40:43Z")
Tried that as well. Still blank. ---
**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:** [September 11, 2024, 7:50pm UTC](https://community.glideapps.com/t/cannot-get-filters-to-work-anymore/76303/11 "2024-09-11T19:50:36Z")
OK. I don’t think you are doing anything wrong that I can see. I have a theory. Let’s try something else. Add two text components to the screen. One to show Requestor and one to show Date Begin. I wonder if the screen values are empty and the Fields component is not sufficient to populate the screen values. ---
**Author:** ![mustangTC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mustangtc/32/91321_2.png) [@mustangTC](https://community.glideapps.com/u/mustangTC)\ **Post date:** [September 11, 2024, 7:59pm UTC](https://community.glideapps.com/t/cannot-get-filters-to-work-anymore/76303/12 "2024-09-11T19:59:19Z")
Still no luck. ![Text Components](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/7/c7a7e9430c347e28ca7b9f50115820cbb840b77f.jpeg) ---
**Author:** ![mustangTC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mustangtc/32/91321_2.png) [@mustangTC](https://community.glideapps.com/u/mustangTC)\ **Post date:** [September 11, 2024, 8:34pm UTC](https://community.glideapps.com/t/cannot-get-filters-to-work-anymore/76303/13 "2024-09-11T20:34:45Z")
Not that I can explain the reasoning why it does this, but I think I found the cause of the problem. I think it has something to do with the type of screen the overlay is. It was set up to open as a form screen in the overlay so I could easily add an option for them to select a sub and submit and changing the request from pending to scheduled. However, I just copied my components, then changed the action to open a new screen instead of a form screen. Pasted my component list and now the filters work just fine… I guess I can still accomplish the selection process via an action sequence that edits the fields, so it’s not a problem that it’s not a form screen I guess. I am curious why this would mess up the filters though, any ideas? ![New Screen Working](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/1/d1db46428d85a98bf8752e89006a54d032ece9d5.jpeg) ---
**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:** [September 11, 2024, 10:44pm UTC](https://community.glideapps.com/t/cannot-get-filters-to-work-anymore/76303/14 "2024-09-11T22:44:25Z")
> [@mustangTC](#): > > It was set up to open as a form screen Oh, completely missed that it was a form in your screenshots. > [@mustangTC](#): > > so I could easily add an option for them to select a sub and submit and changing the request from pending to scheduled. In that case, since you were trying to display a list to select from, you should have used a choice component instead of a collection. Also, if you are just updating an existing row, it should be an Edit form instead of an Add form (maybe it was, but couldn’t tell for sure based on the screenshots). > [@mustangTC](#): > > changed the action to open a new screen instead of a form screen. You can go either way, but an Edit form may be better because that allows a user to easily cancel out if they choose without making changes to the row. > [@mustangTC](#): > > I guess I can still accomplish the selection process via an action sequence that edits the fields, so it’s not a problem that it’s not a form screen I guess Honestly I would go back to using an Edit form, replace the collection with a choice component, and then use an IF column to return Pending if the substitute column is empty, else return Scheduled. It’s going to be a whole lot easier to set up without extra action sequences. > [@mustangTC](#): > > I am curious why this would mess up the filters though, any ideas A form lives in a temporary state. Those filter values were probably empty because in a form they were not populated and not looking at existing row values. When you used the fields component you were pulling from an existing row, but the filter was probably assuming you were adding a new row and those values were not populated. ---
**Author:** ![mustangTC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mustangtc/32/91321_2.png) [@mustangTC](https://community.glideapps.com/u/mustangTC)\ **Post date:** [September 12, 2024, 12:41pm UTC](https://community.glideapps.com/t/cannot-get-filters-to-work-anymore/76303/15 "2024-09-12T12:41:53Z")
I’ve got it sorted out now, thanks for your help Jeff! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [September 19, 2024, 12:41pm UTC](https://community.glideapps.com/t/cannot-get-filters-to-work-anymore/76303/16 "2024-09-19T12:41:59Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.