I want to show the latest event date when I open a layout Event Details. I created a script to run when the layout is opened (see attached) but I am sure I have left something out, as the script does not work. Any help would be appreciated.
You can always choose Go to Record/request where you see all script steps. That script step have been there for all versions going back to FMP4 where I started
I your Layout setup, you go in under Triggers and on OnLayoutLoad you choose your script that sort records in Descending order
You might try:
Sort records by Field [Descending ; Event Details::AuctionEventDate]
Pause/Resume Script [Duration (seconds): 5 ]
Refresh Window [ ]
After sorting the records you then have to go to the first or the last record, depending on the sort order.
I looked for an option to go to first record but couldn't find anything. How do I script this.
Do like raw soft writes and just add one script step Go to record (first)
It depends on which version of Filemaker you are using. I am using V14 and the process is to type "go" and a number of options will appear. One of them is "Go to Record/Request/Page". When you click this it will appear in the script window and there will be an option to change between first, last etc. I think the default is first. The procedure is different for earlier versions of FM.
Thank you every one. Works great.
Retrieving data ...