# User Generated Filters (admin approved) - try again

**URL:** <https://community.glideapps.com/t/user-generated-filters-admin-approved-try-again/1770>\
**Category:** Ask for Help\
**Created:** [November 7, 2019, 2:12pm UTC](https://community.glideapps.com/t/user-generated-filters-admin-approved-try-again/1770 "2019-11-07T14:12:57Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![spencersRus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencersrus/32/69_2.png) [@spencersRus](https://community.glideapps.com/u/spencersRus)\
**Post date:** [November 7, 2019, 2:12pm UTC](https://community.glideapps.com/t/user-generated-filters-admin-approved-try-again/1770/1 "2019-11-07T14:12:57Z")

</div>

This is something I have been working on. It may or may not be of interest to anyone, but it sure helped me.

In an app I am working on, I have a need to “run a report” with a filter on a screen. But I wanted the USER to choose the filter. It is kinda like running a “search” on a page, but the input is specific.

I have made a “fun app” to show you what I have done. (This is not my app, just a fun one to show the concept.)

[https://oswud.glideapp.io](https://oswud.glideapp.io)

The front page is a list of numbers, with a fun description. There is a button at the top to add your own.

The other page is a report page. The user has the ability to change the report through a choice menu at the top…

That change will be entered into cell A2 and a report will be generated in columns B-D and reflected on the app. I only display columns B-D. (it takes a couple of seconds for the report to run)

Go ahead, add some numbers. Run a report.

---

<div class="post-metadata">

**Author:** ![Sab\_Sabrina](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sab_sabrina/32/1300_2.png) [@Sab\_Sabrina](https://community.glideapps.com/u/Sab_Sabrina)\
**Post date:** [November 26, 2019, 4:48am UTC](https://community.glideapps.com/t/user-generated-filters-admin-approved-try-again/1770/2 "2019-11-26T04:48:43Z")

</div>

Interesting!  
Thanks @spencersRus 🙂

---

<div class="post-metadata">

**Author:** ![Sandro\_Brito](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandro_brito/32/552_2.png) [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)\
**Post date:** [November 26, 2019, 8:23am UTC](https://community.glideapps.com/t/user-generated-filters-admin-approved-try-again/1770/3 "2019-11-26T08:23:27Z")

</div>

How did you preset it to one of the options?

---

<div class="post-metadata">

**Author:** ![JWazar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jwazar/32/1178_2.png) [@JWazar](https://community.glideapps.com/u/JWazar)\
**Post date:** [November 26, 2019, 10:44pm UTC](https://community.glideapps.com/t/user-generated-filters-admin-approved-try-again/1770/4 "2019-11-26T22:44:23Z")

</div>

Cool. I guess the only limitation there is that you wouldn’t be able to have this function on a “per user” level, right? So, what if I wanted it so that each user could select from the drop down menu to set the display they would like to see BUT not have that selection trigger users on other instances display to change as well?

… Still, thanks for putting that together. Very useful ability for special ADMIN type users.

---

<div class="post-metadata">

**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:** [November 26, 2019, 11:23pm UTC](https://community.glideapps.com/t/user-generated-filters-admin-approved-try-again/1770/5 "2019-11-26T23:23:42Z")

</div>

You can do it if you have a record for each user and your are viewing the details for that user’s record. Then they are only controlling their own data. The Dynamic List Filter does this in [https://concepts.glideapp.io/](https://concepts.glideapp.io/) .

---

<div class="post-metadata">

**Author:** ![spencersRus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencersrus/32/69_2.png) [@spencersRus](https://community.glideapps.com/u/spencersRus)\
**Post date:** [November 27, 2019, 1:01pm UTC](https://community.glideapps.com/t/user-generated-filters-admin-approved-try-again/1770/6 "2019-11-27T13:01:41Z")

</div>

You can copy the spreadsheet.

I have a “List” tab with just the options - Odd or Even  
The Choice component comes from here and goes to the …

I have a “Report Page” tab that the user choice goes into.

---

<div class="post-metadata">

**Author:** ![JWazar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jwazar/32/1178_2.png) [@JWazar](https://community.glideapps.com/u/JWazar)\
**Post date:** [November 27, 2019, 3:49pm UTC](https://community.glideapps.com/t/user-generated-filters-admin-approved-try-again/1770/7 "2019-11-27T15:49:47Z")

</div>

OMG @Jeff\_Hagger

I am so glad I came back to this thread this morning! [https://concepts.glideapp.io/](https://concepts.glideapp.io/) is an amazing piece of work and most useful. I will be spending the rest of the day studying these examples. This will accelerate my work considerably over the next few days.

Thank you for providing this asset to the community.

---

<div class="post-metadata">

**Author:** ![Secura\_4x4](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/secura_4x4/32/1513_2.png) [@Secura\_4x4](https://community.glideapps.com/u/Secura_4x4)\
**Post date:** [November 27, 2019, 5:58pm UTC](https://community.glideapps.com/t/user-generated-filters-admin-approved-try-again/1770/8 "2019-11-27T17:58:18Z")

</div>

Gold medal for this app!
