# Filter/select on the entire application

**URL:** <https://community.glideapps.com/t/filter-select-on-the-entire-application/76862>\
**Category:** Ask for Help\
**Created:** [October 6, 2024, 7:28am UTC](https://community.glideapps.com/t/filter-select-on-the-entire-application/76862 "2024-10-06T07:28:20Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![NixonIam](https://avatars.discourse-cdn.com/v4/letter/n/22d042/32.png) [@NixonIam](https://community.glideapps.com/u/NixonIam)\
**Post date:** [October 6, 2024, 7:28am UTC](https://community.glideapps.com/t/filter-select-on-the-entire-application/76862/1 "2024-10-06T07:28:21Z")

</div>

Hello all,

Can anybody help me with this - I want a Filter/Select option for entire application ( if I select a country I want that on all my app pages/screens to see information only from that country ).

I know about “In-app Filter” but I can use it on each individual page/screen.

Thanks.

NixonIam

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [October 6, 2024, 8:25am UTC](https://community.glideapps.com/t/filter-select-on-the-entire-application/76862/2 "2024-10-06T08:25:23Z")

</div>

If you use a user table (usc column) to store the selection, you can filter based on that column across all your sheets/components.

---

<div class="post-metadata">

**Author:** ![NixonIam](https://avatars.discourse-cdn.com/v4/letter/n/22d042/32.png) [@NixonIam](https://community.glideapps.com/u/NixonIam)\
**Post date:** [October 6, 2024, 8:42am UTC](https://community.glideapps.com/t/filter-select-on-the-entire-application/76862/3 "2024-10-06T08:42:50Z")

</div>

Can you elaborate please.

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [October 6, 2024, 8:52am UTC](https://community.glideapps.com/t/filter-select-on-the-entire-application/76862/4 "2024-10-06T08:52:48Z")

</div>

1. Create a user-specific column in the user table as a placeholder to store the user’s selection.
2. Add a choice component, allowing the user to make a selection and write it to that column.
3. Filter all relevant components/pages using a condition such as “country is user profile \> country.”

---

<div class="post-metadata">

**Author:** ![NixonIam](https://avatars.discourse-cdn.com/v4/letter/n/22d042/32.png) [@NixonIam](https://community.glideapps.com/u/NixonIam)\
**Post date:** [October 6, 2024, 8:57am UTC](https://community.glideapps.com/t/filter-select-on-the-entire-application/76862/5 "2024-10-06T08:57:55Z")

</div>

Your solution is ok, but for me the country is not linked to the user but to the event (events must be filtered according to the country and you don’t have to be logged into the application to see the events).

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [October 6, 2024, 9:05am UTC](https://community.glideapps.com/t/filter-select-on-the-entire-application/76862/6 "2024-10-06T09:05:09Z")

</div>

Have you done what I mentioned above. See if it works?

---

<div class="post-metadata">

**Author:** ![NixonIam](https://avatars.discourse-cdn.com/v4/letter/n/22d042/32.png) [@NixonIam](https://community.glideapps.com/u/NixonIam)\
**Post date:** [October 6, 2024, 9:22am UTC](https://community.glideapps.com/t/filter-select-on-the-entire-application/76862/7 "2024-10-06T09:22:20Z")

</div>

I’m more of a picture examples type, not the type that uses details and/or text information. 😁

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [October 6, 2024, 9:24am UTC](https://community.glideapps.com/t/filter-select-on-the-entire-application/76862/8 "2024-10-06T09:24:20Z")

</div>

Sorry, you may need to create a helper table. This one by @Eric_Penn is more clear.

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [October 6, 2024, 10:10am UTC](https://community.glideapps.com/t/filter-select-on-the-entire-application/76862/9 "2024-10-06T10:10:36Z")

</div>

Here’s how to do it:

1. Create a new table called the helper table (a single-row table). Add a usc column to hold input from your choice component.
2. In all the tables you want to filter, add a single value column to pull the selected value from the helper table.
3. On the layout side, apply filters to all components based on the value from the single value column.

---

<div class="post-metadata">

**Author:** ![NixonIam](https://avatars.discourse-cdn.com/v4/letter/n/22d042/32.png) [@NixonIam](https://community.glideapps.com/u/NixonIam)\
**Post date:** [October 6, 2024, 10:14am UTC](https://community.glideapps.com/t/filter-select-on-the-entire-application/76862/10 "2024-10-06T10:14:32Z")

</div>

thanks again. i will try.

---

<div class="post-metadata">

**Author:** ![NixonIam](https://avatars.discourse-cdn.com/v4/letter/n/22d042/32.png) [@NixonIam](https://community.glideapps.com/u/NixonIam)\
**Post date:** [October 6, 2024, 2:51pm UTC](https://community.glideapps.com/t/filter-select-on-the-entire-application/76862/11 "2024-10-06T14:51:00Z")

</div>

Are you talking about something like this [How to create multi-filters on GlideApps (AND filters).pdf - Google Drive](https://drive.google.com/file/d/1-yb9T-AjgaWhlNQ1iNtY1rJ8l5VAn0lL/view) ?

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [October 6, 2024, 4:52pm UTC](https://community.glideapps.com/t/filter-select-on-the-entire-application/76862/12 "2024-10-06T16:52:29Z")

</div>

> [@NixonIam](#):
>
> I want a Filter/Select option for entire application ( if I select a country I want that on all my app pages/screens to see information only from that country ).

As you mentioned, your case is not a multi-filter scenario and doesn’t require such a complex process. In the example, you simply apply filtering based on the selected country name, so that all components in pages are filtered according to the corresponding data from the single value pulled from the helper table.

The key is that all tables you want to filter should have a country name column, and the single value will be used as the basis for filtering in your collection components.

---

<div class="post-metadata">

**Author:** ![Sekayi\_Liburd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sekayi_liburd/32/77608_2.png) [@Sekayi\_Liburd](https://community.glideapps.com/u/Sekayi_Liburd)\
**Post date:** [October 6, 2024, 5:18pm UTC](https://community.glideapps.com/t/filter-select-on-the-entire-application/76862/13 "2024-10-06T17:18:42Z")

</div>

For more instructions on how to implement what @Himaladin suggested, you can check out this response from @Darren_Murphy :

> [@Searching everything from the home screen: tabs, collections or rows of data](https://community.glideapps.com/t/searching-everything-from-the-home-screen-tabs-collections-or-rows-of-data/72783/4):
>
> You could create you own custom search to do this. Something like this: Create a User Specific column to hold the search text. This should be in the table that your Home Screen is attached to. (Normally I’d say put that column in your User Profiles table, but I think your App doesn’t require sign in, yes?) In each of the tables that you want to search, add the following columns: – A single value column, that fetches the search term from the Home Screen table – Now, lets assume you have a Na…

You will need to create columns for fetching the filter value in each of your tables and apply visibility conditions to all of your screens.
