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?
is the blacklist stored in a single cell? Is it comma delimited or using some sort of delimiter?
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.
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.
1 Like