# Issue with Checking Codes Across the Entire Database in Glide

**URL:** <https://community.glideapps.com/t/issue-with-checking-codes-across-the-entire-database-in-glide/78771>\
**Category:** Ask for Help\
**Created:** [December 24, 2024, 1:19pm UTC](https://community.glideapps.com/t/issue-with-checking-codes-across-the-entire-database-in-glide/78771 "2024-12-24T13:19:40Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rafael](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rafael/32/83315_2.png) [@Rafael](https://community.glideapps.com/u/Rafael)\
**Post date:** [December 24, 2024, 1:19pm UTC](https://community.glideapps.com/t/issue-with-checking-codes-across-the-entire-database-in-glide/78771/1 "2024-12-24T13:19:40Z")

</div>

Hi everyone!

I’m building an app in Glide that allows my customers to redeem points using specific codes. In my database, I have a table with all the information about these codes, including the customer, the points value, expiration date, and usage status.

On the redemption screen, the customer enters the code in a field, and I have set up a workflow to check if the code exists in the database. However, I realized that this check is only looking at the first row of the table, not the entire database.

I need Glide to look for the code across all rows in the table and return whether the code is valid or not. Does anyone know how I can fix this?

---

<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 24, 2024, 1:28pm UTC](https://community.glideapps.com/t/issue-with-checking-codes-across-the-entire-database-in-glide/78771/2 "2024-12-24T13:28:21Z")

</div>

Create a relation between the entered code and the column that contains all valid codes. If the relation is not empty, a match is found.

Side note: this is not secure. A user could discover all codes if they were sufficiently skilled and motivated.

---

<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:** [December 31, 2024, 1:28pm UTC](https://community.glideapps.com/t/issue-with-checking-codes-across-the-entire-database-in-glide/78771/3 "2024-12-31T13:28:50Z")

</div>

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