# Filter a list of active/inactive items

**URL:** <https://community.glideapps.com/t/filter-a-list-of-active-inactive-items/42731>\
**Category:** Ask for Help\
**Created:** [June 4, 2022, 11:52pm UTC](https://community.glideapps.com/t/filter-a-list-of-active-inactive-items/42731 "2022-06-04T23:52:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jburnsjr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jburnsjr/32/2659_2.png) [@Jburnsjr](https://community.glideapps.com/u/Jburnsjr)\
**Post date:** [June 4, 2022, 11:52pm UTC](https://community.glideapps.com/t/filter-a-list-of-active-inactive-items/42731/1 "2022-06-04T23:52:00Z")

</div>

Gliders,

I need your how to advise.

I am building a local restaurant directory App, if a restaurant goes out of business or shuts down for some reason, I would like to remove them from the list of active restaurants but not delete their data.

If the restaurant re-opens at some later time I would like to re-activate the entry, I am trying to use a (True / False) check box column to filter and/or Show-Hide the related data for the restaurant to keep the restaurant from showing up in the directory. If I ever want to show the restaurant again, I can uncheck the check box.

This discussion is what got me to thinking it could be done:

> [@Hide vs. delete section](https://community.glideapps.com/t/hide-vs-delete-section/2543):
>
> Hey Gilders - had an idea for a feature request that would be super awesome. I don’t even know if this is possible in sheets, but if you could hide user data/make inactive vs. delete it that would be super helpful. I’m building a marketplace platform similar to Airbnb but for gyms & I have 2 applications referencing 1 spreadsheet. the ‘gym portal’ application is where the gyms can edit data etc. but we’re trying to make it as easy as possible for them to come on & off our platform. If there was …

Nevertheless, I am unable to figure out how to do it…

Thanks in advance for your help.

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [June 5, 2022, 12:03am UTC](https://community.glideapps.com/t/filter-a-list-of-active-inactive-items/42731/2 "2022-06-05T00:03:59Z")

</div>

In the data editor, in your restaurants table, have a column that will indicate if your restaurant is active or inactive. You could have a text column and indicate active / inactive, a number column and indicate 1 / 0, a boolean column and indicate true / false, etc. As long as you data in non ambiguous.

In the display section (the builder), create a screen with your list (either a list layout or a details layout with an inline list). In the options of this list, filter this list based on the column above: display items where the “active/inactive” column is “active”.

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [June 5, 2022, 12:08am UTC](https://community.glideapps.com/t/filter-a-list-of-active-inactive-items/42731/3 "2022-06-05T00:08:57Z")

</div>

[Filter your lists based on criteria](https://docs.glideapps.com/all/topics/ux/filter)

---

<div class="post-metadata">

**Author:** ![Jburnsjr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jburnsjr/32/2659_2.png) [@Jburnsjr](https://community.glideapps.com/u/Jburnsjr)\
**Post date:** [June 5, 2022, 3:09am UTC](https://community.glideapps.com/t/filter-a-list-of-active-inactive-items/42731/4 "2022-06-05T03:09:21Z")

</div>

Nathan,

Thanks for your fast response…As you suggested I added a filter to my Inline list based on my Show-Hide (True / False) check box column…If the box is checked the entry does not show. It works just the way I wanted.

Thanks again for your help…  
Semper Fi,  
James

---

<div class="post-metadata">

**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:** [June 6, 2022, 3:09am UTC](https://community.glideapps.com/t/filter-a-list-of-active-inactive-items/42731/5 "2022-06-06T03:09:23Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
