HELP! Problem with a find script
We have been working with a new script and we have noticed some glitches. The script is omitting records that it should be showing.
First, go to the following URL
Then, click on the area where it says "click here to search Certificates of Conformity"
Next, enter "27" in the item number field and click on "FIND"
You should see the following:
As you can see, the script does successfully filter out the records it should. There are five records with "27MIB" as the item number and it is only showing the three records of 27MIB with the most recent "Date of Certificate" and omitting the other two. However, the script is also omitting another record for no reason. It is omitting a record with "27SPB" as the item number.
Below is the list from FileMaker that shows all of the records that appear when doing a find for "27" in the item number field:
Finally, below is the script we are using:
Any ideas as to why this script is randomly omitting records? If I remove the part of the script that starts with "Set Variable..." to the end, it shows every single record, but it does not omit the ones we are trying to omit. Also, if you do a find on the website for "CTN" in the item number field, you should see a record with "CTN11B" as the item number, but it shows no records at all. Any thoughts as to why it is omitting some item numbers randomly? Thank you.