# How to filter data per user

**URL:** <https://community.glideapps.com/t/how-to-filter-data-per-user/1069>\
**Category:** Ask for Help\
**Created:** [October 10, 2019, 2:05pm UTC](https://community.glideapps.com/t/how-to-filter-data-per-user/1069 "2019-10-10T14:05:21Z")\
**Posts on this page:** 1\
**Showing post:** 7

<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:** [October 10, 2019, 6:14pm UTC](https://community.glideapps.com/t/how-to-filter-data-per-user/1069/7 "2019-10-10T18:14:05Z")

</div>

To answer your first question, I can’t think of a great way to filter a Choice component on a per user level. There is some discussion in this other thread that would possibly make it possible, but it is not a user friendly process and there would be a lot of overhead and gotchya’s that I haven’t thought of. I may experiment with this in the next week or so.

> [@Can I search the menu opened by the Choice component?](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/28):
>
> I don’t think you can add scripts into an app itself. I don’t think setting a formula from within the app would work either, as google may only see it as text instead of a formula. The only option I can think of while in Add/Edit mode would be to use a Form Button to submit your search term to a new sheet. Then use a formula to pull the last submitted search term into the cell that you are using to filter your choice list. I would think this would update the Choice component while your are …

To answer your second question, I’m having trouble visualizing what exactly your asking, but if you are in a detail view and you use the Form Button to add a record to a sheet, you can include the column values from that detail view in the form submission.

---

_[View the full topic](https://community.glideapps.com/t/how-to-filter-data-per-user/1069)._
