Filemaker Upgrade to FileMaker Pro 8.5 VLA Educational Tier 4 + Maintenance User Manuals

Product codes

TJ066Z/AShow more

, TJ964Z/A, TJ447Z/A

User Manual (English)User Manual (English)User Manual (English)

User Manual (TJ066Z/A)

Table of Contents

Chapter 1 Introduction
11
Chapter 2 Aggregate functions
17
- Average
  18
- Count
  19
- List
  20
- Max
  21
- Min
  22
- StDev
  23
- StDevP
  25
- Sum
  26
- Variance
  27
- VarianceP
  28
Chapter 3 Date functions
31
- Date
  32
- Day
  32
- DayName
  33
- DayNameJ
  34
- DayOfWeek
  34
- DayOfYear
  35
- Month
  35
- MonthName
  36
- MonthNameJ
  36
- WeekOfYear
  37
- WeekOfYearFiscal
  37
- Year
  38
- YearName
  39
Chapter 4 Design functions
41
- DatabaseNames
  43
- FieldBounds
  43
- FieldComment
  44
- FieldIDs
  45
- FieldNames
  45
- FieldRepetitions
  46
- FieldStyle
  47
- FieldType
  48
- GetNextSerialValue
  49
- LayoutIDs
  49
- LayoutNames
  50
- LayoutObjectNames
  50
- RelationInfo
  51
- ScriptIDs
  52
- ScriptNames
  53
- TableIDs
  53
- TableNames
  54
- ValueListIDs
  54
- ValueListItems
  55
- ValueListNames
  55
- WindowNames
  56
Chapter 5 External functions
57
- External
  58
Chapter 6 Financial functions
59
- FV
  60
- NPV
  60
- PMT
  61
- PV
  62
Chapter 7 Get functions
63
- Get(AccountName)
  68
- Get(ActiveFieldContents)
  68
- Get(ActiveFieldName)
  69
- Get(ActiveFieldTableName)
  69
- Get(ActiveLayoutObjectName)
  70
- Get(ActiveModifierKeys)
  71
- Get(ActiveRepetitionNumber)
  71
- Get(ActiveSelectionSize)
  72
- Get(ActiveSelectionStart)
  72
- Get(AllowAbortState)
  73
- Get(AllowToolbarState)
  73
- Get(ApplicationLanguage)
  74
- Get(ApplicationVersion)
  75
- Get(CalculationRepetitionNumber)
  75
- Get(CurrentDate)
  76
- Get(CurrentHostTimestamp)
  76
- Get(CurrentTime)
  77
- Get(CurrentTimestamp)
  78
- Get(CustomMenuSetName)
  78
- Get(DesktopPath)
  79
- Get(DocumentsPath)
  80
- Get(ErrorCaptureState)
  80
- Get(ExtendedPrivileges)
  81
- Get(FileMakerPath)
  81
- Get(FileName)
  82
- Get(FilePath)
  82
- Get(FileSize)
  83
- Get(FoundCount)
  84
- Get(HighContrastColor)
  84
- Get(HighContrastState)
  85
- Get(HostIPAddress)
  85
- Get(HostName)
  86
- Get(LastError)
  87
- Get(LastMessageChoice)
  93
- Get(LastODBCError)
  94
- Get(LayoutAccess)
  94
- Get(LayoutCount)
  95
- Get(LayoutName)
  96
- Get(LayoutNumber)
  96
- Get(LayoutTableName)
  97
- Get(LayoutViewState)
  97
- Get(MultiUserState)
  98
- Get(NetworkProtocol)
  99
- Get(PageNumber)
  99
- Get(PortalRowNumber)
  100
- Get(PreferencesPath)
  100
- Get(PrinterName)
  101
- Get(PrivilegeSetName)
  102
- Get(RecordAccess)
  102
- Get(RecordID)
  103
- Get(RecordModificationCount)
  104
- Get(RecordNumber)
  105
- Get(RecordOpenCount)
  105
- Get(RecordOpenState)
  106
- Get(RequestCount)
  107
