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

CryptGenerateSignature

CryptVerifySignature

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

DayOfWeek

DayOfYear

Month

MonthName

WeekOfYear

WeekOfYearFiscal

Year

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

GetAsCSS

GetAsDate

GetAsNumber

GetAsSVG

GetAsText

GetAsTime

GetAsTimestamp

GetAsURLEncoded

GetValue

Left

LeftValues

LeftWords

Length

Lower

Middle

MiddleValues

MiddleWords

PatternCount

Position

Proper

Quote

Replace

Right

RightValues

RightWords

SerialIncrement

SortValues

Substitute

Trim

TrimAll

UniqueValues

Upper

ValueCount

WordCount

Funciones diversas

GetFieldName

GetLayoutObjectAttribute

Funciones en japonés

DayNameJ

Furigana

Hiragana

KanaHankaku

KanaZenkaku

KanjiNumeral

Katakana

MonthNameJ

NumToJText

RomanHankaku

RomanZenkaku

YearName

Funciones financieras

FV

NPV

PMT

PV

Funciones Get

Get ( AccountExtendedPrivileges )

Get ( AccountGroupName )

Get ( AccountName )

Get ( AccountPrivilegeSetName )

Get ( AccountType )

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

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 JSON

JSONDeleteElement

JSONFormatElements

JSONGetElement

JSONListKeys

JSONListValues

JSONSetElement

Funciones lógicas

Case

Choose

Evaluate

EvaluationError

ExecuteSQL

GetAsBoolean

GetField

GetNthRecord

GetSummary

If

IsEmpty

IsValid

IsValidExpression

Let

Lookup

LookupNext

Self

SetRecursion

While

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

GetAVPlayerAttribute

GetSensor

Location

LocationValues

RangeBeacons

Funciones trigonométricas

Acos

Asin

Atan

Cos

Degrees

Pi

Radians

Sin

Tan