FileMaker > Functions > Flashcards

Functions Flashcards

(60 cards)

Study These Flashcards
1
Q

Get ( Device )

A

Returns a number indicating the type of computer that is currently running FileMaker Pro or FileMaker WebDirect, or the type of iOS device that is currently running FileMaker Go

  • 0 - unknown
  • 1 - Mac
  • 2 - PC running Windows
  • 3 - iPad
  • 4 - iPhone or iPod touch
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Get ( EncryptionState )

A

Returns a value representing the file’s current encryption state

  • 0 if the database is not encrypted
  • 1 and the Shared ID as a return delimited list if the database is encrypted
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Get ( FileSize )

A

Returns the size (in bytes) of the currently active database file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Get ( LastError )

A

Returns a number representing the error, if any, in the execution of the most recently executed script step

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Get ( LastMessageChoice )

A

Returns a number corresponding to the button clicked in an alert message that is displayed by the Show Custom Dialog script step

  • 1 for the first button ( by default, labeled OK )
  • 2 for the second button ( by default, labeled Cancel )
  • 3 for the third button
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Get ( LayoutAccess )

A

Returns a number based on record access privileges available thorugh the current layout.

  • 0 if the custom layout privileges of an account’s privilege set allow no access to Records via this layout
  • 1 if the custom layout privileges of an account’s privilege set allow view only access to Records via this layout. If the database is oopened with read-only access, FM Pro returns 1 even if the layout had read-write access privileges
  • 2 if the custom layout privileges of an account’s privilege set allow modifiable access to Records via this layout.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Get ( LayoutName )

A

Returns the name of the layout currently displayed.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Get ( LayoutNumber )

A

Returns the number of the layout currently displayed, according to the list in the Manage Layouts dialog box.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Get ( LayoutViewState )

A

Returns a number indicating the currently active database file view

  • 0 if the database file is in Form View
  • 1 if the database file is in List View
  • 2 if the database file is in Table View
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Get ( MultiUserState )

A

Returns a number representing the level of sharing for the database file useing FileMaker Network

  • 0 when network sharing is off
  • 1 when network sharing is on, you’re accessing the database file from the host computer, and either all users or a specific group of users (based on their privilege set) have network access to the database file
  • 2 when network sharing is on, you’re accessing the database file from a client computer, and either all users or a specific group of users (based on their privilege set) have network access to the database file
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Get ( NetworkType )

A

In FileMaker Go, returns a number indicating the type of network being used to access the current file.

  • 0 if the current file is a local file on an iOS device
  • 1 if the network type is unkown
  • 2 for a cellular network
  • 3 for a Wi-Fi network
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Get ( RecordAccess )

A

Returns a number based on the current record’s access privileges, assigned through the Custom Record Privileges dialog box.

  • 0 if the custom record privileges of an account’s privilege set have neither View nor Edit privileges set to yes for the current record
  • 1 if the custom record privileges of an account’s privilege set have View set to yes for the current record, or if View is set to limited and the calculation defined for limited access return a value of true
  • 2 if the custom record privileges of an account’s privilege set have Edit set to yes for the current record, or if Edit is set to limited and the calculation defined for limited access returns a value of true
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Get ( ScriptAnimationState )

A

Indicates wheter or not animations are enabled for the current script.

  • 0 if animations are disabled for the current script
  • 1 if animations are enabled for the current script

Animations are off by default while a script is running

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Get ( ScriptName )

A

Returns the name of the script currently running (or paused)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Get ( ScriptParameter )

A

Returns the script parameter passed into the current script

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Get ( ScriptResult )

A

Returns the script result from a performed subscript

Use this function as part of a calculation evaluated within a script. If a subscript doesn’t return a result, then the content of the script result will be empty

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Get ( SortState )

A

Returns a value representing the current sort state.

  • 0 if the records in the active table are not sorted
  • 1 if the records in the active table are sorted
  • 2 if the records in the acitve table are partially sorted (semi-sorted)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Get ( StatusAreaState )

A

Returns a number indicating the current status toolbar state

  • 0 if the status toolbar is hidden
  • 1 if the status toolbar is visible
  • 2 if the status toolbar is visible and locked
  • 3 if the status toolbar is hidden and locked
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Get ( SystemDrive )

A

Returns the drive letter (Windows) or volume name (OS X) where the currently running operating system is located.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Get ( SystemPlatform )

A

Returns a number indicating the current platform

  • 1 if the current platform is Intel-based Macs
  • -2 if the platform is Windows
  • 3 if the platfrom is iOS
  • 4 if the platfrom is FileMaker WebDirect
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Get ( SystemVersion )

A

Returns the version of the current operating system

  • 6.1 for Windows 7
  • 6.2 for Windows 8
  • 10.7 for OS X version 10.7
  • 10.8 for OS X version 10.8
  • <os><web><browser> for FileMaker WebDirect</browser></web></os>
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Get ( TriggerCurrentPanel )

