Page
|
|
|
Next Page |
|
| Contents > Functions reference (category list) |
|
|
|
|
| Functions reference (category list) | Switch to alphabetical list |
| Aggregate functions | Back to top |
 |
Average |
|
Count |
|
List |
|
Max |
|
Min |
|
StDev |
|
StDevP |
|
Sum |
|
Variance |
|
VarianceP |
| Date functions | Back to top |
|
Date |
|
Day |
|
DayName |
|
DayNameJ |
|
DayOfWeek |
|
DayOfYear |
|
Month |
|
MonthName |
|
MonthNameJ |
|
WeekOfYear |
|
WeekOfYearFiscal |
|
Year |
|
YearName |
| Design functions | Back to top |
|
DatabaseNames |
|
FieldBounds |
|
FieldComment |
|
FieldIDs |
|
FieldNames |
|
FieldRepetitions |
|
FieldStyle |
|
FieldType |
|
GetNextSerialValue |
|
LayoutIDs |
|
LayoutNames |
|
LayoutObjectNames |
|
RelationInfo |
|
ScriptIDs |
|
ScriptNames |
|
TableIDs |
|
TableNames |
|
ValueListIDs |
|
ValueListItems |
|
ValueListNames |
|
WindowNames |
| External functions | Back to top |
|
External |
| Financial functions | Back to top |
|
FV |
|
NPV |
|
PMT |
|
PV |
| Get functions | Back to top |
|
Get(AccountName) |
|
Get(ActiveFieldContents) |
|
Get(ActiveFieldName) |
|
Get(ActiveFieldTableName) |
|
Get(ActiveLayoutObjectName) |
|
Get(ActiveModifierKeys) |
|
Get(ActiveRepetitionNumber) |
|
Get(ActiveSelectionSize) |
|
Get(ActiveSelectionStart) |
|
Get(AllowAbortState) |
|
Get(AllowToolbarState) |
|
Get(ApplicationLanguage) |
|
Get(ApplicationVersion) |
|
Get(CalculationRepetitionNumber) |
|
Get(CurrentDate) |
|
Get(CurrentHostTimestamp) |
|
Get(CurrentTime) |
|
Get(CurrentTimestamp) |
|
Get(CustomMenuSetName) |
|
Get(DesktopPath) |
|
Get(DocumentsPath) |
|
Get(ErrorCaptureState) |
|
Get(ExtendedPrivileges) |
|
Get(FileMakerPath) |
|
Get(FileName) |
|
Get(FilePath) |
|
Get(FileSize) |
|
Get(FoundCount) |
|
Get(HighContrastColor) |
|
Get(HighContrastState) |
|
Get(HostApplicationVersion) |
|
Get(HostIPAddress) |
|
Get(HostName) |
|
Get(LastError) |
|
Get(LastMessageChoice) |
|
Get(LastODBCError) |
|
Get(LayoutAccess) |
|
Get(LayoutCount) |
|
Get(LayoutName) |
|
Get(LayoutNumber) |
|
Get(LayoutTableName) |
|
Get(LayoutViewState) |
|
Get(MultiUserState) |
|
Get(NetworkProtocol) |
|
Get(PageNumber) |
|
Get(PortalRowNumber) |
|
Get(PreferencesPath) |
|
Get(PrinterName) |
|
Get(PrivilegeSetName) |
|
Get(RecordAccess) |
|
Get(RecordID) |
|
Get(RecordModificationCount) |
|
Get(RecordNumber) |
|
Get(RecordOpenCount) |
|
Get(RecordOpenState) |
|
Get(RequestCount) |
|
Get(RequestOmitState) |
|
Get(ScreenDepth) |
|
Get(ScreenHeight) |
|
Get(ScreenWidth) |
|
Get(ScriptName) |
|
Get(ScriptParameter) |
|
Get(ScriptResult) |
|
Get(SortState) |
|
Get(StatusAreaState) |
|
Get(SystemDrive) |
|
Get(SystemIPAddress) |
|
Get(SystemLanguage) |
|
Get(SystemNICAddress) |
|
Get(SystemPlatform) |
|
Get(SystemVersion) |
|
Get(TemporaryPath) |
|
Get(TextRulerVisible) |
|
Get(TotalRecordCount) |
|
Get(UserCount) |
|
Get(UserName) |
|
Get(UseSystemFormatsState) |
|
Get(WindowContentHeight) |
|
Get(WindowContentWidth) |
|
Get(WindowDesktopHeight) |
|
Get(WindowDesktopWidth) |
|
Get(WindowHeight) |
|
Get(WindowLeft) |
|
Get(WindowMode) |
|
Get(WindowName) |
|
Get(WindowTop) |
|
Get(WindowVisible) |
|
Get(WindowWidth) |
|
Get(WindowZoomLevel) |
| Logical functions | Back to top |
|
Case |
|
Choose |
|
Evaluate |
|
EvaluationError |
|
GetAsBoolean |
|
GetField |
|
GetLayoutObjectAttribute |
|
GetNthRecord |
|
If |
|
IsEmpty |
|
IsValid |
|
IsValidExpression |
|
Let |
|
Lookup |
|
LookupNext |
|
Self |
| Number functions | Back to top |
|
Abs |
|
Ceiling |
|
Combination |
|
Div |
|
Exp |
|
Factorial |
|
Floor |
|
Int |
|
Lg |
|
Ln |
|
Log |
|
Mod |
|
Random |
|
Round |
|
SetPrecision |
|
Sign |
|
Sqrt |
|
Truncate |
| Repeating functions | Back to top |
|
Extend |
|
GetRepetition |
|
Last |
| Summary functions | Back to top |
|
GetSummary |
| Text functions | Back to top |
|
Exact |
|
Filter |
|
FilterValues |
|
GetAsCSS |
|
GetAsDate |
|
GetAsNumber |
|
GetAsSVG |
|
GetAsText |
|
GetAsTime |
|
GetAsTimestamp |
|
GetAsURLEncoded |
|
GetValue |
|
Hiragana |
|
KanaHankaku |
|
KanaZenkaku |
|
KanjiNumeral |
|
Katakana |
|
Left |
|
LeftValues |
|
LeftWords |
|
Length |
|
Lower |
|
Middle |
|
MiddleValues |
|
MiddleWords |
|
NumToJText |
|
PatternCount |
|
Position |
|
Proper |
|
Quote |
|
Replace |
|
Right |
|
RightValues |
|
RightWords |
|
RomanHankaku |
|
RomanZenkaku |
|
SerialIncrement |
|
Substitute |
|
Trim |
|
TrimAll |
|
Upper |
|
ValueCount |
|
WordCount |
| Text formatting functions | Back to top |
|
RGB |
|
TextColor |
|
TextColorRemove |
|
TextFont |
|
TextFontRemove |
|
TextFormatRemove |
|
TextSize |
|
TextSizeRemove |
|
TextStyleAdd |
|
TextStyleRemove |
| Time functions | Back to top |
|
Hour |
|
Minute |
|
Seconds |
|
Time |
| Timestamp functions | Back to top |
|
Timestamp |
| Trigonometric functions | Back to top |
|
Acos |
|
Asin |
|
Atan |
|
Cos |
|
Degrees |
|
Pi |
|
Radians |
|
Sin |
|
Tan |
|
|
| Contents > Functions reference (category list) |
|
|
Next Page |
|