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 sumario

GetSummary

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 ( ActiveRecordNumber )

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 ( UUIDNumber )

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

GetSensor

Location

LocationValues

RangeBeacons

Funciones trigonométricas

Acos

Asin

Atan

Cos

Degrees

Pi

Radians

Sin

Tan