# Comparing a number with a list of numbers **URL:** \ **Category:** Ask for Help\ **Created:** [March 12, 2026, 6:29pm UTC](https://community.glideapps.com/t/comparing-a-number-with-a-list-of-numbers/86650 "2026-03-12T18:29:15Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![mbraunperu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mbraunperu/32/83676_2.png) [@mbraunperu](https://community.glideapps.com/u/mbraunperu)\ **Post date:** [March 12, 2026, 6:29pm UTC](https://community.glideapps.com/t/comparing-a-number-with-a-list-of-numbers/86650/1 "2026-03-12T18:29:15Z")
Hello Gliders! My app reads an invoice in PDF and records the supplier unique number. Every three months my app also reads a “black list of invoices” in pdf and also records those supplier numbers in a field in another table (these are companies my client does not want to do business with because they are in trouble with the equivalent of the IRS). Now, I have to compare the supplier unique number with the numbers of the black list. How do I do this? Can you lead me in the right way? ---
**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:** [March 12, 2026, 7:14pm UTC](https://community.glideapps.com/t/comparing-a-number-with-a-list-of-numbers/86650/2 "2026-03-12T19:14:50Z")
is the blacklist stored in a single cell? Is it comma delimited or using some sort of delimiter? ---
**Author:** ![mbraunperu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mbraunperu/32/83676_2.png) [@mbraunperu](https://community.glideapps.com/u/mbraunperu)\ **Post date:** [March 12, 2026, 7:45pm UTC](https://community.glideapps.com/t/comparing-a-number-with-a-list-of-numbers/86650/3 "2026-03-12T19:45:46Z")
Hello Jeff, please see the attachment. It is currently like this although I could use another method if you suggest. It is in pairs (the company ID number, the corresponding company name). Therefore if there is a match on the ID number, I can show the user the company name. ![RUC y RazonSocial](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/a/6ab02818e2b9d66dbeda25854c7cd8a95cfe8559.jpeg) ---
**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:** [March 12, 2026, 8:31pm UTC](https://community.glideapps.com/t/comparing-a-number-with-a-list-of-numbers/86650/4 "2026-03-12T20:31:36Z")
I think if you create add a Query JSON column, point it to your RUCs column, and set the query to ‘RUC\_numbers’, it should give you an array of RUC numbers. Then you can simply create a relation to/from that column. If you create a relation TO it, the relation should be empty if they are not in the blacklist and not empty if they are in the blacklist. If you create a relation FROM it, the relation should give you a list of those in the blacklist. ---
**Author:** ![mbraunperu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mbraunperu/32/83676_2.png) [@mbraunperu](https://community.glideapps.com/u/mbraunperu)\ **Post date:** [March 17, 2026, 4:54pm UTC](https://community.glideapps.com/t/comparing-a-number-with-a-list-of-numbers/86650/5 "2026-03-17T16:54:43Z")
The relation solved the problem. Thanks Jeff! ---
**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:** [March 24, 2026, 4:55pm UTC](https://community.glideapps.com/t/comparing-a-number-with-a-list-of-numbers/86650/6 "2026-03-24T16:55:33Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.