- Get(RequestOmitState)
  107
- Get(ScreenDepth)
  108
- Get(ScreenHeight)
  108
- Get(ScreenWidth)
  109
- Get(ScriptName)
  109
- Get(ScriptParameter)
  110
- Get(ScriptResult)
  111
- Get(SortState)
  112
- Get(StatusAreaState)
  112
- Get(SystemDrive)
  113
- Get(SystemIPAddress)
  114
- Get(SystemLanguage)
  114
- Get(SystemNICAddress)
  115
- Get(SystemPlatform)
  115
- Get(SystemVersion)
  116
- Get(TextRulerVisible)
  116
- Get(TotalRecordCount)
  117
- Get(UserCount)
  117
- Get(UserName)
  118
- Get(UseSystemFormatsState)
  119
- Get(WindowContentHeight)
  119
- Get(WindowContentWidth)
  120
- Get(WindowDesktopHeight)
  120
- Get(WindowDesktopWidth)
  121
- Get(WindowHeight)
  122
- Get(WindowLeft)
  122
- Get(WindowMode)
  123
- Get(WindowName)
  123
- Get(WindowTop)
  124
- Get(WindowVisible)
  125
- Get(WindowWidth)
  125
- Get(WindowZoomLevel)
  126
Chapter 8 Logical functions
127
- Case
  128
- Choose
  128
- Evaluate
  129
- EvaluationError
  131
- GetAsBoolean
  131
- GetField
  132
- GetLayoutObjectAttribute
  133
- GetNthRecord
  134
- If
  135
- IsEmpty
  136
- IsValid
  137
- IsValidExpression
  137
- Let
  138
- Lookup
  140
- LookupNext
  141
Chapter 9 Number functions
143
- Abs
  144
- Ceiling
  144
- Combination
  145
- Div
  145
- Exp
  146
- Factorial
  146
- Floor
  147
- Int
  147
- Lg
  148
- Ln
  149
- Log
  149
- Mod
  150
- Random
  150
- Round
  151
- SetPrecision
  151
- Sign
  152
- Sqrt
  153
- Truncate
  153
Chapter 10 Repeating functions
155
- Extend
  156
- GetRepetition
  156
- Last
  157
Chapter 11 Summary functions
159
- GetSummary
  160
Chapter 12 Text functions
161
- Exact
  163
- Filter
  164
- FilterValues
  164
- GetAsCSS
  165
- GetAsDate
  166
- GetAsNumber
  166
- GetAsSVG
  167
- GetAsText
  168
- GetAsTime
  168
- GetAsTimestamp
  169
- GetAsURLEncoded
  169
- GetValue
  170
- Hiragana
  171
- KanaHankaku
  171
- KanaZenkaku
  172
- KanjiNumeral
  172
- Katakana
  172
- Left
  173
- LeftValues
  173
- LeftWords
  174
- Length
  175
- Lower
  175
- Middle
  176
- MiddleValues
  176
- MiddleWords
  177
- NumToJText
  178
- PatternCount
  179
- Position
  179
- Proper
  180
- Quote
  181
- Replace
  181
- Right
  182
- RightValues
  182
- RightWords
  183
- RomanHankaku
  184
- RomanZenkaku
  184
- SerialIncrement
  185
- Substitute
  186
- Trim
  186
- TrimAll
  187
- Upper
  188
- ValueCount
  189
- WordCount
  189
Chapter 13 Text formatting functions
191
- RGB
  192
- TextColor
  192
- TextColorRemove
  193
- TextFont
  194
- TextFontRemove
  195
- TextFormatRemove
  196
- TextSize
  197
- TextSizeRemove
  197
- TextStyleAdd
  198
- TextStyleRemove
  199
Chapter 14 Time functions
201
- Hour
  202
- Minute
  202
- Seconds
  203
- Time
  203
Chapter 15 Timestamp functions
205
- Timestamp
  206
Chapter 16 Trigonometric functions
207
- Atan
  208
- Cos
  208
- Degrees
  209
- Pi
  209
