Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

FileMaker > Functions > Flashcards

Functions 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
Q

Get ( TriggerModifierKeys )

INCOMPLETE

A

Returns the state of the keyboard modifier keys as they were when a script trigger was activated.

26
Q

Get ( TriggerTargetPanel )

A

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
Q

Get ( UserCount )

A

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
Q

Get ( UserName )

A

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
Q

Get ( UUID )

A

Returns text representing a Universally Unique Identifier (UUID)

Returns a unique 16-byte (128-bit) string.

30
Q

Get ( WindowMode )

A

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
Q

Get ( WindowOrientation )

A

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
Q

Get ( WindowStyle )

A

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
Q

Location

A

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
Q

LocationValues

A

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
Q

Average

A

Returns a value that is the average of all valid, non-blank vlaues in field

Average(field{field...})

36
Q

Count

A

Returns the number of valid, non-blank values in field

Count(field{;field...})

37
Q

List

A

Returns a concatenated list of non-blank values (separated by carriage returns) for a field or fields.

List ( field { ; field } )

38
Q

Max

A

Returns the highest valid value in field

Max ( field { ; field } )

39
Q

StDev

A

Returns the standard deviation of the sample represented by a series of non-blank values in field

StDev ( field { ; field } )

40
Q

Min

A

Returns the smallest valid non-blank value in field

Min ( field { ; field } )

41
Q

StDevP

A

Returns the standard deviation of a population represented by a series of non-blank values in field.

StDevP ( field { ; field... } )

42
Q

Sum

A

Returns the total of all valid, non-blank values in field.

Sum ( field { ; field... } )

43
Q

Variance

A

Returns the variance of a sample represented by a series of non-blank values in field.

Variance ( field { ; field... } )

44
Q

VarianceP

A

Returns the variance of a population represented by a series of non-blank values in field.

VarianceP ( field { ; field... } )

45
Q

Base64Decode

A

Returns container content from text encoded in Base64 format

Base64Decode ( text { ; fileNameWithExtension } )

46
Q

GetAsURLEncoded

A

Returns text as URL encodeing, for use as a URL

GetAsURLEncoded(“Hello”) returns Hello

GetAsURLEncoded(“San Francisco”) returns San%20Francisco

GetAsURLEncoded(“français”) returns fran%c3%a7ais.

47
Q

Base64Encode

A

Returns the contents of the specified container field as text in Base64 format.

Base64Encode (sourceField)

48
Q

Char ( number )

A

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
Q

Code ( text )

A

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
Q

Choose ( test ; result0 { result1 ; result2 … } )

A

Returns one result value, according to the integer value of test.

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
Q

Filter ( textToFilter ; filterText )

A

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
Q

FilterValues ( textToFilter ; filterValues )

A

Returns a text result containing only the values that were provided in filterValues, in the order they were originally entered in textToFilter

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
Q

GetContainerAttribute (sourceField ; attributeName )

A

Returns the file metadata of the specified container field

Groups inlcude

  • general
  • audio
  • image
  • photo
  • barcode
  • signature
  • all
54
Q

GetField ( fieldName )

A

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
Q

GetFieldName ( fieldName )

A

Returns the fully qualified name of a field reference.

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
Q

GetValue ( listOfValues ; valueNumber )

A

Returns the requested value given by valueNumber from listOfValues

GetValue(“London¶Paris¶Hong Kong”;2)

returns: Paris

57
Q

IsValid ( field )

A

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
Q

Left ( text ; numberOfCharacters )

A

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
Q

Position ( text ; searchString ; start ; occurence )

A

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
Q

Get ( ConnectionState )

A

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 (5 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions