# I need help making my app search through rows and find matching rows based off an ID

**URL:** <https://community.glideapps.com/t/i-need-help-making-my-app-search-through-rows-and-find-matching-rows-based-off-an-id/35207>\
**Category:** Ask for Help\
**Created:** [November 29, 2021, 12:15am UTC](https://community.glideapps.com/t/i-need-help-making-my-app-search-through-rows-and-find-matching-rows-based-off-an-id/35207 "2021-11-29T00:15:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ben\_Nicholls](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ben_nicholls/32/35043_2.png) [@Ben\_Nicholls](https://community.glideapps.com/u/Ben_Nicholls)\
**Post date:** [November 29, 2021, 12:15am UTC](https://community.glideapps.com/t/i-need-help-making-my-app-search-through-rows-and-find-matching-rows-based-off-an-id/35207/1 "2021-11-29T00:15:34Z")

</div>

Essentially I have a sheet that has a number of jobs, each one has an ID made up of some of the information regarding the job in ones and zeros, so there should be matching IDs. I need a user to be able to start writing a new job, this should make an ID. I need to know how to match the new ID with any jobs that have a matching ID and then give me an average of the Job Rate column.

Thank you for your time, I am quite new to this.

 ![AutoQuoteInfo](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/0/80773abdab5eeb0ce157b9f9077d38a062bab23a.png)

---

<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 29, 2021, 1:21am UTC](https://community.glideapps.com/t/i-need-help-making-my-app-search-through-rows-and-find-matching-rows-based-off-an-id/35207/2 "2021-11-29T01:21:58Z")

</div>

Have you looked into using relations? I would think that you could build your ID, then have a relation that links that ID to the ID in your jobs table. Then have an inline list that is sourced from that relation. Once a matching ID is created, then the relation will auto populate with related job rows.

> **[Relation Column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/relation-column)**
>
> Relate items to other items

---

<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:** [November 29, 2021, 1:53am UTC](https://community.glideapps.com/t/i-need-help-making-my-app-search-through-rows-and-find-matching-rows-based-off-an-id/35207/3 "2021-11-29T01:53:48Z")

</div>

> [@Ben\_Nicholls](#):
>
> match the new ID with any jobs that have a matching ID and then give me an average of the Job Rate column.

Once you have the relation in place that Jeff described, you can then use a [Rollup Column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/rollup) to get your average job rate.

---

<div class="post-metadata">

**Author:** ![Ben\_Nicholls](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ben_nicholls/32/35043_2.png) [@Ben\_Nicholls](https://community.glideapps.com/u/Ben_Nicholls)\
**Post date:** [November 29, 2021, 4:47am UTC](https://community.glideapps.com/t/i-need-help-making-my-app-search-through-rows-and-find-matching-rows-based-off-an-id/35207/4 "2021-11-29T04:47:53Z")

</div>

Amazing, thank you for the replies, that sounds like exactly what I want.