A

Returns the index and the object name of the current tab panel or slide panel (the panel to be switched from) when the OnPanelSwitch script trigger is activated.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Get ( TriggerGetureInfo )

A

In FileMaker Go, returns details about the gesture that activated an OnGestureTap trigger

Returns a list containing these items:

  • the string tap, indicating the script was started by an OnGestureTap trigger
  • a value indicating the tap count
  • a value indicating how many fingers were used to make the tap
  • the x coordinate in the document where the gesture occurred
  • the y coordinate in the document where the gesture occurred
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Get ( TriggerKeystroke )

A

Returns a string containing the characters that activated an OnObjectKeystroke or OnLayoutKeystroke script trigger.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Get ( TriggerModifierKeys ) INCOMPLETE
Returns the state of the keyboard modifier keys as they were when a script trigger was activated.
26
Get ( TriggerTargetPanel )
Returns the index and the object name of the target tab panel or slide panel (the panel to be switched to) when the **OnPanelSwitch** script trigger is activated
27
Get ( UserCount )
Returns the number of clients currently accessing the file Returns: * 1 if FileMaker network sharing is turned off * 1 + the number of clients if FileMaker network sharing is turned on This function does not count clients accessing the database file via ODBC or JDBC
28
Get ( UserName )
Returns the name of the FileMaker Pro user, as specified in the **General** tab of the Preferences \* For greater security, use Get ( AccountName ) to track and manage user access: a user cannot change the account name used to log in to a database file
29
Get ( UUID )
Returns text representing a Universally Unique Identifier (UUID) Returns a unique 16-byte (128-bit) string.
30
Get ( WindowMode )
Returns a number representing the mode FileMaker Pro is in at the time the function is evaluated * 0 - Browse mode * 1 - Find mode * 2 - Preview mode * 3 - Printing is in progress * 4 - Evaluating the function from the Data Viewer and the current window is in Layout Mode If in Layout mode when this script step is called, FM switches to Browse mode and returns 0
31
Get ( WindowOrientation )
Returns a value indicating the orientation of the window on which the script is acting (not necessarily the foreground window) * -2 for landscape left * -1 for landscape right * 0 for square (FileMaker Pro and FileMaker WD only) * 1 for portrait * 2 for portrait upside down
32
Get ( WindowStyle )
Returns the style of the window on which the script is acting * 0 if the window is a document window * 1 if the window is a floating document window * 2 if the window is a dialog window
33
Location
Returns the current latitude and longitude on an iOS device funning FileMaker Go. Also returns the horizontal accuracy of the values returned. The location is obtained via GPS, cellular network, or Wi-Fi `Location (accuracy {; timeout})` * accuracy* - numerical value represents a distance in meters * timeout* - numerical value that represents the most time it will take to fetch the location, measured in seconds. Default is 60 seconds.
34
LocationValues
Returns the current latitude, longitude, and altitude on an iOS device funning FileMaker Go. Returns the horizontal and vertical accuracy of the values returned and the number of minutes since the values were returned. The location is obtained via GPS, cellular network, or Wi-Fi `LocationValues (accuracy {; timeout})` * accuracy* - numerical value represents a distance in meters * timeout* - numerical value that represents the most time it will take to fetch the location, measured in seconds. Default is 60 seconds.
35
Average
Returns a value that is the average of all valid, non-blank vlaues in *field* `Average(field{field...})`
36
Count
Returns the number of valid, non-blank values in field `Count(field{;field...})`
37
List
Returns a concatenated list of non-blank values (separated by carriage returns) for a field or fields. `List ( field { ; field } )`
38
Max
Returns the highest valid value in field `Max ( field { ; field } )`
39
StDev
Returns the standard deviation of the sample represented by a series of non-blank values in field `StDev ( field { ; field } )`
40
Min
Returns the smallest valid non-blank value in field `Min ( field { ; field } )`
41
StDevP
Returns the standard deviation of a population represented by a series of non-blank values in field. `StDevP ( field { ; field... } )`
42
Sum
Returns the total of all valid, non-blank values in field. `Sum ( field { ; field... } )`
43
Variance
Returns the variance of a sample represented by a series of non-blank values in field. `Variance ( field { ; field... } )`
44
VarianceP
Returns the variance of a population represented by a series of non-blank values in field. `VarianceP ( field { ; field... } )`
45
Base64Decode
Returns container content from text encoded in Base64 format ## Footnote `Base64Decode ( text { ; fileNameWithExtension } )`
46
GetAsURLEncoded
Returns text as URL encodeing, for use as a URL ## Footnote GetAsURLEncoded("Hello") returns Hello GetAsURLEncoded("San Francisco") returns San%20Francisco GetAsURLEncoded("français") returns fran%c3%a7ais.
47
Base64Encode
Returns the contents of the specified container field as text in Base64 format. `Base64Encode (sourceField)`
48
Char ( number )
Returns the characters for the Unicode code points in the number `Char ( number )` \*If the number is 0, the function returns an empty string Each group of five digits in the number is treated as a Unicode code point, and the character for each five-digit group is returned in the text.
49
Code ( text )
Returns the Unicode code points for the characters in the text `Code (text)` Code(“”) returns an empty string. Code(“a”) returns **97**. Code(“b”) returns **98**. Code(“ab”) returns **9800097**. Code(“ä”) returns **228**. Code(“ä”)(an a followed by a dieresis character entered in a separate keystroke) returns **77600097**.
50
Choose ( test ; result0 { result1 ; result2 ... } )
Returns one result value, according to the integer value of test. ## Footnote FileMaker Pro evaluates test to obtain an index number, which is used to choose the corresponding ordinal result. Because Choose is a 0-based list, the first item on the list is indexed 0 and the second item on the list is indexed 1. For example, if test evaluates to 2, then result2 is chosen. Ex. Choose (Rating; "Not Applicable";"Good";"Fair";"Poor")
51
Filter ( textToFilter ; filterText )
Returns from *textToFilter* only those characters specified in *filterText*, in the order they were originally entered in *textToFilter* ! The Filter function is case-sensitive Filter ( “(408)555-1212” ; “0123456789” ) returns 4085551212.
52
FilterValues ( textToFilter ; filterValues )
Returns a text result containing only the values that were provided in *filterValues,* in the order they were originally entered in *textToFilter* ## Footnote Values are text items separated by carriage returns. A value can be empty, a single character, a word, a sentence, or a paragraph. When you press Enter or Return, you start creating a new value. **The last value will be recognized with or without a carriage return.** ! The FilterValues function is **_not_** case-sensitive. FilterValues(“Plaid¶Canvas¶Suitcase”;“Plaid¶Canvas”) returns: Plaid Canvas
53
GetContainerAttribute (sourceField ; attributeName )
Returns the file metadata of the specified container field Groups inlcude * general * audio * image * photo * barcode * signature * all
54
GetField ( fieldName )
Returns the contents of fieldName Use this function to get the contents of fieldName, or in any function that uses a field, such as NPV, GetSummary, GetRepetition, or the aggregate functions. Suppose you have the fields FirstName and LastName. FirstName contains the text string Jane, and LastName contains the text string Public. • GetField (“FirstName”) & “” & GetField (“LastName”) returns the text string Jane Public.
55
GetFieldName ( fieldName )
Returns the fully qualified name of a field reference. ## Footnote Use this function to get the fully qualified name of fieldName (tableName::fieldName). **Note** If you specify the context for the current calculation, this function will be evaluated based on that context. Otherwise, it will be evaluated based on the context of the current window.
56
GetValue ( listOfValues ; valueNumber )
Returns the requested value given by *valueNumber* from *listOfValues* GetValue(“London¶Paris¶Hong Kong”;2) returns: Paris
57
IsValid ( field )
Returns 0 (False) if the data is invalid and 1 (True) if the data is valid Returns 0 (False) if: * A record contains an invalid value because of a field type mismatch (text in a date field) * FileMaker Pro cannot locate (temporarily or permanently) the related table in which the referenced field is defined * A field has been deleted from a related table, and therefore the references to that field in the source table are invalid Otherwise, it returns 1 (the data is valid).
58
Left ( text ; numberOfCharacters )
Returns *numberOfCharacters* in *text,* counting from the left Left(“Manufacturing”;4) returns Manu. Left( Name ; Position ( Name ; “ “ ; 1 ; 1) ) returns Sophie, when the Name field contains SophieTang.
59
Position ( text ; searchString ; start ; occurence )
Returns the starting position of the specified occurrence of *searchString* in *text* This function is not case-sensitive. If *searchString* isn’t contained in text or if there was no specified occurrence, zero is returned. Position ( “Mississippi” ; “iss” ; 1 ; 1 ) returns 2. Position ( “Mississippi” ; “iss” ; 1 ; 2 ) returns 5. Position ( “Mississippi” ; “iss” ; 3 ; 1 ) returns 5. Left ( Name ; Position ( Name ; “ “ ; 1 ; 1 ) - 1 ) returns **William**, when Name is a text field that contains **William Smith**.
60
Get ( ConnectionState )
Returns a number representing the security state of the network connection for the current file * 0 - no network connection for the current file (local) * 1 - non-secured connection (FileMaker Server with SSL disabled, or to a FileMaker Pro host) * 2 - secured connection (SSL) when the server name doesn't match the certificate (default FileMaker Server installation) * 3 - a secured connection with a fully verified server name in the certificate
FileMaker
flashcards
Decks in class (5)
# Cards
Brainscape helps you reach your goals faster, through stronger study habits.
© 2026 Bold Learning Solutions. Terms and Conditions