- Radians
  210
- Sin
  210
- Tan
  211
Appendix A Glossary
213

User Manual (TJ066Z/A)

Size:

1.84 MB
Pages:

238
Language:

English

User Manual (TJ964Z/A)

Table of Contents

Chapter 1 Introduction
11
Chapter 2 Aggregate functions
17
- Average
  18
- Count
  19
- List
  20
- Max
  21
- Min
  22
- StDev
  23
- StDevP
  25
- Sum
  26
- Variance
  27
- VarianceP
  28
Chapter 3 Date functions
31
- Date
  32
- Day
  32
- DayName
  33
- DayNameJ
  34
- DayOfWeek
  34
- DayOfYear
  35
- Month
  35
- MonthName
  36
- MonthNameJ
  36
- WeekOfYear
  37
- WeekOfYearFiscal
  37
- Year
  38
- YearName
  39
Chapter 4 Design functions
41
- DatabaseNames
  43
- FieldBounds
  43
- FieldComment
  44
- FieldIDs
  45
- FieldNames
  45
- FieldRepetitions
  46
- FieldStyle
  47
- FieldType
  48
- GetNextSerialValue
  49
- LayoutIDs
  49
- LayoutNames
  50
- LayoutObjectNames
  50
- RelationInfo
  51
- ScriptIDs
  52
- ScriptNames
  53
- TableIDs
  53
- TableNames
  54
- ValueListIDs
  54
- ValueListItems
  55
- ValueListNames
  55
- WindowNames
  56
Chapter 5 External functions
57
- External
  58
Chapter 6 Financial functions
59
- FV
  60
- NPV
  60
- PMT
  61
- PV
  62
Chapter 7 Get functions
63
- Get(AccountName)
  68
- Get(ActiveFieldContents)
  68
- Get(ActiveFieldName)
  69
- Get(ActiveFieldTableName)
  69
- Get(ActiveLayoutObjectName)
  70
- Get(ActiveModifierKeys)
  71
- Get(ActiveRepetitionNumber)
  71
- Get(ActiveSelectionSize)
  72
- Get(ActiveSelectionStart)
  72
- Get(AllowAbortState)
  73
- Get(AllowToolbarState)
  73
- Get(ApplicationLanguage)
  74
- Get(ApplicationVersion)
  75
- Get(CalculationRepetitionNumber)
  75
- Get(CurrentDate)
  76
- Get(CurrentHostTimestamp)
  76
- Get(CurrentTime)
  77
- Get(CurrentTimestamp)
  78
- Get(CustomMenuSetName)
  78
- Get(DesktopPath)
  79
- Get(DocumentsPath)
  80
- Get(ErrorCaptureState)
  80
- Get(ExtendedPrivileges)
  81
- Get(FileMakerPath)
  81
- Get(FileName)
  82
- Get(FilePath)
  82
- Get(FileSize)
  83
- Get(FoundCount)
  84
- Get(HighContrastColor)
  84
- Get(HighContrastState)
  85
- Get(HostIPAddress)
  85
- Get(HostName)
  86
- Get(LastError)
  87
- Get(LastMessageChoice)
  93
- Get(LastODBCError)
  94
- Get(LayoutAccess)
  94
- Get(LayoutCount)
  95
- Get(LayoutName)
  96
- Get(LayoutNumber)
  96
- Get(LayoutTableName)
  97
- Get(LayoutViewState)
  97
- Get(MultiUserState)
  98
- Get(NetworkProtocol)
  99
- Get(PageNumber)
  99
- Get(PortalRowNumber)
  100
- Get(PreferencesPath)
  100
- Get(PrinterName)
  101
- Get(PrivilegeSetName)
  102
- Get(RecordAccess)
  102
- Get(RecordID)
  103
- Get(RecordModificationCount)
  104
- Get(RecordNumber)
  105
- Get(RecordOpenCount)
  105
- Get(RecordOpenState)
  106
- Get(RequestCount)
  107
- Get(RequestOmitState)
  107
- Get(ScreenDepth)
  108
