Referência > Referência de funções > Referência de funções (lista de categorias)
 

Referência de funções (lista de categorias)

Funções de agregação

Average

Count

List

Max

Min

StDev

StDevP

Sum

Variance

VarianceP

Funções de carimbo de data/hora

Timestamp

Funções de Container

Base64Decode

Base64Encode

Base64EncodeRFC

CryptAuthCode

CryptDecrypt

CryptDecryptBase64

CryptDigest

CryptEncrypt

CryptEncryptBase64

CryptGenerateSignature

CryptVerifySignature

GetContainerAttribute

GetHeight

GetThumbnail

GetWidth

HexDecode

HexEncode

TextDecode

TextEncode

VerifyContainer

Funções de data

Date

Day

DayName

DayOfWeek

DayOfYear

Month

MonthName

WeekOfYear

WeekOfYearFiscal

Year

Funções de design

DatabaseNames

FieldBounds

FieldComment

FieldIDs

FieldNames

FieldRepetitions

FieldStyle

FieldType

GetNextSerialValue

LayoutIDs

LayoutNames

LayoutObjectNames

RelationInfo

ScriptIDs

ScriptNames

TableIDs

TableNames

ValueListIDs

ValueListItems

ValueListNames

WindowNames

Funções de formatação de texto

RGB

TextColor

TextColorRemove

TextFont

TextFontRemove

TextFormatRemove

TextSize

TextSizeRemove

TextStyleAdd

TextStyleRemove

Funções de horário

Hour

Minute

Seconds

Time

Funções de número

Abs

Ceiling

Combination

Div

Exp

Factorial

Floor

Int

Lg

Ln

Log

Mod

Random

Round

SetPrecision

Sign

Sqrt

Truncate

Funções de repetição

Extend

GetRepetition

Last

Funções 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

Funções diversas

GetFieldName

GetLayoutObjectAttribute

Funções do japonês

DayNameJ

Furigana

Hiragana

KanaHankaku

KanaZenkaku

KanjiNumeral

Katakana

MonthNameJ

NumToJText

RomanHankaku

RomanZenkaku

YearName

Funções financeiras

FV

NPV

PMT

PV

Funções 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)

Funções JSON

JSONDeleteElement

JSONFormatElements

JSONGetElement

JSONListKeys

JSONListValues

JSONSetElement

Funções lógicas

Case

Choose

Evaluate

EvaluationError

ExecuteSQL

GetAsBoolean

GetField

GetNthRecord

GetSummary

If

IsEmpty

IsValid

IsValidExpression

Let

Lookup

LookupNext

Self

SetRecursion

While

Funções móveis

GetAVPlayerAttribute

GetSensor

Location

LocationValues

RangeBeacons

Funções trigonométricas

Acos

Asin

Atan

Cos

Degrees

Pi

Radians

Sin

Tan