# Searching a database

**URL:** <https://community.glideapps.com/t/searching-a-database/69752>\
**Category:** Ask for Help\
**Created:** [January 19, 2024, 1:09pm UTC](https://community.glideapps.com/t/searching-a-database/69752 "2024-01-19T13:09:35Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Malek\_Dehbaj](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/malek_dehbaj/32/69549_2.png) [@Malek\_Dehbaj](https://community.glideapps.com/u/Malek_Dehbaj)\
**Post date:** [January 19, 2024, 1:09pm UTC](https://community.glideapps.com/t/searching-a-database/69752/1 "2024-01-19T13:09:35Z")

</div>

Hello,  
so I have a table of about 1500 rows and 8 columns. Each row has info of a person including ID number other info. I want the person in the app to input his ID number and get the rest of the info. Is it possible with a FREE plan and No-Sign In? if yes how can I do it.

Thanks

---

<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:** [January 19, 2024, 5:45pm UTC](https://community.glideapps.com/t/searching-a-database/69752/2 "2024-01-19T17:45:04Z")

</div>

If you set up an entry component that points to a user specific column, you can allow the user to enter an ID, then in the data table, add a relation that links the user specific user entry to the table that contains the user ID’s. Then you can create a collection on your screen that is sourced from the relation.

---

<div class="post-metadata">

**Author:** ![Malek\_Dehbaj](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/malek_dehbaj/32/69549_2.png) [@Malek\_Dehbaj](https://community.glideapps.com/u/Malek_Dehbaj)\
**Post date:** [January 20, 2024, 4:37am UTC](https://community.glideapps.com/t/searching-a-database/69752/3 "2024-01-20T04:37:23Z")

</div>

It worked, thanks. However, all the ID entries go to the same cell in the column that I allocated for users entry and that creates some kind of an overlapping. Meaning; when Person#1 enter his ID, he does get his information but if at the same time Person#2 opens the app and he enters his own ID, the information that Person#1 is looking at actually change to the information based on the entry of Person#2 . How could this be fixed?  
I hope that I explained the issue in a clear way!

---

<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:** [January 20, 2024, 5:05am UTC](https://community.glideapps.com/t/searching-a-database/69752/4 "2024-01-20T05:05:17Z")

</div>

> [@Jeff\_Hager](#):
>
> points to a user specific column,

This part in my instructions is the most important.

> **[User-specific columns | Glide Docs](https://www.glideapps.com/docs/essentials/security-and-user-data/user-specific-columns)**
>
> Allow cells to hold unique data for each user.

---

<div class="post-metadata">

**Author:** ![Malek\_Dehbaj](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/malek_dehbaj/32/69549_2.png) [@Malek\_Dehbaj](https://community.glideapps.com/u/Malek_Dehbaj)\
**Post date:** [January 20, 2024, 5:34am UTC](https://community.glideapps.com/t/searching-a-database/69752/5 "2024-01-20T05:34:22Z")

</div>

Okay, I got it. Thanks, Jeff. I appreciate your help.

---

<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:** [January 27, 2024, 5:35am UTC](https://community.glideapps.com/t/searching-a-database/69752/6 "2024-01-27T05:35:06Z")

</div>

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