- Get(ScreenHeight)
  108
- Get(ScreenWidth)
  109
- Get(ScriptName)
  109
- Get(ScriptParameter)
  110
- Get(ScriptResult)
  111
- Get(SortState)
  112
- Get(StatusAreaState)
  112
- Get(SystemDrive)
  113
- Get(SystemIPAddress)
  114
- Get(SystemLanguage)
  114
- Get(SystemNICAddress)
  115
- Get(SystemPlatform)
  115
- Get(SystemVersion)
  116
- Get(TextRulerVisible)
  116
- Get(TotalRecordCount)
  117
- Get(UserCount)
  117
- Get(UserName)
  118
- Get(UseSystemFormatsState)
  119
- Get(WindowContentHeight)
  119
- Get(WindowContentWidth)
  120
- Get(WindowDesktopHeight)
  120
- Get(WindowDesktopWidth)
  121
- Get(WindowHeight)
  122
- Get(WindowLeft)
  122
- Get(WindowMode)
  123
- Get(WindowName)
  123
- Get(WindowTop)
  124
- Get(WindowVisible)
  125
- Get(WindowWidth)
  125
- Get(WindowZoomLevel)
  126
Chapter 8 Logical functions
127
- Case
  128
- Choose
  128
- Evaluate
  129
- EvaluationError
  131
- GetAsBoolean
  131
- GetField
  132
- GetLayoutObjectAttribute
  133
- GetNthRecord
  134
- If
  135
- IsEmpty
  136
- IsValid
  137
- IsValidExpression
  137
- Let
  138
- Lookup
  140
- LookupNext
  141
Chapter 9 Number functions
143
- Abs
  144
- Ceiling
  144
- Combination
  145
- Div
  145
- Exp
  146
- Factorial
  146
- Floor
  147
- Int
  147
- Lg
  148
- Ln
  149
- Log
  149
- Mod
  150
- Random
  150
- Round
  151
- SetPrecision
  151
- Sign
  152
- Sqrt
  153
- Truncate
  153
Chapter 10 Repeating functions
155
- Extend
  156
- GetRepetition
  156
- Last
  157
Chapter 11 Summary functions
159
- GetSummary
  160
Chapter 12 Text functions
161
- Exact
  163
- Filter
  164
- FilterValues
  164
- GetAsCSS
  165
- GetAsDate
  166
- GetAsNumber
  166
- GetAsSVG
  167
- GetAsText
  168
- GetAsTime
  168
- GetAsTimestamp
  169
- GetAsURLEncoded
  169
- GetValue
  170
- Hiragana
  171
- KanaHankaku
  171
- KanaZenkaku
  172
- KanjiNumeral
  172
- Katakana
  172
- Left
  173
- LeftValues
  173
- LeftWords
  174
- Length
  175
- Lower
  175
- Middle
  176
- MiddleValues
  176
- MiddleWords
  177
- NumToJText
  178
- PatternCount
  179
- Position
  179
- Proper
  180
- Quote
  181
- Replace
  181
- Right
  182
- RightValues
  182
- RightWords
  183
- RomanHankaku
  184
- RomanZenkaku
  184
- SerialIncrement
  185
- Substitute
  186
- Trim
  186
- TrimAll
  187
- Upper
  188
- ValueCount
  189
- WordCount
  189
Chapter 13 Text formatting functions
191
- RGB
  192
- TextColor
  192
- TextColorRemove
  193
- TextFont
  194
- TextFontRemove
  195
- TextFormatRemove
  196
- TextSize
  197
- TextSizeRemove
  197
- TextStyleAdd
  198
- TextStyleRemove
  199
Chapter 14 Time functions
201
- Hour
  202
- Minute
  202
- Seconds
  203
- Time
  203
Chapter 15 Timestamp functions
205
- Timestamp
  206
Chapter 16 Trigonometric functions
207
- Atan
  208
- Cos
  208
- Degrees
  209
- Pi
  209
- Radians
  210
- Sin
  210
- Tan
  211
Appendix A Glossary
213

