your 'item number' isn't really a number, but an alphanumeric code containing a number.
So, sorting by it, sorts as a text.
We know that our item number is not technically a number but an alphanumeric code. We still would like these to be sorted and we do not know why we keep experiencing problems. Whenever we add sorting in the script after the perform find, it only returns a few of the records instead of all of the records, sorted by item number.
Do you meen that in your DB, between 12/22/2008 and 02/09/2009, there are more than 18 records that have the code starting with 27 ?
There are only 18 records that start with "27". However, when you do a search for "27" it is not sorting the results. When I add the sorting feature in the script, it only shows 3 records.
Thank you for your post.
In your script, after the Sort Records step, add the step:
Go to Record/Request/Page [First]
The reason for this is after you do a sort, you are still positioned at the "27 MM Soccer Balls", which is three from the bottom in the sorted order.
You are the nicest person on the planet!!! Thank you so much. I did exactly what you wrote and it is working perfectly so far. Thanks again.
We have been working with the new script and we have noticed some glitches. The script is omitting records that it should be showing. If you perform a find in the item number area for "27MIB", 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 records of 27MIB with the most recent "Date of Certificate" and omitting the others. 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. 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.
Thank you for the screen shots. This helps tremendously!
Overall, your script looks fine. Your last record would be displayed by changing the fourth line from the bottom of your script to:
Go to Record [ Next ; Exit after last ]
What is happening now is you are going to the next record, but you don't have the option checked for last record. Therefore, you are going back to the top of the loop and incrementing the variable by 1, going through another time to set it to 3, and on the fourth time, omitting the record and exiting. Does that make sense?