FMP Version: FileMaker 7 and higher
Returns A Number Result
This will return the record number of the current record in the current found set. This number can change dynamically via sorts, deleting records or adding records.
This function is often used in databases that hide the status area in FileMaker. Hiding the status area adds valuable layout space that can be used for fields, buttons and other objects. However, you loose the flip book that FileMaker uses to tell you what record you are on. Using the Get(RecordNumber ) and some other functions, you can effectively design your own customized flip book for your users.
As a side note, this is one of the functions that usually will introduce users to the concept of unstored settings for calculations using the Get function.
More info about the author and FileMaker in general, contact me at email@example.com.
© 2008 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.