User Manual (TJ964Z/A)

Size:

1.84 MB
Pages:

238
Language:

English

User Manual (TJ447Z/A)

Table of Contents

Chapter 1 Introduction
11
Chapter 2 Aggregate functions
17
- Average
  18
- Count
  19
- List
  20
- Max
  21
- Min
  22
- StDev
  23
- StDevP
  25
- Sum
  26
- Variance
  27
- VarianceP
  28
Chapter 3 Date functions
31
- Date
  32
- Day
  32
- DayName
  33
- DayNameJ
  34
- DayOfWeek
  34
- DayOfYear
  35
- Month
  35
- MonthName
  36
- MonthNameJ
  36
- WeekOfYear
  37
- WeekOfYearFiscal
  37
- Year
  38
- YearName
  39
Chapter 4 Design functions
41
- DatabaseNames
  43
- FieldBounds
  43
- FieldComment
  44
- FieldIDs
  45
- FieldNames
  45
- FieldRepetitions
  46
- FieldStyle
  47
- FieldType
  48
- GetNextSerialValue
  49
- LayoutIDs
  49
- LayoutNames
  50
- LayoutObjectNames
  50
- RelationInfo
  51
- ScriptIDs
  52
- ScriptNames
  53
- TableIDs
  53
- TableNames
  54
- ValueListIDs
  54
- ValueListItems
  55
- ValueListNames
  55
- WindowNames
  56
Chapter 5 External functions
57
- External
  58
Chapter 6 Financial functions
59
- FV
  60
- NPV
  60
- PMT
  61
- PV
  62
Chapter 7 Get functions
63
- Get(AccountName)
  68
- Get(ActiveFieldContents)
  68
- Get(ActiveFieldName)
  69
- Get(ActiveFieldTableName)
  69
- Get(ActiveLayoutObjectName)
  70
- Get(ActiveModifierKeys)
  71
- Get(ActiveRepetitionNumber)
  71
- Get(ActiveSelectionSize)
  72
- Get(ActiveSelectionStart)
  72
- Get(AllowAbortState)
  73
- Get(AllowToolbarState)
  73
- Get(ApplicationLanguage)
  74
- Get(ApplicationVersion)
  75
- Get(CalculationRepetitionNumber)
  75
- Get(CurrentDate)
  76
- Get(CurrentHostTimestamp)
  76
- Get(CurrentTime)
  77
- Get(CurrentTimestamp)
  78
- Get(CustomMenuSetName)
  78
- Get(DesktopPath)
  79
- Get(DocumentsPath)
  80
- Get(ErrorCaptureState)
  80
- Get(ExtendedPrivileges)
  81
- Get(FileMakerPath)
  81
- Get(FileName)
  82
- Get(FilePath)
  82
- Get(FileSize)
  83
- Get(FoundCount)
  84
- Get(HighContrastColor)
  84
- Get(HighContrastState)
  85
- Get(HostIPAddress)
  85
- Get(HostName)
  86
- Get(LastError)
  87
- Get(LastMessageChoice)
  93
- Get(LastODBCError)
  94
- Get(LayoutAccess)
  94
- Get(LayoutCount)
  95
- Get(LayoutName)
  96
- Get(LayoutNumber)
  96
- Get(LayoutTableName)
  97
- Get(LayoutViewState)
  97
- Get(MultiUserState)
  98
- Get(NetworkProtocol)
  99
- Get(PageNumber)
  99
- Get(PortalRowNumber)
  100
- Get(PreferencesPath)
  100
- Get(PrinterName)
  101
- Get(PrivilegeSetName)
  102
- Get(RecordAccess)
  102
- Get(RecordID)
  103
- Get(RecordModificationCount)
  104
- Get(RecordNumber)
  105
- Get(RecordOpenCount)
  105
- Get(RecordOpenState)
  106
- Get(RequestCount)
  107
- Get(RequestOmitState)
  107
- Get(ScreenDepth)
  108
- Get(ScreenHeight)
  108
- Get(ScreenWidth)
  109
