Filemaker TH325Z/A Fiche technique

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