FileMaker® 8.5Functions Reference
10 FileMaker Functions Reference
100 FileMaker Functions ReferenceGet(PortalRowNumber)FormatGet(PortalRowNumber)ParameterNoneData type returnednumberDescriptionReturns the number
Chapter 7 | Get functions 101ExamplesReturns /C:/Documents and Settings/John Smith/Local Settings/Application Data/ for a user named John Smith
102 FileMaker Functions ReferenceGet(PrivilegeSetName)FormatGet(PrivilegeSetName)ParameterNoneData type returnedtextDescriptionReturns the name of
Chapter 7 | Get functions 103DescriptionReturns a number based on the current record’s access privileges, assigned through the Custom Record Pri
104 FileMaker Functions ReferenceDescriptionReturns the unique ID number of the current record. This number is a decimal value (an integer) genera
Chapter 7 | Get functions 105ExampleReturns 0 if the record has not been modified since it was created.If changes are made to four fields and al
106 FileMaker Functions ReferenceData type returnednumberDescriptionReturns the total number of open records in the current found set that haven’t
Chapter 7 | Get functions 107ExampleReturns 1 if the current record is a new record that hasn’t been saved.Get(RequestCount)FormatGet(RequestCou
108 FileMaker Functions ReferenceExampleReturns 1 when the Omit checkbox is selected in the current find request.Get(ScreenDepth)FormatGet(ScreenD
Chapter 7 | Get functions 109DescriptionReturns the number of pixels displayed vertically on the screen in which the window of the current file
Chapter 1IntroductionAbout functions A function is a predefined, named formula that performs a specific calculation and returns a single, specific val
110 FileMaker Functions ReferenceData type returnedtextDescriptionReturns the name of the script currently running (or paused).Note See FileMaker
Chapter 7 | Get functions 111Evaluate("Let ( [" & Get(ScriptParameter) & "]; a + 1 & \", \" & b + 2 )&q
112 FileMaker Functions ReferenceGet(SortState)FormatGet(SortState)ParameterNoneData type returnednumberDescriptionReturns 0 if the records in the
Chapter 7 | Get functions 113DescriptionReturns a number indicating the current status area state. Returns:• 0 (zero) if the status area is hidd
114 FileMaker Functions ReferenceGet(SystemIPAddress)FormatGet(SystemIPAddress)ParameterNoneData type returnedtextDescriptionReturns a list of the
Chapter 7 | Get functions 115Get(SystemNICAddress)FormatGet(SystemNICAddress)ParameterNoneData type returnedtextDescriptionReturns the hardware
116 FileMaker Functions ReferenceExamplesAbs(Get(SystemPlatform)) returns 2 when the current platform is a Windows platform.Get(SystemPlatform) re
Chapter 7 | Get functions 117Note See FileMaker Pro help for information about running scripts in client/server and peer-to-peer environments.E
118 FileMaker Functions ReferenceDescriptionReturns the number of clients currently accessing the file. Returns:• 1 if FileMaker network sharing i
Chapter 7 | Get functions 119Get(UseSystemFormatsState)FormatGet(UseSystemFormatsState)ParameterNoneData type returnednumberDescriptionReturns a
12 FileMaker Functions ReferenceFunctions reference (alphabetical list) This section lists the functions in alphabetical order. A, B, CAbs 144Ata
120 FileMaker Functions ReferenceThe example below combines Get(WindowContentHeight) with Get(WindowHeight) to determine the size of the title bar
Chapter 7 | Get functions 121DescriptionReturns a number representing the height, in pixels, of the desktop space. In Windows, the desktop space
122 FileMaker Functions ReferenceGet(WindowHeight)FormatGet(WindowHeight)ParameterNoneData type returnednumberDescriptionReturns a number represen
Chapter 7 | Get functions 123ExamplesReturns 52 when the outer edge of the active window is 52 pixels from the left edge of the screen.Returns 0
124 FileMaker Functions ReferenceData type returnedtextDescriptionReturns the name of the window that the script is acting on (not necessarily the
Chapter 7 | Get functions 125Get(WindowVisible)FormatGet(WindowVisible)ParameterNoneData type returnednumberDescriptionReturns a number represen
126 FileMaker Functions ReferenceNote See FileMaker Pro help for information about running scripts in client/server and peer-to-peer environments
Chapter 8 | Logical functions 127Chapter 8Logical functionsLogical functions test for a condition to evaluate it as true or false. This is known
128 FileMaker Functions ReferenceCaseFormatCase(test1;result1{;test2;result2;defaultResult...})Parameterstest - any text or numeric expression.res
Chapter 8 | Logical functions 129Data type returnedtext, number, date, time, timestamp, containerDescriptionReturns one result value, according
Chapter 1 | Introduction 13Get(ActiveRepetitionNumber) 71Get(ActiveSelectionSize) 72Get(ActiveSelectionStart) 72Get(AllowAbortState) 73Get(A
130 FileMaker Functions ReferenceEvaluate(GetField("textfield")) returns 4 when textfield contains 2 + 2.Evaluate(TextField;[Amount]) re
Chapter 8 | Logical functions 131The dependent parameter can also be useful in other cases. For example, Evaluate(“Get(CurrentTimeStamp)”, [Fiel
132 FileMaker Functions ReferenceDescriptionReturns 0 if data has a value of 0 or is empty, all other values return 1.ExamplesGetAsBoolean(“”) ret
Chapter 8 | Logical functions 133GetLayoutObjectAttributeFormatGetLayoutObjectAttribute(objectName;attributeName{;repetition Number})Parameterso
134 FileMaker Functions Referenceheight - returns a number representing the height (in pixels) of the specified object.rotation - returns a number
Chapter 8 | Logical functions 135ParametersfieldName - any related field or repeating field, or an expression that returns a field or a repeatin
136 FileMaker Functions ReferenceDescriptionReturns one of two possible results depending on the value of test. If test is True (any non-zero nume
Chapter 8 | Logical functions 137IsValidFormatIsValid(field)Parameterfield - any field nameData type returnednumberDescriptionReturns False (0)
138 FileMaker Functions ReferenceDescriptionReturns True (1) if expression syntax is correct. Returns False (0) if expression has a syntax error.E
Chapter 8 | Logical functions 139The Let function sets the variables from left to right. You can use previously defined variables (for example,
14 FileMaker Functions ReferenceGet(ScreenWidth) 109Get(ScriptName) 109Get(ScriptParameter) 110Get(ScriptResult) 111Get(SortState) 112Get(Sta
140 FileMaker Functions ReferenceLookupFormatLookup(sourceField{;failExpression})ParameterssourceField - the field from which the lookup value is
Chapter 8 | Logical functions 141LookupNextFormatLookupNext(sourceField;lower/higherFlag)ParameterssourceField - the field from which the lookup
142 FileMaker Functions ReferenceThe People and Company tables are related using the number field CompanyID. The calculation CompanyName = LookupN
Chapter 9 | Number functions 143Chapter 9Number functionsNumber functions are used to manipulate numeric data. Click a function name for details
144 FileMaker Functions ReferenceAbsFormatAbs(number)Parameternumber - any numeric expression or field containing a numeric expressionData type re
Chapter 9 | Number functions 145CombinationFormatCombination(setSize;numberOfChoices) ParameterssetSize - any numeric expression or field contai
146 FileMaker Functions ReferenceDescriptionReturns the next lowest integer value after dividing number by divisor. The Div function is equivalent
Chapter 9 | Number functions 147Data type returnednumberDescriptionReturns the factorial of number stopping at 1, or stopping at the optional nu
148 FileMaker Functions ReferenceParameternumber - any numeric expression or field containing a numeric expressionData type returnednumberDescript
Chapter 9 | Number functions 149LnFormatLn(number)Parameternumber - any numeric expression or field containing a numeric expressionData type ret
Chapter 1 | Introduction 15IsValidExpression 137KanaHankaku 171KanaZenkaku 172KanjiNumeral 172Katakana 172L, M, N, OLast 157LayoutIDs 49L
150 FileMaker Functions ReferenceModFormatMod(number;divisor)Parametersnumber - any numeric expression or field containing a numeric expressiondiv
Chapter 9 | Number functions 151DescriptionReturns a random number between zero and one. FileMaker Pro generates a new random number when you:•
152 FileMaker Functions ReferenceParametersexpression - any numeric expressionprecision - any number or numeric expressionData type returnednumber
Chapter 9 | Number functions 153SqrtFormatSqrt(number)Parameternumber - any positive number, numeric expression, or field containing a numeric e
154 FileMaker Functions ReferenceTruncate(29343.98;-3) returns 29000.Truncate(123.456;4) returns 123.456.Truncate(29343.98;5) returns 29343.98.
Chapter 10 | Repeating functions 155Chapter 10Repeating functionsRepeating functions perform calculations on repeating fields. Click a function
156 FileMaker Functions ReferenceExtendFormatExtend(non-repeatingField)Parameternon-repeatingField - any non-repeating field (a field defined to c
Chapter 10 | Repeating functions 157DescriptionReturns the contents of the repeating field specified by number.ExamplesParcelBids is a field def
158 FileMaker Functions ReferenceLast(if(IsEmpty(Company);PersonalPhone;WorkPhone)) returns the last non-empty phone number from the repeating fie
Chapter 11 | Summary functions 159Chapter 11Summary functionsSummary functions produce a summary of all records in the found set, or subsummary
16 FileMaker Functions ReferenceRomanHankaku 184RomanZenkaku 184Round 151SScriptIDs 52ScriptNames 53Seconds 203SerialIncrement 185SetPrecis
160 FileMaker Functions ReferenceGetSummaryFormatGetSummary(summaryField;breakField)ParameterssummaryField - field of type summary, or an expressi
Chapter 12 | Text functions 161Chapter 12Text functionsText functions can be used to analyze, rearrange, extract, and build text strings. For ex
162 FileMaker Functions ReferenceKanjiNumeral, page 172Kanji numerals converted from Arabic numerals.Katakana, page 172 Zenkaku Katakana converted
Chapter 12 | Text functions 163ExactFormatExact(originalText;comparisonText)ParametersoriginalText - any text expression, text field, or contain
164 FileMaker Functions ReferenceFilterFormatFilter(textToFilter;filterText)ParameterstextToFilter - any text expression or text fieldfilterText -
Chapter 12 | Text functions 165DescriptionReturns a text result containing only the characters that were provided in filterValues, in the order
166 FileMaker Functions ReferenceExampleGetAsCSS(text) returns the example result shown below when the field text contains the word “Frank” and th
Chapter 12 | Text functions 167Data type returnednumberDescriptionReturns only the numbers in text, as data type number, for use with formulas i
168 FileMaker Functions Reference</StyleList><Data> <Span style=”0”>Frank</Span></Data>GetAsTextFormatGetAsText(data
Chapter 12 | Text functions 169DescriptionReturns times or timestamps in text as data type time, for use with formulas involving the Time or Tim
Chapter 2Aggregate functionsAggregate functions perform statistical analysis on numbers (and also dates or times for some functions) in: • several fie
170 FileMaker Functions ReferenceData type returnedtextDescriptionReturns text as URL (Uniform Resource Locator) encoding, for use as a URL. Remov
Chapter 12 | Text functions 171ExampleGetValue(“London¶Paris¶Hong Kong”;2) returns ParisHiraganaFormatHiragana(text)Parametertext - any text exp
172 FileMaker Functions ReferenceKanaZenkakuFormatKanaZenkaku(text)Parametertext - any text expression or text fieldData type returnedtextDescript
Chapter 12 | Text functions 173Parametertext - any text expression or text fieldData type returnedtextDescriptionConverts from Hiragana to Zenka
174 FileMaker Functions ReferencenumberOfValues - any numeric expression or field containing a numberImportant See chapter 4, “Design functions”
Chapter 12 | Text functions 175ExamplesLeftWords(“Plaid Canvas Suitcase”;2) returns Plaid Canvas.LeftWords(Name;1) returns Sophie, when the Name
176 FileMaker Functions ReferenceExamplesLower(“ABCD”) returns abcd.Lower(Course) returns history, when the Course field contains History.Lower(“Y
Chapter 12 | Text functions 177Important See chapter 4, “Design functions” for information about literal text parameters.Data type returnedtext
178 FileMaker Functions ReferenceDescriptionReturns a text result containing the numberOfWords from text, beginning at startingWord.Note The ampe
Chapter 12 | Text functions 179ExamplesNumToJText(123456789;2;0) returns NumToJText(123456789;3;2) returns PatternCountFormatPatternCount(text;s
18 FileMaker Functions ReferenceAverageFormatAverage(field{;field...})Parameterfield - any related field, repeating field, or set of non-repeating
180 FileMaker Functions Referenceoccurrence - any numeric expression or field containing a number, representing which instance of the text string
Chapter 12 | Text functions 181Quote Format Quote(text) Parameter text - any text expression or field Data type returned text Description Return
182 FileMaker Functions ReferenceDescriptionReplaces a string of characters in text with replacementText. Character replacement in text begins at
Chapter 12 | Text functions 183Parameterstext - any text expression or text fieldnumberOfValues - any numeric expression or field containing a n
184 FileMaker Functions ReferencenumberOfWords - any numeric expression or field containing a numberData type returnedtextDescriptionReturns a tex
Chapter 12 | Text functions 185DescriptionConverts from Hankaku alphanumeric and symbols to Zenkaku alphanumeric and symbols.ExamplesRomanZenkak
186 FileMaker Functions ReferenceSubstituteFormatSubstitute(text;searchString;replaceString)Parameterstext - any text expression or text fieldsear
Chapter 12 | Text functions 187DescriptionReturns text stripped of all leading and trailing spaces. Tip Use the Trim function to remove unneede
188 FileMaker Functions ReferenceCharacters within the non-Roman range are those belonging to the CJK symbols/punctuations area, Hiragana, Katakan
Chapter 12 | Text functions 189DescriptionReturns all letters in text as uppercase. Use the Upper function to ensure consistent data entry of su
Chapter 2 | Aggregate functions 19Note When a referenced field is a repeating field, the Average function returns the average of the values in
190 FileMaker Functions ReferenceParametertext - any text expression or text fieldData type returnednumberDescriptionReturns a count of the total
Chapter 13 | Text formatting functions 191Chapter 13Text formatting functionsText formatting functions can be used to change the color, font, si
192 FileMaker Functions ReferenceRGBFormatRGB(red;green;blue)Parametersred - any numeric expression or numeric field containing a value ranging fr
Chapter 13 | Text formatting functions 193Data type returnedtextDescriptionChanges the color of text to the color specified by the RGB function.
194 FileMaker Functions ReferenceExamplesTextColorRemove(“Red Text and Green Text”) returns Red Text and Green Text displayed in the field’s defau
Chapter 13 | Text formatting functions 195• SimplifiedChinese•OEM• Symbol• OtherExamplesTextFont(“Plaid”;“Courier”) returns the word Plaid in th
196 FileMaker Functions ReferenceFileMaker Pro looks for a font that matches the specified font name and font script character set. If no matches
Chapter 13 | Text formatting functions 197DescriptionRemoves all text formatting from text in a single action. All fonts, styles, font sizes, an
198 FileMaker Functions ReferenceDescriptionRemoves all font sizes in text, or removes the font size specified by sizeToRemove. If you don’t speci
Chapter 13 | Text formatting functions 199• Extend• Strikethrough• SmallCaps• Superscript• Subscript• Uppercase• Lowercase• Titlecase• WordUnder
© 2006 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054FileMaker is a trademark of FileMak
20 FileMaker Functions ReferenceCount(Field1;Field2;Field3) returns 3, 2, 1,1 when the calculation is a repeating field.Note When a referenced fi
200 FileMaker Functions ReferenceData type returnedtextDescriptionRemoves the specified styles from text in a single action. You can remove multip
Chapter 14 | Time functions 201Chapter 14Time functionsTime functions calculate times and manipulate time information. Click a function name for
202 FileMaker Functions ReferenceHourFormatHour(time)Parametertime - any time value or field of type timeData type returnednumberDescriptionReturn
Chapter 14 | Time functions 203SecondsFormatSeconds(time)Parametertime - any time value or field of type timeData type returnednumberDescription
204 FileMaker Functions ReferenceExamplesTime(4;14;32) returns 4:14:32.Time(4.5;10;30) returns 4:40:30.Time(4;15;70) returns 4:16:10.
Chapter 15 | Timestamp functions 205Chapter 15Timestamp functionsTimestamps are used for a wide variety of synchronization purposes, such as mar
206 FileMaker Functions ReferenceTimestampFormatTimestamp(date;time)Parametersdate - any calendar date or date fieldtime - any time value or time
Chapter 16 | Trigonometric functions 207Chapter 16Trigonometric functionsTrigonometric functions are used to calculate degrees, angles, and othe
208 FileMaker Functions ReferenceAtanFormatAtan(number)Parameternumber - any numeric expression or field containing a numeric expressionData type
Chapter 16 | Trigonometric functions 209DegreesFormatDegrees(angleInRadians)ParameterangleInRadians - any numeric expression or field containing
Chapter 2 | Aggregate functions 21Example 1List (Field1; Field2) returns:whiteblackExample 2List(Field3) returns:redgreenblueExample 3List (Fiel
210 FileMaker Functions ReferenceRadiansFormatRadians(angleInDegrees)ParameterangleInDegrees - any numeric expression or field containing a numeri
Chapter 16 | Trigonometric functions 211TanFormatTan(angleInRadians)ParameterangleInRadians - any numeric expression or field containing a numer
212 FileMaker Functions Reference
Appendix A | Glossary 213Appendix AGlossary AAccess key (Windows)A key that activates a menu, menu item, or control when used with the ALT key.
214 FileMaker Functions ReferenceAuthenticationThe process of checking the validity of an account and password (if one is defined) before assignin
Appendix A | Glossary 215ButtonAny layout object (a 3-D rectangle with a text label if created by the Button tool) that performs a specified scr
216 FileMaker Functions ReferenceClient/server architectureThe relationship between two networked computers that share resources. The client reque
Appendix A | Glossary 217Also refers to opening a file created with a previous version of FileMaker Pro.DData Entry Only privilege setOne of the
218 FileMaker Functions ReferenceDriver managerThe control panel that manages communication between requesting applications and data sources. When
Appendix A | Glossary 219ExpressionA value or any computation that produces a value. Expressions can contain functions, field values, and consta
22 FileMaker Functions ReferenceData type returnedtext, number, date, time, timestampDescriptionReturns the highest valid value in:• a repeating f
220 FileMaker Functions ReferenceField typeThe part of a field definition that determines what kind of data you can enter in the field and the kin
Appendix A | Glossary 221FormulaA set of instructions that FileMaker Pro follows to calculate a value used in a field or as the criteria for mat
222 FileMaker Functions ReferenceGrand summary partUse grand summary parts to view and display summary information (totals, averages, and so on) i
Appendix A | Glossary 223IImportTo bring (copy) data from a table, another file, or another application into the current table. You can also imp
224 FileMaker Functions ReferenceKeyA column (or columns) that makes a particular row unique (corresponds to a match field).LLabels layoutA predef
Appendix A | Glossary 225Layout typesFileMaker Pro includes six predefined layout types: Standard Form, Columnar List/Report, Table View, Labels
226 FileMaker Functions ReferenceMMany-to-many relationshipA correspondence between data in database tables in which more than one record in the f
Appendix A | Glossary 227Multi-key fieldA match field that contains more than one value, each on a separate line. A multi-key field can be used
228 FileMaker Functions Reference1-away relationshipA correspondence between database tables in which two tables are directly related to each othe
Appendix A | Glossary 229PortalFor relational databases, a layout object in one table where you place one or more related fields to display in r
Chapter 2 | Aggregate functions 23Parameters in curly braces { } are optional.Data type returnedtext, number, date, time, timestampDescriptionRe
230 FileMaker Functions ReferenceRelated fieldFor relational databases, a field in one table that is related to a field in another table (or to a
Appendix A | Glossary 231SSchemaIn database terminology, a schema is the organization or structure of the elements, objects, and attributes of a
232 FileMaker Functions ReferenceShared databaseA database file for which sharing has been enabled, which permits users to access the database fil
Appendix A | Glossary 233Stacking orderThe order in which objects overlap on a layout. You can change this order by cutting and pasting objects
234 FileMaker Functions ReferenceSystem formatsSettings you control with control panels to determine how dates, times, currency, and numbers displ
Appendix A | Glossary 235TemplateOr Starter Solution. A pre-designed and formatted FileMaker Pro file, or web page, that you can copy and change
236 FileMaker Functions ReferenceUnit of measureIn Browse and Layout modes, you can set the unit of measure to pixels, inches, or centimeters.Unst
Appendix A | Glossary 237W, X, Y, ZWeb addressThe calculated expression that you enter in the Web Viewer Setup dialog box. A web address is not
238 FileMaker Functions ReferenceXML (Extensible Markup Language)Instead of being a rigid file format, XML is a language for defining agreed-upon
24 FileMaker Functions ReferenceParameterfield - any related field, repeating field, or set of non-repeating fields; or an expression that returns
Chapter 2 | Aggregate functions 25StDevPFormatStDevP(field{;field... })Parameterfield - any related field, repeating field, or set of non-repeat
26 FileMaker Functions ReferenceStDevP(Field2) returns 1.11803398... for a non-repeating field.StDevP(Field1;Field2;Field3) returns 2.16024689...,
Chapter 2 | Aggregate functions 27 In the following examples:• Field1 contains two repetitions with values of 1 and 2. • Field2 contains four re
28 FileMaker Functions Reference• several fields in the first matching record specified by (table::field1;table::field2;...). You can include fiel
Chapter 2 | Aggregate functions 29DescriptionReturns the variance of a population represented by a series of non-blank values. The variance of a
ContentsChapter 1 Introduction 11About functions 11Using this functions reference 11Functions reference (alphabetical list) 12Chapter 2 Agg
30 FileMaker Functions Reference
Chapter 3 | Date functions 31Chapter 3Date functionsDate functions calculate dates and manipulate date information.Important To avoid errors wh
32 FileMaker Functions ReferenceDateFormatDate(month;day;year)Parametersmonth - the month of the year (a number from 1 to 12).day - the day of the
Chapter 3 | Date functions 33Data type returnednumberDescriptionReturns a number in the range 1 through 31, representing the day of the month on
34 FileMaker Functions ReferenceDayNameJFormatDayNameJ(date)Parameterdate - any calendar dateData type returnedtextDescriptionReturns a text strin
Chapter 3 | Date functions 35DayOfYearFormatDayOfYear(date)Parameterdate - any calendar dateData type returnednumberDescriptionReturns a number
36 FileMaker Functions ReferenceExamplesMonth(“3/19/2004”) returns 3. This example assumes that the operating system date format is set to MM/DD/Y
Chapter 3 | Date functions 37Data type returnedtextDescriptionReturns the name of the month of date in Japanese. Important To avoid errors when
38 FileMaker Functions ReferenceData type returnednumberDescriptionReturns a number between 1 and 53 representing the week containing date, figure
Chapter 3 | Date functions 39ExamplesYear(DateSold) returns the year stored in DateSold.Year(“5/5/2004”) returns 2004.Year(Date(Month(Get(Curren
4 FileMaker Functions ReferenceFieldIDs 45FieldNames 45FieldRepetitions 46FieldStyle 47FieldType 48GetNextSerialValue 49LayoutIDs 49
40 FileMaker Functions Reference
Chapter 4 | Design functions 41Chapter 4Design functionsDesign functions return information about the structure of open database files. For exam
42 FileMaker Functions ReferenceLayoutNames, page 50A list of the names of all layouts in the specified database file, separated by carriage retur
Chapter 4 | Design functions 43DatabaseNamesFormatDatabaseNamesParameterNoneData type returnedtextDescriptionReturns a list of the names of all
44 FileMaker Functions ReferenceDescriptionReturns in a non-repeating text field the location in pixels of each side of fieldName and its rotation
Chapter 4 | Design functions 45DescriptionReturns the specified field’s comment. The field name must be in the form tablename::fieldname to spec
46 FileMaker Functions ReferenceParametersfileName - the name of an open database file (local or remote).layoutName - the name of a layout or tabl
Chapter 4 | Design functions 47DescriptionReturns the number of repetitions of the repeating field fieldName as it is currently formatted on lay
48 FileMaker Functions ReferenceExampleOn the Data Entry layout in the Customers database file, FieldStyle(“Customers”;“Data Entry”;“Current Custo
Chapter 4 | Design functions 49GetNextSerialValueFormatGetNextSerialValue(fileName;fieldName)ParametersfileName - the name of an open database f
| Contents 5Get(AllowToolbarState) 73Get(ApplicationLanguage) 74Get(ApplicationVersion) 75Get(CalculationRepetitionNumber) 75Get(Curren
50 FileMaker Functions ReferenceLayoutNamesFormatLayoutNames(fileName)ParameterfileName - the name of an open database file (local or remote).Impo
Chapter 4 | Design functions 51ExampleLayoutObjectNames ("Customers";"Data Entry") returns a list of named objects in the Cu
52 FileMaker Functions ReferenceExampleA database file called Human Resources has three tables: Company, Employees, and Addresses. Company::Compan
Chapter 4 | Design functions 53ExampleScriptIDs(“Customers”) returns a list of all the script IDs in the Customers database file.ScriptNamesForm
54 FileMaker Functions ReferenceExampleTableIDs(“University Database”) returns10650891065090for the University Database database file if two table
Chapter 4 | Design functions 55Data type returnedtextDescriptionReturns a list of all value list IDs in fileName, separated by carriage returns.
56 FileMaker Functions ReferenceDescriptionReturns a list of the names of all value lists in fileName, separated by carriage returns.ExampleValueL
Chapter 5 | External functions 57Chapter 5External functionsUse external functions to access FileMaker Pro plug-ins. Plug-ins add features to Fi
58 FileMaker Functions ReferenceExternalFormatExternal(nameOfFunction;parameter)ParametersnameOfFunction - the name of the external functionparame
Chapter 6 | Financial functions 59Chapter 6Financial functionsFinancial functions calculate financial information, such as net present value and
6 FileMaker Functions ReferenceGet(RecordOpenCount) 105Get(RecordOpenState) 106Get(RequestCount) 107Get(RequestOmitState) 107Get(ScreenDep
60 FileMaker Functions ReferenceFVFormatFV(payment;interestRate;periods)Parameterspayment - payment to be made per periodinterestRate - interest r
Chapter 6 | Financial functions 61interestRate - interest rate.Data type returnednumberDescriptionReturns the net present value of a series of u
62 FileMaker Functions ReferenceExamplesIn the following example, the PMT function calculates payments for purchasing a sports car costing $21,000
Chapter 7 | Get functions 63Chapter 7Get functionsUse Get functions in scripts for error checking and prevention, or to capture information abou
64 FileMaker Functions ReferenceGet(ApplicationVersion), page 75 Text representing the FileMaker Pro application version.Get(CalculationRepetition
Chapter 7 | Get functions 65Get(LayoutTableName), page 97 The name of the table that the layout is displaying records from.Get(LayoutViewState),
66 FileMaker Functions ReferenceGet(SystemPlatform), page 115 A number indicating the current platform.Get(SystemVersion), page 116 The version of
Chapter 7 | Get functions 67Get functions exampleThis script uses the function Get(CurrentDate) to check each record in the found set to see if
68 FileMaker Functions ReferenceGet(AccountName)FormatGet(AccountName)ParameterNoneData type returnedtextDescriptionFor FileMaker authentication,
Chapter 7 | Get functions 69Data type returnedtext, number, date, time, timestamp, containerDescriptionReturns the contents of the field contain
| Contents 7GetAsBoolean 131GetField 132GetLayoutObjectAttribute 133GetNthRecord 134If 135IsEmpty 136IsValid 137IsValidExpression
70 FileMaker Functions ReferenceParameterNoneData type returnedtextDescriptionReturns the name of the table that contains the active field (the fi
Chapter 7 | Get functions 71Get(ActiveModifierKeys)FormatGet(ActiveModifierKeys)ParameterNoneData type returnednumberDescriptionReturns a number
72 FileMaker Functions ReferenceDescriptionReturns a number representing the active repetition of a repeating field (the repetition that currently
Chapter 7 | Get functions 73DescriptionReturns a number representing the starting character of the selected text. Returns the cursor's curr
74 FileMaker Functions ReferenceDescriptionReturns a Boolean value representing whether toolbars are allowed to be visible. Returns 1 if toolbars
Chapter 7 | Get functions 75Get(ApplicationVersion)FormatGet(ApplicationVersion)ParameterNoneData type returnedtextDescriptionReturns text repre
76 FileMaker Functions ReferenceNote See FileMaker Pro help for information about running scripts in client/server and peer-to-peer environments.
Chapter 7 | Get functions 77Data type returnedtimestampDescriptionReturns the host’s current date and time according to the system clock, to the
78 FileMaker Functions ReferenceDescriptionReturns the current time according to the system clock, to the nearest second. The format of the value
Chapter 7 | Get functions 79ParameterNoneData type returnedtextDescriptionReturns the name of the active custom menu set. If the active menu set
8 FileMaker Functions ReferenceChapter 12 Text functions 161Exact 163Filter 164FilterValues 164GetAsCSS 165GetAsDate 166GetAsNumber
80 FileMaker Functions ReferenceGet(DocumentsPath)FormatGet(DocumentsPath)ParameterNoneData type returnedtextDescriptionReturns the path to the do
Chapter 7 | Get functions 81Get(ExtendedPrivileges)FormatGet(ExtendedPrivileges)ParameterNoneData type returnedtextDescriptionReturns a list of
82 FileMaker Functions ReferenceDescriptionReturns the path to the folder of the currently running copy of FileMaker Pro. In Windows, the path for
Chapter 7 | Get functions 83ParameterNoneData type returnedtextDescriptionReturns the full path indicating the location of the currently active
84 FileMaker Functions ReferenceNotes• If the current calculation is stored and you specify its context, this function will be evaluated based on
Chapter 7 | Get functions 85ParameterNoneData type returnedtextDescriptionWindows: returns the name of the current high contrast default color s
86 FileMaker Functions ReferenceParameterNoneData type returnedtextDescriptionReturns the IP address of the host machine for the current database.
Chapter 7 | Get functions 87Notes• If the current calculation is stored and you specify its context, this function will be evaluated based on th
88 FileMaker Functions ReferenceRuntime errorsError NumberDescription-1 Unknown error0 No error1 User canceled action2 Memory error3 Command is un
Chapter 7 | Get functions 89115 Specified menu set is not present116 Specified layout object is not present130 Files are damaged or missing and
| Contents 9Upper 188ValueCount 189WordCount 189Chapter 13 Text formatting functions 191RGB 192TextColor 192TextColorRemove 193Te
90 FileMaker Functions Reference409 Import order is invalid 410 Export order is invalid412 Wrong version of FileMaker Pro used to recover file413
Chapter 7 | Get functions 91723 You do not have permission to add records to or modify records in the target table724 You do not have permission
92 FileMaker Functions Reference900 General spelling engine error901 Main spelling dictionary not installed902 Could not launch the Help system 90
Chapter 7 | Get functions 93Error codes marked with an asterisk (*) are returned only by web-published databases.Get(LastMessageChoice)FormatGet
94 FileMaker Functions ReferenceGet(LastODBCError)FormatGet(LastODBCError)ParameterNoneData type returnedtextDescriptionReturns a string that show
Chapter 7 | Get functions 95DescriptionReturns a number based on record access privileges available through the current layout. You assign the p
96 FileMaker Functions ReferenceExampleReturns 3 when the file has three layouts.Get(LayoutName)FormatGet(LayoutName)ParameterNoneData type return
Chapter 7 | Get functions 97Note See FileMaker Pro help for information about running scripts in client/server and peer-to-peer environments.Ex
98 FileMaker Functions Reference• 0 (zero) if the database file is in View as Form view• 1 if the database file is in View as List view• 2 if the
Chapter 7 | Get functions 99Get(NetworkProtocol)FormatGet(NetworkProtocol)ParameterNoneData type returnedtextDescriptionReturns the name of the
Komentarze do niniejszej Instrukcji