- Get(ScriptName)
  109
- Get(ScriptParameter)
  110
- Get(ScriptResult)
  111
- Get(SortState)
  112
- Get(StatusAreaState)
  112
- Get(SystemDrive)
  113
- Get(SystemIPAddress)
  114
- Get(SystemLanguage)
  114
- Get(SystemNICAddress)
  115
- Get(SystemPlatform)
  115
- Get(SystemVersion)
  116
- Get(TextRulerVisible)
  116
- Get(TotalRecordCount)
  117
- Get(UserCount)
  117
- Get(UserName)
  118
- Get(UseSystemFormatsState)
  119
- Get(WindowContentHeight)
  119
- Get(WindowContentWidth)
  120
- Get(WindowDesktopHeight)
  120
- Get(WindowDesktopWidth)
  121
- Get(WindowHeight)
  122
- Get(WindowLeft)
  122
- Get(WindowMode)
  123
- Get(WindowName)
  123
- Get(WindowTop)
  124
- Get(WindowVisible)
  125
- Get(WindowWidth)
  125
- Get(WindowZoomLevel)
  126
Chapter 8 Logical functions
127
- Case
  128
- Choose
  128
- Evaluate
  129
- EvaluationError
  131
- GetAsBoolean
  131
- GetField
  132
- GetLayoutObjectAttribute
  133
- GetNthRecord
  134
- If
  135
- IsEmpty
  136
- IsValid
  137
- IsValidExpression
  137
- Let
  138
- Lookup
  140
- LookupNext
  141
Chapter 9 Number functions
143
- Abs
  144
- Ceiling
  144
- Combination
  145
- Div
  145
- Exp
  146
- Factorial
  146
- Floor
  147
- Int
  147
- Lg
  148
- Ln
  149
- Log
  149
- Mod
  150
- Random
  150
- Round
  151
- SetPrecision
  151
- Sign
  152
- Sqrt
  153
- Truncate
  153
Chapter 10 Repeating functions
155
- Extend
  156
- GetRepetition
  156
- Last
  157
Chapter 11 Summary functions
159
- GetSummary
  160
Chapter 12 Text functions
161
- Exact
  163
- Filter
  164
- FilterValues
  164
- GetAsCSS
  165
- GetAsDate
  166
- GetAsNumber
  166
- GetAsSVG
  167
- GetAsText
  168
- GetAsTime
  168
- GetAsTimestamp
  169
- GetAsURLEncoded
  169
- GetValue
  170
- Hiragana
  171
- KanaHankaku
  171
- KanaZenkaku
  172
- KanjiNumeral
  172
- Katakana
  172
- Left
  173
- LeftValues
  173
- LeftWords
  174
- Length
  175
- Lower
  175
- Middle
  176
- MiddleValues
  176
- MiddleWords
  177
- NumToJText
  178
- PatternCount
  179
- Position
  179
- Proper
  180
- Quote
  181
- Replace
  181
- Right
  182
- RightValues
  182
- RightWords
  183
- RomanHankaku
  184
- RomanZenkaku
  184
- SerialIncrement
  185
- Substitute
  186
- Trim
  186
- TrimAll
  187
- Upper
  188
- ValueCount
  189
- WordCount
  189
Chapter 13 Text formatting functions
191
- RGB
  192
- TextColor
  192
- TextColorRemove
  193
- TextFont
  194
- TextFontRemove
  195
- TextFormatRemove
  196
- TextSize
  197
- TextSizeRemove
  197
- TextStyleAdd
  198
- TextStyleRemove
  199
Chapter 14 Time functions
201
- Hour
  202
- Minute
  202
- Seconds
  203
- Time
  203
Chapter 15 Timestamp functions
205
- Timestamp
  206
Chapter 16 Trigonometric functions
207
- Atan
  208
- Cos
  208
- Degrees
  209
- Pi
  209
- Radians
  210
- Sin
  210
- Tan
  211
Appendix A Glossary
213

User Manual (TJ447Z/A)

Size:

1.84 MB
Pages:

238
Language:

English