I think I figured it out. I created a script that sorts the records by timestamp, then goes to the last record. I then created a button that runs that script.
I'm pretty sure it's working correctly, but I'm going to have to make a set of dummy records to test this out more thoroughly.
While I was at it, I also created a second script that sorted the records by Customer Last Name again, and created a button for that.
Quite simple, actually. I wish I had thought of all this before posting the question! But that's how you learn, I suppose.
If the buttons do not work correctly, is it all right if I come back and ask for help? I'm pretty sure they're working though. Jd
but I'm going to have to make a set of dummy records to test this out more thoroughly.
You may have already thought of this, but make a copy of your file for testing purposes. Then, when you are through testing, you can discard that file and revert to the original. That way, you don't have to worry about removing any dummy records from your table while leaving the original data intact.
Here's other code you could put in a script that also reliably takes you to the most recently created record:
Show All Records
Go to Record/Request/Page [Last]
Made several copies, yes.
And thank you for your version of the script. I need to use scripting more often. It really helps automate various tasks! Thanks again. Jd