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.
Stuck is a valid status
Need a second brain on this one?
If this lesson just collided with your real schema, script stack, or deadline, book consulting and turn the confusion into a concrete plan.
Use common Get() functions
Get() functions are context-aware — they return values based on what is happening when they are evaluated.
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
Sign in to track your progress and pick up where you left off.
Sign in to FM Dojo