Issue with Checking Codes Across the Entire Database in Glide

[Rafael]

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?

[Darren_Murphy]

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.