About Get Functions
Get functions are a special group of formulas that capture what's going on while you're working. They can peek at FileMaker's current settings and preferences, such as what mode it's in, what file is currently open, or what layout is active. Get functions can also extract information about your computer, like what version of the OS you're running, or what the computer is using as the current date.Being able to mine this type of data may initially seem pointlessor too advanced. Not so. For example, imagine that you wanted to write a script that would set different preferences or allow different levels of access to data depending on who is using the computer. Or you wanted to insert the current date into an invoice or statement layout. Only a Get function can obtain this information from the computer and make it available to the script.
To see the available Get functions
1 .Choose File > Define > Database (Control+Shift+D/Command+Shift+D). When the Define Database dialog appears, click the Fields tab.2 .Type a field name and choose Calculation in the Type drop-down menu. Click Create. Since this is just a test, you can use any field name.3 .When the Specify Calculation box dialog box appears, click the View drop-down menu, scroll down, and select "Get functions." The list of specific Get functions will take the place of all the generic functions.