FileMaker 2025 (v22) - GetRecordIDsFromFoundSet()
One of the fundamental methods for loading a found set of records in FileMaker has traditionally been storing and using the key values of a selected set of records. With the powerful Go To Related Record script step, you can easily load any number of records.
This can be achieved through either a global field relationship or a standard schema relationship. However, with the established method, if you want to store and reload a found set, you need a few additional elements: a Summary field (low overhead) and a dedicated relationship, which is always going to be required.
With the introduction of the new GetRecordIDsFromFoundSet() function in FileMaker 2025 (v22), this process becomes significantly easier.
Whether you’re recreating a simple found set or reconstructing a complex query using record ranges, this new function will help you streamline your solutions and reduce development overhead.
Comments
It's use?
So apart from restoring results from a find, I can't see much use for this new command. Am I missing something obvious?
Yes. In conjunction with the
Yes. In conjunction with the companion step you can restore the records and also preserve the sort order.