Filemaker Pro 8.5 Educational Maintenance T0 TJ087LL/A Manuel D’Utilisation
Codes de produits
TJ087LL/A
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
See chapter 4, “Design functions” for information about literal text parameters.
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
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.