Common Get() functions in FileMaker calculations
BeginnerFileMaker's Get() functions return information about the current environment — date, time, user, layout, record count, and more. Learn the most useful ones and how to use them in calculations and scripts.
What you'll learn
- The most commonly used Get() functions and what they return
- Why calculations using Get() functions are always unstored
- How to use Get() in both calculations and script variables
Get() functions return real-time information about the FileMaker environment — from the current date and user account to the active layout, record count, and error state — making them essential for any dynamic calculation or script.
1/2
1
Use common Get() functions
Get() functions are context-aware — they return values based on what is happening when they are evaluated.
FileMaker Script
Get ( CurrentDate ) // today's date as a Date type Get ( CurrentTime ) // current time as a Time type Get ( CurrentTimestamp ) // current date+time as a Timestamp Get ( AccountName ) // login account name, e.g. "jdoe" Get ( UserName ) // the user's full name from preferences Get ( PrivilegeSetName ) // active privilege set name Get ( LayoutName ) // name of the currently active layout Get ( LayoutTableName ) // the table of the current layout Get ( WindowName ) // name of the active window Get ( FoundCount ) // number of records in the found set Get ( TotalRecordCount ) // total records in the table Get ( RecordNumber ) // position of the current record in the found set Get ( LastError ) // error code from the most recent step Get ( ScriptResult ) // result from the most recent sub-script Get ( ScriptParameter ) // parameter passed to the current script
List() for gathering related values in FileMakerJSONListKeys, JSONGetElementType, and iterating JSON in FileMaker
Sign in to track your progress and pick up where you left off.
Sign in to FM Dojo