Array(14)
a!flattena!flatten() Function
a!updatea!update() Function
appendReturns the resulting array.
indexReturns the data.
insertReturns the resulting array.
joinarrayReturns result.
ldropReturns the resulting array.
lengthReturns the number of elements in an array.
rdropReturns the resulting array.
removeReturns the resulting array.
reverseReturns an array in reverse order.
updatearrayReturns the resulting array.
whereReturns the indexes where the values in the input array ar.
wherecontainsReturns an array of indexes that indicate the position of .
Base Conversion(12)
bin2decReturns result.
bin2hexReturns result.
bin2octReturns result.
dec2binReturns result.
dec2hexReturns result.
dec2octReturns result.
hex2binReturns result.
hex2decReturns result.
hex2octReturns result.
oct2binReturns result.
oct2decReturns result.
oct2hexReturns result.
Conversion(18)
displayvalueReturns either the value at the same index or a default va.
externalizeReturns result.
internalizeReturns result.
tobooleanReturns result.
tocommunityReturns result.
todateReturns result.
todatetimeReturns result.
todecimalReturns result.
todocumentReturns result.
toemailaddressReturns result.
toemailrecipientReturns result.
tofolderReturns result.
tointegerReturns result.
tointervaldsReturns result.
toknowledgecenterReturns result.
tostringReturns result.
totimeReturns result.
touniformstringReturns result.
Data & Query(5)
a!gridColumnDisplays a column of data as read-only text, links, images, rich text, buttons, tags, record actions, or progress bars within the Read-Only Grid Component.
a!gridFieldDisplays a grid of data as rich text, links, images, buttons, tags, record actions, or progress bars.
a!recordActionFieldDisplays a list of record actions with a consistent style.
a!recordActionItemDisplays a record action defined within a record action field or a read-only grid that uses a record type as the data source.
a!recordLinkDefines a link to a record view.
Date & Time(37)
a!addDateTimea!addDateTime() Function
a!subtractDateTimea!subtractDateTime() Function
calisworkdayReturns whether or not the given Date and Time is a work d.
calisworktimeReturns whether or not the given Date and Time is within w.
calworkdaysReturns the actual number of work days between two Date an.
calworkhoursReturns the actual number of work hours between two given .
dateReturns result.
datetimeReturns result.
datevalueReturns result.
dayReturns the day of the month from the date specified.
dayofyearReturns the day number within the year.
days360Returns the number of days between two dates, based on a 3.
daysinmonthReturns the number of days in the given month in the given.
edateReturns the date that is the number of months before or af.
eomonthReturns the date for the last day of the month that is the.
gmtReturns result.
hourReturns the hour from the time specified.
intervaldsReturns result.
isleapyearReturns a Boolean value for whether the given year is a le.
lastndaysReturns a Boolean value for whether the given date is with.
localReturns result.
milliReturns the millisecond portion of a timestamp or the deci.
minuteReturns the minute from the time specified.
monthReturns the month from the specified date.
networkdaysReturns the number of working days between two specified d.
nowReturns the current Date and Time as a serial number.
secondReturns the seconds from the specified time.
timeReturns result.
timevalueReturns result.
timezoneReturns the default offset in minutes from GMT for the cur.
timezoneidReturns the time zone ID for the current context.
todayReturns the current day in GMT.
weekdayReturns the day of the week of the specified date.
weeknumReturns the week number within the year for the given date.
workdayReturns the date the given number of workdays before or af.
yearReturns the year for the date specified.
yearfracReturns result.
Informational(19)
a!automationIda!automationId Function
a!automationTypea!automationType Function
a!defaultValuea!defaultValue Function
a!isNotNullOrEmptya!isNotNullOrEmpty() Function
a!keysa!keys Function
a!listTypea!listType() Function
a!submittedOfflineTaskIdsa!submittedOfflineTaskIds() Function
castReturns result.
errorReturns a value.
infinityReturns result.
isinfiniteReturns result.
isnegativeinfinityReturns result.
isnullReturns true if value is null, false otherwise.
ispositiveinfinityReturns result.
nanReturns result.
nullReturns a null value.
runtimetypeofReturns the numerical representation of an Appian system d.
typenameReturns the type name of a given type number.
typeofReturns the type number of a given value.
Interface Components(118)
a!authorizationLinkDefines a link to authorize a user for a connected system that uses OAuth 2.0 Authorization Code grant.
a!barOverlayDisplays a horizontal bar overlay for use in billboard layout.
a!cardChoiceFieldtemplate See also: Cards Layout
a!cardTemplateBarTextJustifiedDisplays a bar card template with an icon, primary text, and secondary text justified on either side of the card.
a!cardTemplateBarTextStackedDisplays a bar card template with an icon and stacked primary text and secondary text.
a!cardTemplateTileDisplays a tile card template with a stacked icon, primary text, and secondary text.
a!chatFieldDisplays an interactive chat interface that lets users send and receive messages in real time.
a!colorSchemeCustomA custom list of colors to apply to any chart.
a!columnOverlayDisplays a vertical column overlay for use in billboard layout.
a!dataFabricChatFieldCreates a chatbot for chatting with your data fabric.
a!documentAndFolderBrowserFieldColumnsDisplays the contents of a folder and allows users to navigate through a series of folders to find and select a folder or document.
a!documentBrowserFieldColumnsDisplays the contents of a folder and allows users to navigate through a series of folders to find and select a document.
a!documentImageDisplays an image of a document.
a!documentsChatFieldCreates a chat for users to ask questions about a curated set of documents.
a!eventDataThis function determines the event data to display for a single record type in the Event History List component.
a!eventHistoryListFieldDisplays the event history for one or more record types.
a!folderBrowserFieldColumnsDisplays the contents of a folder and allows users to navigate through a series of folders to find and select a folder.
a!fullOverlayDisplays an overlay that covers the entire billboard layout.
a!gaugeFractionDisplays text in a fractional format for use within the gauge field primaryText parameter.
a!gaugeIconDisplays an icon for use within the gauge field primaryText parameter.
a!gaugePercentageDisplays the configured percentage of the gauge as an integer for use within the gauge field primaryText parameter.
a!groupBrowserFieldColumnsDisplays group membership structure in columns.
a!groupingDefines a grouping for the Query Record Type function.
a!headerTemplateFullA title bar template that displays a prominent header with a background color at the top of the form or wizard.
a!headerTemplateImageA title bar template that displays a prominent header with a background color at the top of the form or wizard.
a!headerTemplateSimpleA title bar template that displays a simple text header at the top of the form or wizard.
a!hierarchyBrowserFieldColumnsDisplays hierarchical data in the form of drillable columns with selectable cells.
a!hierarchyBrowserFieldColumnsNodeReturns a Browser Field Columns Node, used in the Node Configurations parameter of the Columns Browser to determine how items in the hierarchy are displayed.
a!hierarchyBrowserFieldTreeDisplays hierarchical data in the form of drillable tree.
a!hierarchyBrowserFieldTreeNodeReturns a Tree Node, used in the Node Configurations parameter of the Tree Browser Component to determine how items in the hierarchy are displayed.
a!horizontalLineDisplays a horizontal line.
a!messageBanner. If the content wouldn't be considered a status message, use "DISPLAY_ONLY" for the announceBehavior parameter.
a!pane. See also: Pane Layout Responsive Design
a!recordsChatFieldCreates a chatbot for chatting on a record summary view.
a!reportLinkDefines a link to a Tempo report or a task report.
a!sidebarTemplateA title bar template that displays a sidebar in a form or wizard.
a!sideBySideItemDisplays one or more components within a side by side layout.
a!signatureFieldin the saveInto parameter of a submit button or link.
a!tabItemDisplays the components and layouts of a single tab within the tab layout.
a!timeDisplayField, use a date & time component.
a!toggleFieldDisplays a toggle that saves a true or false value.
a!userAndGroupBrowserFieldColumnsDisplays group membership structure in columns.
a!userBrowserFieldColumnsDisplays group membership structure in columns.
a!userImageDisplays a user's profile photo for use in an image, rich text display, tree browser, billboard layout component, or in a grid column component in a Read-Only Grid.
a!validationMessagefunction
a!videoFieldCreates a Video component.
a!webVideoDisplays a video from the web for use in a video component.
a!wizardStepDisplays the components and layouts of a single wizard step within the Wizard Layout.
a!buttonWidgetActionDisplays a button that can conditionally be used to submit a form.
a!documentDownloadLinkActionDefines a link used to download a document.
a!dynamicLinkActionDefines a link that triggers updates to one or more variables.
a!linkFieldActionDisplays one or more links of any link type, including document links, task links, record view links, external web page links, and dynamic links that update variables.
a!newsEntryLinkActionDefines a link to news entries.
a!processTaskLinkActionDefines a link to a process task.
a!safeLinkActionDefines a link to an external web page.
a!startProcessLinkActionDefines a link to start a process and navigates the user through any initial chained forms.
a!submitLinkActionDefines a link to trigger form submission.
a!userRecordLinkActionDefines a link to a user record.
a!areaChartConfigChartsContains configuration for how to display data in an area chart.
a!areaChartFieldChartsDisplays a series of numerical data as points connected by lines with the area between the line and axis shaded.
a!barChartConfigChartsContains configuration for how to display data in a bar chart.
a!barChartFieldChartsDisplays numerical data as horizontal bars.
a!chartReferenceLineChartsContains the reference line value for each threshold that is defined on a column, bar, line, or area chart.
a!chartSeriesChartsDefines a series of data for a bar, column, line, area, or pie chart.
a!columnChartConfigChartsContains configuration for how to display data in a column chart.
a!columnChartFieldChartsDisplays numerical data as vertical bars.
a!gaugeFieldChartsDisplays a completion percentage in a circular style similar to the Progress Bar.
a!kpiFieldChartsDisplays a key performance indicator that can be configured using a record type as the source.
a!lineChartConfigChartsContains configuration for how to display data in a line chart.
a!lineChartFieldChartsDisplays a series of numerical data as points connected by lines.
a!orgChartFieldChartsDisplays the organizational structure of users within Appian based on the users’ Supervisor field values.
a!pieChartConfigChartsContains configuration for how to display data in a pie chart.
a!pieChartFieldChartsDisplays numerical data as slices of a single circle.
a!scatterChartFieldChartsDisplays the relationship between two numerical data points.
a!barcodeFieldDisplayDisplays and allows entry of a barcode value using a barcode scanner or manual input.
a!documentViewerFieldDisplayDisplays a document from document management on an interface.
a!headingFieldDisplayThe headings component is a way to intuitively structure and easily organize your interface with both visual and non-visual indicators to help all users quickly understand your content.
a!imageFieldDisplayDisplays an image from document management or the web.
a!milestoneFieldDisplayDisplays the completed, current, and future steps of a process or sequence, such as a user's current step in a wizard or the current state of a business process.
a!progressBarFieldDisplayDisplays a completion percentage, such as receiving all the necessary approval tasks, completing a certain number of on-boarding processes, or completing a single process.
a!richTextBulletedListDisplayDisplays a bulleted list within a rich text display component.
a!richTextDisplayFieldDisplayDisplays text in variety of styles, including bold, italics, underline, links, and numbered and bulleted lists.
a!richTextIconDisplayDisplays an icon for use in rich text display.
a!richTextImageDisplayDisplays an icon-sized image within a rich text display component.
a!richTextItemDisplayDisplays a text item within a rich text display component.
a!richTextListItemDisplayDisplays a nested list within a bulleted or numbered list in a rich text display component.
a!richTextNumberedListDisplayDisplays a numbered list within a rich text display component.
a!stampFieldDisplayDisplays an icon and/or text on a colored circular background.
a!tagFieldDisplayDisplays a list of short text labels with colored background to highlight important attributes.
a!tagItemDisplayDisplays a short text label with colored background for use with a!tagField.
a!webContentFieldDisplayDisplays content inline from an external source.
a!webImageDisplayDisplays an image from the web for use in an image, rich text display, tree browser, or billboard layout component, or in a grid column component in a read-only grid.
a!booleanCheckboxFieldInputDisplays a single checkbox that saves a true or false value.
a!checkboxFieldInputDisplays a limited set of choices from which the user may select none, one, or many items and saves the values of the selected choices.
a!checkboxFieldByIndexInputDisplays a limited set of choices from which the user may select none, one, or many items and saves the indices of the selected choices.
a!dateFieldInput, use a time component.
a!dateTimeFieldInput, use a time component.
a!dropdownFieldInputDisplays a list of choices for the user to select one item and saves a value based on the selected choice.
a!dropdownFieldByIndexInputDisplays a list of choices for the user to select one item and saves the index of the selected choice.
a!encryptedTextFieldInputAllows entry of a single line of text that is encrypted when saved into a variable.
a!fileUploadFieldInputin the saveInto parameter of a submit button or link.
a!floatingPointFieldInputDisplays and allows entry of a single decimal number, stored with a floating point representation.
a!integerFieldInputDisplays and allows entry of a single integer number.
a!multipleDropdownFieldInputDisplays a list of choices for the user to select multiple items and saves values based on the selected choices.
a!multipleDropdownFieldByIndexInputDisplays a list of choices for the user to select multiple items and saves the indices of the selected choices.
a!paragraphFieldInputDisplays and allows entry of multiple lines of text.
a!pickerFieldCustomInputDisplays an autocompleting input for the selection of one or more items from an arbitrary data set.
a!pickerFieldDocumentsInputDisplays an autocompleting input for the selection of one or more documents.
a!pickerFieldDocumentsAndFoldersInputDisplays an autocompleting input for the selection of one or more documents or folders.
a!pickerFieldFoldersInputDisplays an autocompleting input for selecting one or more folders.
a!pickerFieldGroupsInputDisplays an autocompleting input for selecting one or more groups.
a!pickerFieldRecordsInputDisplays an autocompleting input for the selection of one or more records, filtered by a single record type.
a!pickerFieldUsersInputDisplays an autocompleting input for the selection of one or more users.
a!pickerFieldUsersAndGroupsInputDisplays an autocompleting input for selecting one or more users or groups.
a!radioButtonFieldInputDisplays a limited set of choices from which the user must select one item and saves a value based on the selected choice.
a!radioButtonFieldByIndexInputDisplays a limited set of choices from which the user must select one item and saves the index of the selected choice.
a!styledTextEditorFieldInputAdditionally, it also supports the following Markdown formatting: Format Markdown Formatting Example Returns Bold Double asterisks ** or underscores __ **text** or __text__ text Italics Single asterisk * or underscore _...
a!textFieldInputDisplays and allows entry of a single line of text.
Layout Components(19)
a!billboardLayoutDisplays a background color, image, or video with optional overlay content.
a!boxLayoutDisplays any arrangement of layouts and components within a box on an interface.
a!buttonArrayLayoutDisplays a list of buttons in the order they are specified.
a!buttonLayoutDisplays a list of buttons grouped by prominence.
a!cardGroupLayoutDisplays an arrangement of cards, with the same width and height.
a!cardLayoutDisplays any arrangement of layouts and components within a card on an interface.
a!columnLayoutDisplays a column that can be used within the columns layout.
a!columnsLayoutDisplays any number of columns alongside each other.
a!formLayoutDisplays any arrangement of layouts and components beneath a header and above buttons.
a!gridLayoutDisplays a tabular layout of SAIL components to provide quick inline editing of fields.
a!gridLayoutColumnConfigDefines a column configuration for use in an Editable Grid.
a!gridLayoutHeaderCellDefines a column header for use in an Editable Grid.
a!gridRowLayoutDisplays a row of components within an editable grid.
a!headerContentLayoutDisplays any arrangement of layouts and components beneath a billboard or card header that is flush with the edge of the page.
a!paneLayoutDisplays two or three vertical panes, each with independent scrolling.
a!sectionLayoutDisplays any arrangement of layouts and components beneath a section title on an interface.
a!sideBySideLayoutDisplays components alongside each other.
a!tabLayoutto define each tab.
a!wizardLayoutto define each step in the wizard.
Logical(8)
a!matcha!match() Function
andReturns true if all inputs are true.
chooseReturns the result.
falseReturns the Boolean value false.
ifReturns valueIfTrue if condition returns true.
notReturns different results if the logical statement returns.
orReturns true if any inputs are true.
trueReturns the Boolean value true.
Looping(9)
a!forEacha!forEach() Function
allReturns either true or false for each item in list, asks t.
anyReturns either true or false for each item in list by aski.
applyReturns result.
filterReturns any items for which the returned value is true.
mergeReturns result.
noneReturns either true or false for each item in list by aski.
reduceReturns the value of the last computation.
rejectReturns all remaining items.
Mathematical(32)
a!distanceBetweena!distanceBetween() Function
absReturns the absolute value.
ceilingReturns result.
combinReturns result.
eReturns the value of e.
enumerateReturns a list of integer numbers from 0 through n.
evenReturns result.
expReturns e raised to the specified power.
factReturns a decimal even though the factorial is an integer.
factdoubleReturns a decimal even though the factorial is an integer.
floorReturns result.
intReturns result.
lnReturns the natural logarithm of the specified number, whi.
logReturns the logarithm of the number using the specified ba.
modReturns the remainder of dividend when divided by the divi.
mroundReturns result.
multinomialReturns result.
oddReturns result.
piReturns the value of pi.
powerReturns the base number raised to the specified exponent.
productReturns the product of the specified numbers.
quotientReturns the quotient when numerator is divided by the deno.
randReturns a random number between 0 and 1 based on an even p.
roundReturns result.
rounddownReturns result.
roundupReturns result.
signReturns result.
sqrtReturns the square root.
sqrtpiReturns the square root of the product.
sumReturns the sum of the specified numbers.
sumsqReturns the sum of the squares.
truncReturns result.
People(17)
a!doesGroupExista!doesGroupExist() Function
a!groupMembersa!groupMembers() Function
a!groupsByNamea!groupsByName() Function
a!groupsByTypea!groupsByType() Function
a!groupsForUsera!groupsForUser() Function
a!isUserMemberOfGroupa!isUserMemberOfGroup() Function
getdistinctusersReturns result.
getgroupattributeReturns result.
groupReturns information for group.
isusermemberofgroup_21r2isusermemberofgroup_21r2 Function
isusernametakenReturns result.
loggedInUserReturns the current user logged in to the application.
supervisorReturns the supervisor of the user if they have one.
togroupReturns result.
topeopleReturns result.
touserReturns result.
userReturns information for a user.
Records(10)
a!customFieldConcatCustom Record Fieldsa!customFieldConcat() Function
a!customFieldConditionCustom Record Fieldsa!customFieldCondition() Function
a!customFieldDateDiffCustom Record Fieldsa!customFieldDateDiff() Function
a!customFieldDefaultValueCustom Record Fieldsa!customFieldDefaultValue() Function
a!customFieldDivideCustom Record Fieldsa!customFieldDivide() Function
a!customFieldLogicalExpressionCustom Record Fieldsa!customFieldLogicalExpression() Function
a!customFieldMatchCustom Record Fieldsa!customFieldMatch() Function
a!customFieldMultiplyCustom Record Fieldsa!customFieldMultiply() Function
a!customFieldSubtractCustom Record Fieldsa!customFieldSubtract() Function
a!customFieldSumCustom Record Fieldsa!customFieldSum() Function
Scripting(60)
a!aggregationFieldsa!aggregationFields() Function
a!isNativeMobilea!isNativeMobile() Function
a!isPageWidtha!isPageWidth() Function
a!portalUrlWithLocalea!portalUrlWithLocale() Function
a!recordTypePropertiesa!recordTypeProperties() Function
a!urlForPortala!urlForPortal() Function
a!urlForRecorda!urlForRecord() Function
a!urlForSitea!urlForSite() Function
a!urlForTaska!urlfortask() Function
averagetaskcompletiontimeforprocessmodelReturns the average elapsed time in days between task assi.
averagetasklagtimeforprocessmodelReturns the average elapsed time in days between task assi.
averagetaskworktimeforprocessmodelReturns the average elapsed time in days between task acce.
communityReturns the properties of a given community.
datetextReturns its string representation using given format.
documentReturns property information for a document.
folderReturns a property of the requested folder.
isInDaylightSavingTimeReturns whether the given date and timezone are in dayligh.
knowledgecenterReturns the properties of a knowledge center.
numontimeprocessesforprocessmodelReturns result.
numontimetasksforprocessmodelReturns the number of tasks in process instances of the sp.
numoverdueprocessesforprocessmodelReturns the number of active and completed processes for t.
numoverduetasksforprocessmodelReturns the number of tasks in both active and completed p.
numprocessesforprocessmodelforstatusReturns the number of process instances with the specified.
numtasksforprocessmodelforstatusReturns the number of tasks with the specified status in p.
offsetFromGMTReturns the offset.
propertyReturns result.
repeatReturns a list with the input repeated a specified number .
todatasubsetReturns a DataSubset value with a subset of the array in a.
topaginginfoReturns a PagingInfo value for use with the todatasubset.
torecordReturns result.
toxmlReturns result.
urlForRecord_23r4urlforrecord_23r4 Function
urlwithparametersReturns result.
userdateReturns result.
userdatetimeReturns result.
userdatevalueReturns result.
userdayReturns the day of the month from the date or datetime spe.
userdayofyearReturns the number of day within in a specified date.
userdaysinmonthReturns the number of days in a that month.
useredateReturns the date that is the number of months before or af.
usereomonthReturns the date for the last day of the month that is the.
userisleapyearReturns result.
userlocaleReturns the preferred locale of the given user or the site.
usermonthReturns the month from the specified date or datetime in t.
usertimezoneReturns the site primary timezone if the application is co.
userweekdayReturns the day of the week of the specified date or datet.
userweeknumReturns the week number within the year for the given date.
useryearReturns the year from the date or datetime specified in th.
webservicequeryReturns result.
webservicewriteReturns a Writer that can be used as the setter of a varia.
xpathdocumentReturns result.
xpathsnippetReturns result.
a!asyncVariableEvaluationa!asyncVariable() Function
a!controlPanelRecordsEvaluationa!controlPanelRecords Function
a!localVariablesEvaluationa!localVariables() Function
a!refreshVariableEvaluationa!refreshVariable() Function
a!saveEvaluationa!save() Function
bindEvaluationReturns a writer.
loadEvaluationReturns result.
withEvaluationReturns result.
Set(5)
containsReturns result.
differenceReturns the values in array1 and not in array2.
intersectionReturns only those elements that appear in all of the give.
symmetricdifferenceReturns the values from two integer arrays that are not in.
unionReturns all unique elements from the given arrays.
Statistical(18)
avedevReturns the average deviation of the specified number.
averageReturns the average of the specified number.
countReturns the number items in all arrays passed to the funct.
frequencyReturns result.
gcdReturns the greatest common denominator of the specified n.
geomeanReturns the geometric mean of the specified number.
harmeanReturns the harmonic mean of the specified number.
lcmReturns the least common multiple of the specified non.
lookupReturns location of data within multiple values, or valueI.
maxReturns the maximum of the specified number.
medianReturns the median of the specified number.
minReturns the minimum of the specified number.
modeReturns the mode of the specified number.
rankReturns an integer representing the rank of the number in .
stdevReturns the standard deviation of the specified number.
stdevpReturns the standard deviation of the specified number.
varReturns the variance of the specified number.
varpReturns the variance of the specified number.
System(81)
a!applyComponentsa!applyComponents() Function
a!applyValidationsa!applyValidations Function
a!callLanguageModela!callLanguageModel() Function
a!controlPanelRecordHierarchyMetadataa!controlPanelRecordHierarchyMetadata Function
a!dataSubseta!dataSubset() Function
a!deploymenta!deployment() Function
a!documentFolderForRecordTypea!documentFolderForRecordType() Function
a!doesUserHaveAccessa!doesUserHaveAccess() Function
a!endsWitha!endsWith Function
a!entityDataa!entityData() Function
a!entityDataIdentifiersa!entityDataIdentifiers() Function
a!executeStoredProcedureForQuerya!executeStoredProcedureForQuery() Function
a!fromJsona!fromJson() Function
a!fromJson_19r2a!fromJson_19r2() Function
a!getDataSourceForPlugina!getDataSourceForPlugin() Function
a!httpResponsea!httpResponse() Function
a!httpResponse_17r4a!httpResponse_17r4() Function
a!iconIndicatora!iconIndicator() Function
a!iconNewsEventa!iconNewsEvent() Function
a!integrationErrora!integrationError() Function
a!isBetweena!isBetween Function
a!isInTexta!isInText Function
a!jsonPatha!jsonPath() Function
a!latestHealthChecka!latestHealthCheck() Function
a!listViewItema!listViewItem() Function
a!mapa!map() Function
a!pageResponsea!pageResponse() Function
a!pagingInfoa!pagingInfo() Function
a!querya!query() Function
a!queryAggregationa!queryAggregation() Function
a!queryAggregationColumna!queryAggregationColumn() Function
a!queryColumna!queryColumn() Function
a!queryEntitya!queryEntity() Function
a!queryEntity_18r3a!queryEntity_18r3() Function
a!queryEntity_22r2a!queryEntity_22r2() Function
a!queryFiltera!queryFilter() Function
a!queryLogicalExpressiona!queryLogicalExpression() Function
a!queryProcessAnalyticsa!queryProcessAnalytics() Function
a!queryRecordByIdentifiera!queryRecordByIdentifier() Function
a!queryRecordByIdentifier_25r2a!queryRecordByIdentifier_25r2() Function
a!queryRecordTypea!queryRecordType() Function
a!queryRecordType_20r4a!queryRecordType_20r4() Function
a!queryRecordType_24r4a!queryRecordType_24r4() Function
a!queryRecordType_25r2a!queryRecordType_25r2() Function
a!queryRecordType_25r3a!queryRecordType_25r3() Function
a!querySelectiona!querySelection() Function
a!recordDataa!recordData() Function
a!recordFilterChoicesa!recordFilterChoices() Function
a!recordFilterDateRangea!recordFilterDateRange() Function
a!recordFilterDateRange_20r2a!recordFilterDateRange_20r2 Function
a!recordFilterLista!recordFilterList() Function
a!recordFilterListOptiona!recordFilterListOption() Function
a!relatedRecordDataa!relatedRecordData() Function
a!selectionFieldsa!selectionFields() Function
a!sentimentScorea!sentimentScore() Function
a!sortInfoa!sortInfo() Function
a!startsWitha!startsWith Function
a!storedProcedureInputa!storedProcedureInput() Function
a!submitUploadedFilesa!submitUploadedFiles() Function
a!toJsona!toJson() Function
a!toJson_17r1a!toJson_17r1 Function
a!toRecordIdentifiera!toRecordIdentifier() Function
a!userRecordFilterLista!userRecordFilterList() Function
a!userRecordFilterList_22r3a!userRecordFilterList_22r3() Function
a!userRecordIdentifiera!userRecordIdentifier() Function
a!userRecordListViewItema!userRecordListViewItem() Function
a!userRecordListViewItem_22r3a!userRecordListViewItem_22r3() Function
a!chatMessageChatChat Message
a!httpAuthenticationBasicConnectora!httpAuthenticationBasic() Function
a!httpFormPartConnectora!httpFormPart() Function
a!httpHeaderConnectora!httpHeader() Function
a!httpQueryParameterConnectora!httpQueryParameter() Function
a!scsFieldConnectora!scsField() Function
a!verifyRecaptchaConnectora!verifyRecaptcha
a!wsConfigConnectora!wsConfig() Function
a!wsHttpCredentialsConnectora!wsHttpCredentials() Function
a!wsHttpHeaderFieldConnectora!wsHttpHeaderField() Function
a!wsUsernameTokenConnectora!wsUsernameToken() Function
a!wsUsernameTokenScsConnectora!wsUsernameTokenScs() Function
a!testRunResultForIdTestinga!testRunResultForId() Function
a!testRunStatusForIdTestinga!testRunStatusForId() Function
Text(51)
a!currencya!currency() Function
a!formatPhoneNumbera!formatPhoneNumber() Function
a!isPhoneNumbera!isPhoneNumber() Function
a!swissFranca!swissFranc() Function
centsReturns result.
charReturns result.
charatReturns the character at given index within specified stri.
cleanReturns the specified text, minus any characters not consi.
cleanwithReturns the specified text, minus any characters not in th.
codeReturns result.
concatReturns result.
currency_22r4Returns result.
exactReturns result.
extractReturns the value.
extractanswersReturns an array of strings that respond to the questions .
findReturns result.
fixedReturns it as text, with optional commas.
initialsReturns only the uppercase characters from within the give.
insertkeyReturns the provided text, wrapped with the specified deli.
insertkeyvalReturns the provided key.
insertquestionsReturns an array of questions with a.
keyvalReturns the value.
leftReturns a specified number of characters from the text, st.
leftbReturns a specified number of bytes from the text, startin.
lenReturns the length in characters of the text.
lenbReturns the length in bytes of the text.
likeReturns result.
lowerReturns result.
midReturns a substring from the middle of the specified text.
midbReturns a substring from the middle of the specified text.
padleftReturns result.
padrightReturns result.
properReturns result.
replaceReturns result.
replacebReturns result.
reptReturns the result.
resourceReturns result.
rightReturns a specified number of characters from the text, st.
searchReturns the one.
searchbReturns result.
soundexReturns the soundex code, used to render similar sounding .
splitReturns result.
stripReturns the provided text, minus any characters considered.
stripHtmlReturns result.
stripwithReturns the provided text, minus any characters on the lis.
substituteReturns result.
textReturns result.
toHtmlReturns result.
trimReturns result.
upperReturns result.
valueReturns result.
Trigonometry(14)
acosReturns the arccosine.
acoshReturns the hyperbolic arccosine.
asinReturns the arcsine.
asinhReturns the hyperbolic arcsine.
atanReturns the arctangent.
atanhReturns the hyperbolic arctangent.
cosReturns the cosine.
coshReturns the hyperbolic cosine.
degreesReturns result.
radiansReturns result.
sinReturns the sine.
sinhReturns the hyperbolic sine.
tanReturns the tangent.
tanhReturns the hyperbolic tangent.