# How to filter by field?

**URL:** <https://community.glideapps.com/t/how-to-filter-by-field/20203>\
**Category:** Ask for Help\
**Created:** [December 23, 2020, 2:08am UTC](https://community.glideapps.com/t/how-to-filter-by-field/20203 "2020-12-23T02:08:15Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![gblitzer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gblitzer/32/11644_2.png) [@gblitzer](https://community.glideapps.com/u/gblitzer)\
**Post date:** [December 23, 2020, 2:08am UTC](https://community.glideapps.com/t/how-to-filter-by-field/20203/1 "2020-12-23T02:08:15Z")

</div>

Hello.  
I need to restrict view to users based on an input field.  
E.g.  
User open apps and is asked for a value.  
He/she inputs “A001” and app will return only rows with column X matching “A001”.

I hope I made myself clear!  
(BTW, users do not have email so filtering by logged in user is not an option!

Thanks  
-gerardo

---

<div class="post-metadata">

**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:** [December 23, 2020, 2:09am UTC](https://community.glideapps.com/t/how-to-filter-by-field/20203/2 "2020-12-23T02:09:42Z")

</div>

Store the value that they input in a user specific column, and then use that to filter.

---

<div class="post-metadata">

**Author:** ![gblitzer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gblitzer/32/11644_2.png) [@gblitzer](https://community.glideapps.com/u/gblitzer)\
**Post date:** [December 23, 2020, 2:14am UTC](https://community.glideapps.com/t/how-to-filter-by-field/20203/3 "2020-12-23T02:14:32Z")

</div>

Thanks. What do you mean by _user specific column_?  
If two users are accessing the app at the same time, how would I identify the correct field to filter with?

---

<div class="post-metadata">

**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:** [December 23, 2020, 2:16am UTC](https://community.glideapps.com/t/how-to-filter-by-field/20203/4 "2020-12-23T02:16:23Z")

</div>

It’s the same field in each case. User-specific means that the value in that column is unique to each user.  
Have a read here…

> **[User-specific columns](https://docs.glideapps.com/all/reference/data-editor/user-specific-columns)**

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 23, 2020, 2:46am UTC](https://community.glideapps.com/t/how-to-filter-by-field/20203/5 "2020-12-23T02:46:19Z")

</div>

Darren made the right recommendation. User-specific columns will work when multiple users are accessing at the same time, their inputs are not overlapping on each other.

So you can have a user-specific column, the input will be written to the 1st row of that column, then you can filter an inline list by that value (let’s say Column X in the list’s sheet matches the user’s input).

---

<div class="post-metadata">

**Author:** ![gblitzer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gblitzer/32/11644_2.png) [@gblitzer](https://community.glideapps.com/u/gblitzer)\
**Post date:** [December 23, 2020, 2:51am UTC](https://community.glideapps.com/t/how-to-filter-by-field/20203/6 "2020-12-23T02:51:46Z")

</div>

Thank you both.  
Still getting there… I was able to create a user specific column and I could assign a value based on user input but still confused on next steps ☹  
Should I explore inline lists to figure this out?

---

<div class="post-metadata">

**Author:** ![gblitzer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gblitzer/32/11644_2.png) [@gblitzer](https://community.glideapps.com/u/gblitzer)\
**Post date:** [December 23, 2020, 3:12am UTC](https://community.glideapps.com/t/how-to-filter-by-field/20203/7 "2020-12-23T03:12:49Z")

</div>

Made it!!  
I added an inline list, linked it to the user specific column and… voila!!

Love Glide.
