Referencia > Referencia de funciones > Referencia de funciones (lista de categorías)
 
Referencia de funciones (lista de categorías)
Funciones de agregación
Average
Count
List
Max
Min
StDev
StDevP
Sum
Variance
VarianceP
Funciones de campos contenedor
Base64Decode
Base64Encode
Base64EncodeRFC
CryptAuthCode
CryptDecrypt
CryptDecryptBase64
CryptDigest
CryptEncrypt
CryptEncryptBase64
GetContainerAttribute
GetHeight
GetThumbnail
GetWidth
HexDecode
HexEncode
TextDecode
TextEncode
VerifyContainer
Funciones de diseño
DatabaseNames
FieldBounds
FieldComment
FieldIDs
FieldNames
FieldRepetitions
FieldStyle
FieldType
GetNextSerialValue
LayoutIDs
LayoutNames
LayoutObjectNames
RelationInfo
ScriptIDs
ScriptNames
TableIDs
TableNames
ValueListIDs
ValueListItems
ValueListNames
WindowNames
Funciones de fecha
Date
Day
DayName
DayNameJ
DayOfWeek
DayOfYear
Month
MonthName
MonthNameJ
WeekOfYear
WeekOfYearFiscal
Year
YearName
Funciones de fecha y hora
Timestamp
Funciones de formato de texto
RGB
TextColor
TextColorRemove
TextFont
TextFontRemove
TextFormatRemove
TextSize
TextSizeRemove
TextStyleAdd
TextStyleRemove
Funciones de hora
Hour
Minute
Seconds
Time
Funciones de repetición
Extend
GetRepetition
Last
Funciones de texto
Char
Code
Exact
Filter
FilterValues
Furigana
GetAsCSS
GetAsDate
GetAsNumber
GetAsSVG
GetAsText
GetAsTime
GetAsTimestamp
GetAsURLEncoded
GetValue
Hiragana
JSONDeleteElement
JSONFormatElements
JSONGetElement
JSONListKeys
JSONListValues
JSONSetElement
KanaHankaku
KanaZenkaku
KanjiNumeral
Katakana
Left
LeftValues
LeftWords
Length
Lower
Middle
MiddleValues
MiddleWords
NumToJText
PatternCount
Position
Proper
Quote
Replace
Right
RightValues
RightWords
RomanHankaku
RomanZenkaku
SerialIncrement
SortValues
Substitute
Trim
TrimAll
UniqueValues
Upper
ValueCount
WordCount
Funciones financieras
FV
NPV
PMT
PV
Funciones Get
Get ( AccountExtendedPrivileges )
Get ( AccountGroupName )
Get ( AccountName )
Get ( AccountPrivilegeSetName )
Get ( ActiveFieldContents )
Get ( ActiveFieldName )
Get ( ActiveFieldTableName )
Get ( ActiveLayoutObjectName )
Get ( ActiveModifierKeys )
Get ( ActivePortalRowNumber )
Get ( ActiveRepetitionNumber )
Get ( ActiveSelectionSize )
Get ( ActiveSelectionStart )
Get ( AllowAbortState )
Get ( AllowFormattingBarState )
Get ( ApplicationArchitecture )
Get ( ApplicationLanguage )
Get ( ApplicationVersion )
Get ( CalculationRepetitionNumber )
Get ( ConnectionAttributes )
Get ( ConnectionState )
Get ( CurrentDate )
Get ( CurrentExtendedPrivileges )
Get ( CurrentHostTimestamp )
Get ( CurrentPrivilegeSetName )
Get ( CurrentTime )
Get ( CurrentTimestamp )
Get ( CurrentTimeUTCMilliseconds )
Get ( CustomMenuSetName )
Get ( DesktopPath )
Get ( Device )
Get ( DocumentsPath )
Get ( DocumentsPathListing )
Get ( EncryptionState )
Get ( ErrorCaptureState )
Get ( FileMakerPath )
Get ( FileName )
Get ( FilePath )
Get ( FileSize )
Get ( FoundCount )
Get ( HighContrastColor )
Get ( HighContrastState )
Get ( HostApplicationVersion )
Get ( HostIPAddress )
Get ( HostName )
Get ( InstalledFMPlugins )
Get ( LastError )
Get ( LastExternalErrorDetail )
Get ( LastMessageChoice )
Get ( LayoutAccess )
Get ( LayoutCount )
Get ( LayoutName )
Get ( LayoutNumber )
Get ( LayoutTableName )
Get ( LayoutViewState )
Get ( MenubarState )
Get ( ModifiedFields )
Get ( MultiUserState )
Get ( NetworkProtocol )
Get ( NetworkType )
Get ( PageNumber )
Get ( PersistentID )
Get ( PreferencesPath )
Get ( PrinterName )
Get ( QuickFindText )
Get ( RecordAccess )
Get ( RecordID )
Get ( RecordModificationCount )
Get ( RecordNumber )
Get ( RecordOpenCount )
Get ( RecordOpenState )
Get ( RegionMonitorEvents )
Get ( RequestCount )
Get ( RequestOmitState )
Get ( ScreenDepth )
Get ( ScreenHeight )
Get ( ScreenScaleFactor )
Get ( ScreenWidth )
Get ( ScriptAnimationState )
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 ( TouchKeyboardState )
Get ( TriggerCurrentPanel )
Get ( TriggerExternalEvent )
Get ( TriggerGestureInfo )
Get ( TriggerKeystroke )
Get ( TriggerModifierKeys )
Get ( TriggerTargetPanel )
Get ( UserCount )
Get ( UserName )
Get ( UseSystemFormatsState )
Get ( UUID )
Get ( WindowContentHeight )
Get ( WindowContentWidth )
Get ( WindowDesktopHeight )
Get ( WindowDesktopWidth )
Get ( WindowHeight )
Get ( WindowLeft )
Get ( WindowMode )
Get ( WindowName )
Get ( WindowOrientation )
Get ( WindowStyle )
Get ( WindowTop )
Get ( WindowVisible )
Get ( WindowWidth )
Get ( WindowZoomLevel )
Funciones lógicas
Case
Choose
Evaluate
EvaluationError
ExecuteSQL
GetAsBoolean
GetAVPlayerAttribute
GetField
GetFieldName
GetLayoutObjectAttribute
GetNthRecord
If
IsEmpty
IsValid
IsValidExpression
Let
Lookup
LookupNext
Self
Funciones numéricas
Abs
Ceiling
Combination
Div
Exp
Factorial
Floor
Int
Lg
Ln
Log
Mod
Random
Round
SetPrecision
Sign
Sqrt
Truncate
Funciones para dispositivos móviles
Location
LocationValues
RangeBeacons
Funciones de sumario
GetSummary
Funciones trigonométricas
Acos
Asin
Atan
Cos
Degrees
Pi
Radians
Sin
Tan