Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

Product codes
TJ083LL/A
Page of 238
132     FileMaker Functions Reference
Description
Returns 
0
 if data has a value of 0 or is empty, all other values return 
1
.
Examples
GetAsBoolean(“”) returns 
0
.
GetAsBoolean(“Some text here.”) returns 
0
.
GetAsBoolean(Container Field) returns 
1
 when the field named Container Field 
contains data, or returns 
0
 when Container Field is empty.
GetField
Format
GetField(fieldName)
Parameter
fieldName - any 
 that refers to a field’s name
Important  
Data type returned
text, number, date, time, timestamp, container
Description
Returns the contents of fieldName. Use this function to get fieldName’s contents, or 
in any function that uses a field, such as NPV, GetSummary, GetRepetition, or the 
aggregate functions.
Examples
Assume you have the following fields: Arrow and Target. Arrow contains the text string 
Target
, and Target contains the text string 
Bullseye
.
GetField(“Arrow”) returns 
Target
. Notice the use of quotation marks around 
Arrow to indicate the literal string is the fieldName parameter.
GetField(Arrow) returns 
Bullseye
. Notice the absence of quotation marks to 
indicate the value stored in the Arrow field is the fieldName parameter.
Assume you have the following two 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
.
GetSummary(GetField(“Field1”), GetField(“Field” & “2”)) performs a 
summary on the 
 Field1, using a break field of Field2.