# Looking for help filtering checklist **URL:** \ **Category:** Ask for Help\ **Created:** [January 4, 2025, 2:48am UTC](https://community.glideapps.com/t/looking-for-help-filtering-checklist/78951 "2025-01-04T02:48:38Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![jvwald](https://avatars.discourse-cdn.com/v4/letter/j/67e7ee/32.png) [@jvwald](https://community.glideapps.com/u/jvwald)\ **Post date:** [January 4, 2025, 2:48am UTC](https://community.glideapps.com/t/looking-for-help-filtering-checklist/78951/1 "2025-01-04T02:48:38Z")
Hi all. Literally my first day using Glide and I’m having trouble building a checklist app that lets me filter the items that show up on my checklist. My use case is I’d like to create a simple packing checklist. I have a list of things that I pack on every trip and then I have a few other things that I need to bring on work trips. So I’d like a switch that I can turn on for work trips that will show those extra items. I’ve been poking around on YouTube and in the community now for a couple hours and I can’t seem to figure it out. If possible, I’d also like to include a button at the bottom that will reset the checklist so anything I’ve checked off will un-check and I’m ready for my next trip. And incidentally, I noticed in the layout builder that all the buttons and navigation seem to work but the checklist dots don’t seem to work. Like, I click on it expecting the dot to get filled in and nothing happens. Is that how it’s supposed to be? Thanks so much for any help you can give me. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 4, 2025, 4:40am UTC](https://community.glideapps.com/t/looking-for-help-filtering-checklist/78951/2 "2025-01-04T04:40:21Z")
> [@jvwald](#): > > My use case is I’d like to create a simple packing checklist. I have a list of things that I pack on every trip and then I have a few other things that I need to bring on work trips. So I’d like a switch that I can turn on for work trips that will show those extra items. Do you have a column in your table that identifies those items? If you don’t, you should add one, and then use that as a filter. If you show me how your list looks in the Glide Data Editor, I can possibly give some more specific guidance. > [@jvwald](#): > > If possible, I’d also like to include a button at the bottom that will reset the checklist so anything I’ve checked off will un-check and I’m ready for my next trip. This is a little tricky. Can I assume you are working with a Free Plan, and as such don’t have access to the API? If that’s correct, then your best option is to use the “ParentID reset” trick as described [here](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211). ---
**Author:** ![jvwald](https://avatars.discourse-cdn.com/v4/letter/j/67e7ee/32.png) [@jvwald](https://community.glideapps.com/u/jvwald)\ **Post date:** [January 5, 2025, 1:41am UTC](https://community.glideapps.com/t/looking-for-help-filtering-checklist/78951/3 "2025-01-05T01:41:50Z")
Thanks Darren! I have added a column that identifies those items. I’ll include a screenshot below, in case that’s helpful. If I’ve set up the data correctly, I could really use some help with the logic to make the “Houston” switch filter things on my packing list. ![Screenshot 2025-01-04 at 6.39.04 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/f/7f7c4093c8d34d1bc802a2853a15f344dc19c357.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 5, 2025, 7:28am UTC](https://community.glideapps.com/t/looking-for-help-filtering-checklist/78951/4 "2025-01-05T07:28:55Z")
> [@jvwald](#): > > I could really use some help with the logic to make the “Houston” switch filter things on my packing list. That’s simply a matter of applying a collection filter. > **[Conditions, Filtering, and Visibility | Glide Docs](https://www.glideapps.com/docs/use-cases/conditions-filtering-and-visibility)** > > Limit the content displayed in your apps. ---
**Author:** ![jvwald](https://avatars.discourse-cdn.com/v4/letter/j/67e7ee/32.png) [@jvwald](https://community.glideapps.com/u/jvwald)\ **Post date:** [January 6, 2025, 2:47am UTC](https://community.glideapps.com/t/looking-for-help-filtering-checklist/78951/5 "2025-01-06T02:47:14Z")
Okay, thanks Darren. I think I understand collection filters. The problem I’m having is I’d like to use a switch component above my checklist that essentially turns the filter on and off. So when the switch is on, a subset of the list is displayed (the items where “Houston” is true), and when the switch is set to off, the whole list is displayed. Can you explain how to do that? I really appreciate your help and my apologize for not knowing this program better. 🙂 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 6, 2025, 2:56am UTC](https://community.glideapps.com/t/looking-for-help-filtering-checklist/78951/6 "2025-01-06T02:56:14Z")
Okay, so what you could do is add one more boolean column to your table, but make it User Specific. Your switch component will write to this column. As the switch will only set the value in the first row, you need to apply that to all rows. For this, a Single Value column can be used. Then you need an if-then-else column to compare the values in each row. The if-then-else should be configured like so: - If Single Value boolean is empty, then `true` - If Houston is checked, then `true` Finally, you use the if-then-else column as a filter on your collection, only showing those rows where it is checked. ---
**Author:** ![jvwald](https://avatars.discourse-cdn.com/v4/letter/j/67e7ee/32.png) [@jvwald](https://community.glideapps.com/u/jvwald)\ **Post date:** [January 7, 2025, 3:30am UTC](https://community.glideapps.com/t/looking-for-help-filtering-checklist/78951/7 "2025-01-07T03:30:46Z")
Okay! Great success! I got the list to filter based on the switch. Thanks for that explanation. I didn’t realize that the switch sets the value for the first row. Moving on to the “ParentID reset” trick, I tried to copy everything you created but I couldn’t get it to work. One clarifying question: I noticed that you used a “list” style collection. Is there any reason you didn’t use a “checklist” style? I’m wondering if that might be the issue. Thank you Darren!!! You’re a lifesaver! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 7, 2025, 3:49am UTC](https://community.glideapps.com/t/looking-for-help-filtering-checklist/78951/8 "2025-01-07T03:49:40Z")
> [@jvwald](#): > > I didn’t realize that the switch sets the value for the first row. Strictly speaking it sets the value in the row that the screen is attached to. But it could set a value in a different row, depending on how things are set up. But the important point is that it only ever sets a value in a single row. > [@jvwald](#): > > I noticed that you used a “list” style collection. Is there any reason you didn’t use a “checklist” style? I’m wondering if that might be the issue. Yeah, I don’t believe that will work with a checklist. The check box expects to be able to write to a non-computed column, so you can’t use the if-then-else column as the source of that. ---
**Author:** ![jvwald](https://avatars.discourse-cdn.com/v4/letter/j/67e7ee/32.png) [@jvwald](https://community.glideapps.com/u/jvwald)\ **Post date:** [January 7, 2025, 6:35pm UTC](https://community.glideapps.com/t/looking-for-help-filtering-checklist/78951/9 "2025-01-07T18:35:48Z")
Okay Darren. I’m almost there. 🙂 I’ve got the reset button working and the filtering working. The only thing I’m missing now is the user can no longer edit or add things to the checklist. These options were under “Actions” but they’re no longer available when I enabled advanced actions. Is it still possible to let users add, edit, and delete items? Thank you!!! ---
**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 7, 2025, 6:40pm UTC](https://community.glideapps.com/t/looking-for-help-filtering-checklist/78951/10 "2025-01-07T18:40:24Z")
The Add and Edit actions should still be there. You may need to add them if they aren’t there. Advanced Actions just open it up to more advanced customization. Can you show what the action tab looks like for your collection? ---
**Author:** ![jvwald](https://avatars.discourse-cdn.com/v4/letter/j/67e7ee/32.png) [@jvwald](https://community.glideapps.com/u/jvwald)\ **Post date:** [January 15, 2025, 4:45pm UTC](https://community.glideapps.com/t/looking-for-help-filtering-checklist/78951/11 "2025-01-15T16:45:00Z")
Thanks @Jeff_Hager. Sorry that I missed your response initially. I’ve attached a screen shot of what I’m seeing. I’m not seeing the Add and Edit actions but they do appear if I click “Switch back to default actions” but that breaks some other stuff. ![Screenshot 2025-01-15 at 9.40.46 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/4/847fbc8496f72c51c0018b737e9e8f65a2075e13.png) ---
**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 15, 2025, 5:24pm UTC](https://community.glideapps.com/t/looking-for-help-filtering-checklist/78951/12 "2025-01-15T17:24:48Z")
You can add the actions you are missing. For the title bar action, add a Show Form action. For the collection item actions, add an Edit Form action. ---
**Author:** ![jvwald](https://avatars.discourse-cdn.com/v4/letter/j/67e7ee/32.png) [@jvwald](https://community.glideapps.com/u/jvwald)\ **Post date:** [January 16, 2025, 8:54pm UTC](https://community.glideapps.com/t/looking-for-help-filtering-checklist/78951/13 "2025-01-16T20:54:39Z")
Thanks @Jeff_Hager! Great success. 🙂