This table is a searchable listing of all Appian functions, including those that render interface components or execute smart services. You can filter by function category and/or feature compatibility with offline mobile or custom record field expressions.
Category | Sub Category | CatDesc | SubCatDesc | Name | Description | Syntax | Example | Result | Compatibility |
---|---|---|---|---|---|---|---|---|---|
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!dashboardLayoutColumns() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!formLayoutColumns() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!sectionLayoutColumns() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | thread() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | message() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | a!flatten() | Converts an array that contains other arrays into an array of single items. |
a!flatten([array]) | a!flatten(merge({1,2},{11, 12})) | {1, 11, 2, 12} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | a!update() | Inserts new values or replaces existing values at the specified index or field name and returns the resulting updated data. |
a!update([data], [index], [value]) | a!update(a!map(a: 1, b: 2), "a", 5) | a!map(a: 5, b: 2) |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | append() | Appends a value or values to the given array, and returns the resulting array. |
append([array], [value]) | append({10, 20, 30}, 99) | {10, 20, 30, 99} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | index() | Returns the data[index] if it is valid or else returns the default value. |
index([data], [index], [default]) | index({10, 20, 30}, 2, 1) | 20 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | insert() | Inserts a value into the given array and returns the resulting array. |
insert([array], [value], [index]) | insert({10, 20, 30, 40}, 99, 1) | {99, 10, 20, 30, 40} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | joinarray() | Concatenates the elements of an array together into one string and inserts a string separator between each element. |
joinarray([array], [separator]) | joinarray({1, 2, 3, 4}, "|") | 1|2|3|4 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | ldrop() | Drops a given number of values from the left side of an array and returns the resulting array. |
ldrop([array], [number]) | ldrop({10, 20, 30}, 1) | {20, 30} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | length() | This function returns the number of elements in an array. |
length([array]) | length({10, 20, 30}) | 3 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | rdrop() | Drops a given number of values from the right side of an array, and returns the resulting array. |
rdrop([array], [number]) | rdrop({10, 20, 30}, 1) | {10, 20} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | remove() | Removes the value at a given index from an array, and returns the resulting array. |
remove([array], [index]) | remove({10, 20, 30}, 2) | {10, 30} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | reverse() | Returns an array in reverse order. |
reverse([array]) | reverse({10, 20, 30}) | {30, 20, 10} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | updatearray() | Inserts new values or modifies existing values at the specified index of a given array, and returns the resulting array. |
updatearray([array], [index], [value]) | updatearray({10, 20, 30}, 2, 99) | {10, 99, 30} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | where() | Returns the indices where the values in the input array are true. |
where([booleanArray], [default]) | where({true, false, true}) | {1, 3} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Array | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | wherecontains() | Receives one or more values and returns an array of indices that indicate the position of the values within the array. |
wherecontains([values], [array]) | wherecontains(20, {10, 20, 30}) | {2} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | bin2dec() | Converts a Binary number as text to a Decimal number. |
bin2dec([value]) | bin2dec(10000) | 16 |
~om+crf
Partially compatible Offline MobileCompatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | bin2hex() | Converts a Binary number as text to a Hex number as text. |
bin2hex([value], [place]) | bin2hex(1100100) | 64 |
~om+crf
Partially compatible Offline MobileCompatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | bin2oct() | Converts a Binary number as text to an Octal number as text. |
bin2oct([value], [place]) | bin2oct(1100100) | 144 |
~om+crf
Partially compatible Offline MobileCompatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | dec2bin() | Converts a Decimal number to a Binary number as text. |
dec2bin([value], [place]) | dec2bin(16) | 10000 |
~om+crf
Partially compatible Offline MobileCompatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | dec2hex() | Converts a Decimal number to a Binary number as text. |
dec2hex([value], [place]) | dec2hex(16) | 10 |
~om+crf
Partially compatible Offline MobileCompatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | dec2oct() | Converts a Decimal number to an Octal number as text. |
dec2oct([value], [place]) | dec2oct(16) | 20 |
~om+crf
Partially compatible Offline MobileCompatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | hex2bin() | Converts a Hex number as text to a Binary number as text. |
hex2bin([value], [place]) | hex2bin(64) | 1100100 |
~om+crf
Partially compatible Offline MobileCompatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | hex2dec() | Converts a Hex number as text to a Decimal number. |
hex2dec([value]) | hex2dec(10) | 16 |
~om+crf
Partially compatible Offline MobileCompatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | hex2oct() | Converts a Hex number as text to an Octal number as text. |
hex2oct([value], [place]) | hex2oct(64) | 144 |
~om+crf
Partially compatible Offline MobileCompatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | oct2bin() | Converts an Octal number as text to a Binary number as text. |
oct2bin([value], [place]) | oct2bin(144) | 1100100 |
~om+crf
Partially compatible Offline MobileCompatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | oct2dec() | Converts an Octal number as text to a Decimal number. |
oct2dec([value]) | oct2dec(20) | 16 |
~om+crf
Partially compatible Offline MobileCompatible Custom Record Field Expressions |
||
Base Conversion | Base ConversionUsed within expressions to convert values into other base number formats. | oct2hex() | Converts an Octal number as text to a Hex number as text. |
oct2hex([value], [place]) | oct2hex(144) | 64 |
~om+crf
Partially compatible Offline MobileCompatible Custom Record Field Expressions |
||
Connector | CMIS | ConnectorUsed to integrate Appian with popular enterprise software solutions. | CMISThe CMIS connector supports integrating with systems that implement the OASIS Content Management Interoperability Services standard. | a!cmiCopyDocumentFromAppian() | Copies an Appian document to a location in the CMIS target system, specified by the value of the objectId parameter. |
a!cmiCopyDocumentFromAppian([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [objectId], [properties], [appianDocument], [appianDocumentVersion], [appianDocumentAllowExpired]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | CMIS | ConnectorUsed to integrate Appian with popular enterprise software solutions. | CMISThe CMIS connector supports integrating with systems that implement the OASIS Content Management Interoperability Services standard. | a!cmiCopyDocumentToAppian() | Copies a document from the CMIS target system to Appian, creating a new version of an existing Appian document. |
a!cmiCopyDocumentToAppian([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [objectId], [appianDocument]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | CMIS | ConnectorUsed to integrate Appian with popular enterprise software solutions. | CMISThe CMIS connector supports integrating with systems that implement the OASIS Content Management Interoperability Services standard. | a!cmiCopyDocumentToAppianFolder() | Copies a document from the CMIS target system to an Appian folder, creating a new document. |
a!cmiCopyDocumentToAppianFolder([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [objectId], [appianFolder]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | CMIS | ConnectorUsed to integrate Appian with popular enterprise software solutions. | CMISThe CMIS connector supports integrating with systems that implement the OASIS Content Management Interoperability Services standard. | a!cmiCreateFolder() | Creates a folder in the CMIS target system. |
a!cmiCreateFolder([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [parentId], [properties]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | CMIS | ConnectorUsed to integrate Appian with popular enterprise software solutions. | CMISThe CMIS connector supports integrating with systems that implement the OASIS Content Management Interoperability Services standard. | a!cmiDelete() | Deletes an object in the CMIS target system. |
a!cmiDelete([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [objectId], [allVersions]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | CMIS | ConnectorUsed to integrate Appian with popular enterprise software solutions. | CMISThe CMIS connector supports integrating with systems that implement the OASIS Content Management Interoperability Services standard. | a!cmiGetFolderChildren() | Retrieves the children of the folder given as the |
a!cmiGetFolderChildren([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [folderId], [pagingInfo]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | CMIS | ConnectorUsed to integrate Appian with popular enterprise software solutions. | CMISThe CMIS connector supports integrating with systems that implement the OASIS Content Management Interoperability Services standard. | a!cmiGetObjectIdByPath() | Retrieves the object id of a CMIS object based on the value given as the |
a!cmiGetObjectIdByPath([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [path]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | CMIS | ConnectorUsed to integrate Appian with popular enterprise software solutions. | CMISThe CMIS connector supports integrating with systems that implement the OASIS Content Management Interoperability Services standard. | a!cmiGetProperties() | Retrieves the properties of the CMIS object given as the |
a!cmiGetProperties([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId], [objectId]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | CMIS | ConnectorUsed to integrate Appian with popular enterprise software solutions. | CMISThe CMIS connector supports integrating with systems that implement the OASIS Content Management Interoperability Services standard. | a!cmiGetRepoInfo() | Retrieves information about the target CMIS target system repository. |
a!cmiGetRepoInfo([scsExternalSystemKey], [usePerUserCredentials], [atomPubUrl], [repositoryId]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!dynAssociate() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!dynCreate() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!dynDelete() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!dynDisassociate() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!dynRetrieve() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!dynRetrieveMultiple() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!dynUpdate() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
Connector | Web Service Helper | ConnectorUsed to integrate Appian with popular enterprise software solutions. | Web Service Helper | a!httpAuthenticationBasic() | Creates an object that contains the information required to perform HTTP Basic authentication. |
a!httpAuthenticationBasic([username], [password], [preemptive]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | Web Service Helper | ConnectorUsed to integrate Appian with popular enterprise software solutions. | Web Service Helper | a!httpFormPart() | Creates an HTTP form part which can be passed in an integration’s multipart request body. |
a!httpFormPart([name], [contentType], [value]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | Web Service Helper | ConnectorUsed to integrate Appian with popular enterprise software solutions. | Web Service Helper | a!httpHeader() | Creates an HTTP header object which can be passed to an HTTP function. |
a!httpHeader([name], [value]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!httpQuery() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
Connector | Web Service Helper | ConnectorUsed to integrate Appian with popular enterprise software solutions. | Web Service Helper | a!httpQueryParameter() | Creates an HTTP query parameter object which can be passed to an HTTP function. |
a!httpQueryParameter([name], [value]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!httpWrite() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
Connector | Web Service Helper | ConnectorUsed to integrate Appian with popular enterprise software solutions. | Web Service Helper | a!scsField() | Creates an object which contains the information required to access data in the Secure Credentials Store. |
a!scsField([externalSystemKey], [fieldKey], [usePerUser]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | SAP | ConnectorUsed to integrate Appian with popular enterprise software solutions. | SAPThe SAP connector uses the SAP JCo 3.0 middleware library to connect to a SAP ERP systems release 3.1H or later. | a!sapBapiParameters() | Retrieves the list of parameters required to call the given SAP BAPI. |
a!sapBapiParameters([scsExternalSystemKey], [usePerUserCredentials], [hostname], [clientNumber], [systemNumber], [connectionProperties], [bapi]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | SAP | ConnectorUsed to integrate Appian with popular enterprise software solutions. | SAPThe SAP connector uses the SAP JCo 3.0 middleware library to connect to a SAP ERP systems release 3.1H or later. | a!sapInvoke() | Invokes the given BAPI, returning the result. |
a!sapInvoke([scsExternalSystemKey], [usePerUserCredentials], [hostname], [clientNumber], [systemNumber], [connectionProperties], [bapi], [importParameters], [tableParameters]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!sapInvokeWriter() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
Connector | Siebel | ConnectorUsed to integrate Appian with popular enterprise software solutions. | SiebelThe Siebel connector allows connecting to an Oracle Siebel 8.x. | a!sblCreate() | Creates a new record in Siebel. |
a!sblCreate([scsExternalSystemKey], [usePerUserCredentials], [hostname], [port], [enterpriseApp], [appManager], [language], [parameters], [fieldValues]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | Siebel | ConnectorUsed to integrate Appian with popular enterprise software solutions. | SiebelThe Siebel connector allows connecting to an Oracle Siebel 8.x. | a!sblDelete() | Deletes a record from Siebel. |
a!sblDelete([scsExternalSystemKey], [usePerUserCredentials], [hostname], [port], [enterpriseApp], [appManager], [language], [parameters]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | Siebel | ConnectorUsed to integrate Appian with popular enterprise software solutions. | SiebelThe Siebel connector allows connecting to an Oracle Siebel 8.x. | a!sblInvoke() | Invokes the method in Siebel, returning the result. |
a!sblInvoke([scsExternalSystemKey], [usePerUserCredentials], [hostname], [port], [enterpriseApp], [appManager], [language], [businessService], [method], [parameters]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | Siebel | ConnectorUsed to integrate Appian with popular enterprise software solutions. | SiebelThe Siebel connector allows connecting to an Oracle Siebel 8.x. | a!sblInvokeWriter() | Invokes the method that will result in a modification to data in Siebel. |
a!sblInvokeWriter([scsExternalSystemKey], [usePerUserCredentials], [hostname], [port], [enterpriseApp], [appManager], [language], [businessService], [method], [parameters]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | Siebel | ConnectorUsed to integrate Appian with popular enterprise software solutions. | SiebelThe Siebel connector allows connecting to an Oracle Siebel 8.x. | a!sblQuery() | Retrieves records from Siebel. |
a!sblQuery([scsExternalSystemKey], [usePerUserCredentials], [hostname], [port], [enterpriseApp], [appManager], [language], [sort], [parameters]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | Siebel | ConnectorUsed to integrate Appian with popular enterprise software solutions. | SiebelThe Siebel connector allows connecting to an Oracle Siebel 8.x. | a!sblUpdateFieldValue() | Updates the values of the given record in Siebel. |
a!sblUpdateFieldValue([scsExternalSystemKey], [usePerUserCredentials], [hostname], [port], [enterpriseApp], [appManager], [language], [fieldValues], [parameters]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!sfcDelete() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!sfcDescribeGlobal() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!sfcDescribeSObjects() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!sfcInsert() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!sfcQuery() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!sfcSearch() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!sfcUpdate() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!shpCopyDocumentFromAppian() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!shpCopyDocumentToAppian() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!shpInvoke() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!shpInvokeWriter() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
Connector | Web Service Helper | ConnectorUsed to integrate Appian with popular enterprise software solutions. | Web Service Helper | a!wsConfig() | Constructs the config parameter to the |
a!wsConfig([wsdlUrl], [service], [port], [operation], [wsdlCredentials], [endpointcredentials], [extensions]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | Web Service Helper | ConnectorUsed to integrate Appian with popular enterprise software solutions. | Web Service Helper | a!wsHttpCredentials() | Constructs a WsHttpCredentials object for use with |
a!wsHttpCredentials([username], [password], [domain]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | Web Service Helper | ConnectorUsed to integrate Appian with popular enterprise software solutions. | Web Service Helper | a!wsHttpHeaderField() | Constructs a WsHttpHeaderField object for use with |
a!wsHttpHeaderField([name], [name]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | Web Service Helper | ConnectorUsed to integrate Appian with popular enterprise software solutions. | Web Service Helper | a!wsUsernameToken() | Constructs a WsUsernameToken object for use with |
a!wsUsernameToken([username], [password]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Connector | Web Service Helper | ConnectorUsed to integrate Appian with popular enterprise software solutions. | Web Service Helper | a!wsUsernameTokenScs() | Constructs a WsUsernameTokenScs object for use with |
a!wsUsernameTokenScs([systemKey], [usePerUser]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Conversion | ConversionUsed to cast data from one data type into another. | displayvalue() | Tries to match a value in a given array with a value at the same index in a replacement array and returns either the value at the same index or a default value if the value is not found. |
displayvalue([value], [inArray], [replacement], [default]) | displayvalue( 1, {0, 1, 2}, {"Low", "Medium", "High"}, "Unknown" ) | Medium |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | externalize() | Converts the given value to a string representation so that it can be saved externally. |
externalize([value]) | externalize(todocument(1)) |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
|||
Conversion | ConversionUsed to cast data from one data type into another. | internalize() | Converts the given externalized string representation of a value to the original value. |
internalize([externalizedText], [default]) | internalize(externalize(todocument(1))) | [Document:1] |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | toboolean() | Converts a value to Boolean. |
toboolean([value]) | toboolean(0) | false |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | tocommunity() | Converts a value to Community. |
tocommunity([value]) | tocommunity(1) | [Community:1] |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | todate() | Converts a value to Date with Timezone. |
todate([value]) | todate(0) | 1/1/2035 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | todatetime() | Converts a value to Date and Time. |
todatetime([value]) | todatetime(date(2005, 12, 13)) | 12/13/05 12:00 AM GMT |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | todecimal() | Converts a value to Decimal (double precision floating point). |
todecimal([value]) | todecimal("3.6") | 3.6 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | todiscussionthread() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
Conversion | ConversionUsed to cast data from one data type into another. | todocument() | Converts a value to Document. |
todocument([value]) | todocument(1) | [Document:1] |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | toemailaddress() | Converts a value to email address. |
toemailaddress([value]) | toemailaddress("john.doe"&char(64)&"company.com") | john.doe@company.com |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | toemailrecipient() | Converts a value to email recipient. |
toemailrecipient([value]) | toemailrecipient(togroup(1)) | [Group:1] |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | tofolder() | Converts a value to Folder. |
tofolder([value]) | tofolder({"1","2"}) | [Folder:1], [Folder:2] |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | toforum() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
Conversion | ConversionUsed to cast data from one data type into another. | tointeger() | Converts a value to Integer. |
tointeger([value]) | tointeger("3") | 3 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | tointervalds() | Converts a value to Interval (Day to Second). |
tointervalds([value]) | tointervalds("11h 10m 30s") | 111030::00:00:00.000 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | toknowledgecenter() | Converts a value to Knowledge Center. |
toknowledgecenter([value]) | toknowledgecenter("2") | [Knowledge Center:2] |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | tomessage() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | topage() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | toportlet() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
Conversion | ConversionUsed to cast data from one data type into another. | tostring() | Converts a value to Text. |
tostring([value]) | tostring(17) | "17" |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | totime() | Converts a value to Time. |
totime([value]) | totime(datetime(2005, 12, 13, 12, 0, 0)) | 12:00 PM GMT |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Conversion | ConversionUsed to cast data from one data type into another. | touniformstring() | Converts a value to Text, preserving the original scalar or array structure. |
touniformstring([value]) | touniformstring("John Doe 1060 West Addison Chicago", "IL") | {"John Doe 1060 West Addison Chicago", "IL"} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | caladddays() | This function adds a given number of working days as designated on the process calendar to a Date and Time value, and returns a Date and Time value that falls within the work time defined in the process calendar. |
caladddays([start_datetime], [number], [calendar_name]) | caladddays(datetime(2011, 12, 13, 12, 0, 0), 0) | 12/13/2011 12:00 PM GMT |
-om+crf
Incompatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | caladdhours() | This function adds a given number of hours to a Date and Time plus any non-working hours (as designated on the process calendar) and returns the resulting Date and Time. |
caladdhours([start_datetime], [number], [calendar_name]) | caladdhours(datetime(2011, 12, 13, 12, 0, 0), 12) | 12/14/2011 4:00 PM GMT |
-om+crf
Incompatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | calisworkday() | This returns whether or not the given Date and Time is a work day, according to the calendar defined for the system. |
calisworkday([datetime], [calendar_name]) | calisworkday(datetime(2011, 12, 13, 12, 0, 0)) | true |
-om+crf
Incompatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | calisworktime() | This returns whether or not the given Date and Time is within working hours, according to the calendars defined for the system. |
calisworktime([datetime], [calendar_name]) | calisworktime(datetime(2011, 12, 13, 12, 0, 0)) | true |
-om+crf
Incompatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | calworkdays() | This returns the actual number of work days between two Date and Times (both inclusive), according to the calendar defined for the system. |
calworkdays([start_datetime], [end_datetime], [calendar_name]) | calworkdays(datetime(2011, 12, 13, 12, 0, 0), datetime(2011, 12, 20, 12, 0, 0)) | 6 |
-om+crf
Incompatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | calworkhours() | This returns the actual number of work hours between two given Date and Times (both inclusive), according to the calendar defined for the system. |
calworkhours([start_datetime], [end_datetime], [calendar_name]) | calworkhours(datetime(2011, 12, 12, 12, 0, 0), datetime(2011, 12, 13, 12, 0, 0)) | 8 |
-om+crf
Incompatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | date() | Converts text into data accepted by the date data type and functions that require date parameters. |
date([year], [month], [day]) | date(2011, 12, 13) | 12/13/2011 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | datetime() | Converts the given Date and Time into a serial number that holds the Date and Time data type. |
datetime([year], [month], [day], [hour], [minute], [second]) | datetime(2011, 12, 13, 12, 0, 0) | 12/13/2011 12:00 PM GMT |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | datevalue() | Converts a value to a date. |
datevalue([value]) | datevalue(0) | 1/1/2035 |
-om+crf
Incompatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | day() | Returns the day of the month from the day specified. |
day([date]) | day(datetime(2011, 12, 13, 12, 0, 0)) | 13 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | dayofyear() | Returns the day number within the year. |
dayofyear([date]) | dayofyear(date(1957, 03, 14)) | 73 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | days360() | Returns the number of days between two dates, based on a 360-day calendar. |
days360([start_date], [end_date], [method]) | days360(today(), today() + 365, 0) | 360 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | daysinmonth() | Returns the number of days in the given month in the given year. |
daysinmonth([month], [year]) | daysinmonth(2, 1800) | 28 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | edate() | Returns the date that is the number of months before or after the given starting date. |
edate([starting_date], [months]) | edate(date(2011, 12, 13), -6) | 6/13/11 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | eomonth() | Returns the date for the last day of the month that is the number of months before or after the given starting date. |
eomonth([starting_date], [months]) | eomonth(date(2011, 12, 13), -6) | 6/30/2011 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | gmt() | Subtracts a time zone offset from a given Date and Time. |
gmt([datetime], [timezone]) | gmt(datetime(2011, 12, 13, 12, 05), "America/New_York") | 12/13/2011 5:05 PM GMT |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | hour() | Returns the hour from the time specified. |
hour([time]) | hour(time(14, 20, 23)) | 14 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | intervalds() | Converts the given time components into an equivalent time duration, an interval expressing days to seconds. This value is treated as a duration (Joe ran the marathon in 3 hours and 23 minutes), not a point in time. |
intervalds([hour], [minute], [second]) | intervalds(2, 4, 5) | 0::02:04:05.000 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | isleapyear() | Returns a Boolean value for whether the given year is a leap year. |
isleapyear([year]) | isleapyear(1996) | True |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | lastndays() | Returns a Boolean value for whether the given date is within the last given number of days. |
lastndays([date], [n]) | lastndays(date(2011, 12, 13), 6) | False |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | local() | This is a Date and Time addition function, adding time zone offset to given Date and Time. |
local([datetime], [timezone]) | local(datetime(2011, 12, 13, 12, 05), "America/New_York") | 12/13/2011 7:05 AM GMT |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | milli() | This function returns the millisecond portion of a timestamp or the decimal number that represents 1 millisecond in days. |
milli([time]) | milli(datetime(2011, 12, 13, 12, 0, 0, 25)) | 25 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | minute() | Returns the minute from the time specified. |
minute([time], [minute]) | minute(time(14, 20, 23)) | 20 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | month() | Returns the month from the specified date. |
month([date]) | month(date(2011, 12, 13)) | 12 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | networkdays() | Returns the number of working days between two specified dates. |
networkdays([starting_date], [ending_date], [holidays]) | networkdays(date(2011, 12, 13), date(2011, 12, 20)) | 6 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | now() | Returns the current Date and Time as a serial number. |
now([]) | now() | 2/2/2022 2:02 PM |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | second() | Returns the seconds from the specified time. |
second([time]) | second(time(14, 20, 23)) | 23 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | time() | Converts the given time into an equivalent time value. |
time([hour], [minute], [second], [millisecond]) | time(14, 20, 23) | 2:20 PM |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | timevalue() | Converts the given time into an equivalent interval. |
timevalue([time_text]) | timevalue(time(14, 20, 23)) | 2:20 PM |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | timezone() | Returns the default offset in minutes from GMT, which is generally the process initiator's time zone. |
timezone([]) | timezone() | 0 |
-om+crf
Incompatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | timezoneid() | Returns the time zone ID for the current context. |
timezoneid([]) | timezoneid() | GMT |
-om+crf
Incompatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | today() | Returns the current day in GMT. |
today([]) | today() | 2/2/2022 |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | weekday() | Returns the day of the week of the specified date. |
weekday([date], [return_type]) | weekday(date(2011, 12, 13)) | 3 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | weeknum() | Returns the week number within the year for the given date using a given methodology. |
weeknum([date], [methodology]) | weeknum(date(2011, 12, 13)) | 51 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | workday() | Returns the date the given number of workdays before or after the given date. |
workday([starting_date], [days], [holidays]) | workday(date(2011, 12, 13), -6) | 12/5/2011 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | year() | Returns the year for the date specified. |
year([date]) | year(date(2011, 12, 13)) | 2011 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Date and Time | Date and TimeUsed within an expressions for date, time, or date and time values. | yearfrac() | Determine the fraction of the year. |
yearfrac([start_date], [end_date], [method]) | yearfrac(today(), today() + 270, 3) | 0.739726 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Smart Service | Document Management | Smart ServiceUsed within an interface component or Web API to execute a particular Appian Smart Service. | Document Management | a!docExtractionResult() | Retrieves results from a doc extraction run started by the Start Doc Extraction Smart Service. |
a!docExtractionResult([docExtractionId], [typeNumber], [confidenceThreshold], [isStructuredDoc]) | a!docExtractionResult(docExtractionId:5) | ANYTYPEDATACDT |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
Smart Service | Document Management | Smart ServiceUsed within an interface component or Web API to execute a particular Appian Smart Service. | Document Management | a!docExtractionStatus() | Retrieves the status of a doc extraction run started by the Start Doc Extraction Smart Service. |
a!docExtractionStatus([docExtractionId]) | a!docExtractionStatus(docExtractionId:5) | IN_PROGRESS |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
Evaluation | EvaluationUsed in expression to perform complex evaluations. | a!localVariables() | Lets you define one or more local variables for use within an expression. When used within an interface, the value of each variable can be refreshed under a variety of conditions, configured using a!refreshVariable(). When used outside of an interface, all refresh properties configured using a!refreshVariable() are ignored. |
a!localVariables([localVar1], [localVarN], [expression]) | Click on the function name for examples. |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
|||
Evaluation | EvaluationUsed in expression to perform complex evaluations. | a!refreshVariable() | The configuration for a specific local variable for use within a!localVariables(). When used within an interface, the value of the variable can be refreshed under a variety of conditions. When used outside of an interface, all refresh properties are ignored. |
a!refreshVariable([value], [refreshAlways], [refreshInterval], [refreshOnReferencedVarChange], [refreshOnVarChange], [refreshAfter]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
Evaluation | EvaluationUsed in expression to perform complex evaluations. | bind() | Use in conjunction with the load function to bind getter and setter functions to a variable. When the variable is read, the getter function or rule will be called. When the variable is saved into, the writer returned by the setter function or rule will be called. The setter function must return a writer. |
bind([get], [set]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
Evaluation | EvaluationUsed in expression to perform complex evaluations. | load() | Lets you define local variables within an expression for an interface and evaluate the expression with the new variables, then re-evaluate the function with the local variables' values from the previous evaluation. |
load([localVar1], [localVarN], [expression]) | Click on the function name for examples. |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
|||
Evaluation | EvaluationUsed in expression to perform complex evaluations. | a!save() | In interface saveInto parameters, updates the target with the given value. Use a!save for each item that you want to modify or alter in a |
a!save([target], [value]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
Evaluation | EvaluationUsed in expression to perform complex evaluations. | with() | Lets you define local variables within a function and evaluate the expression with the new variables. |
with([localVar1], [localVarN], [expression]) | with(local!a:10, local!b:20, local!a+local!b) | 30 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | a!defaultValue() | Returns a default value when the specified value is null or empty. When there are multiple default parameters, each parameter is evaluated in order and the first non-null and non-empty default will be returned. |
a!defaultValue([value], [default]) | a!defaultValue( null, date(2021,10,1), null) | `2021-10-01` |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | a!keys() | Returns the keys of the provided map, dictionary, CDT, or record. |
a!keys([value]) | a!keys(a!map(a: 1, b: 2)) | {"a"=>nil, "b"=>nil} |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | a!listType() | Returns the list type number for a given type number. |
a!listType([typeNumber]) | a!listType(typeof(1)) |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | byReference() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
Informational | InformationalUsed within expressions to expose system values and translate other information. | cast() | Converts a value from its existing type to the specified type. |
cast([typeNumber], [value]) | cast(type!Date,"01-01-2017") | 1/1/2017 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | error() | Raises an error with the given message, used for invalidating execution.This function never returns a value. |
error([message]) | error("This is an error message.") | Expression evaluation error at function 'error': This is an error message. |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | infinity() | Represents a constant number that stands for positive infinity or a negative infinity if you negate the value. |
infinity([]) | infinity() | ∞ |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | isinfinite() | Tests given numbers against positive and negative infinity, returning |
isinfinite([number]) | isinfinite(1.5, 1.1) | false; false |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | isnegativeinfinity() | Tests given numbers against negative infinity, returning true if number is negative infinity, false if number is not negative infinity. |
isnegativeinfinity([number]) | isnegativeinfinity(1) | false |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | a!isNotNullOrEmpty() | Returns |
a!isNotNullOrEmpty([value]) |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||||
Informational | InformationalUsed within expressions to expose system values and translate other information. | isnull() | Returns true if value is null, false otherwise. |
isnull([value]) | isnull("") | true |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | a!isNullOrEmpty() | Returns |
a!isNullOrEmpty([value]) |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||||
Informational | InformationalUsed within expressions to expose system values and translate other information. | ispositiveinfinity() | Tests given numbers against positive infinity, returning |
ispositiveinfinity([number]) | ispositiveinfinity(1) | false |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | nan() | Constant number representing Not A Number, generally used for comparison to the result of mathematical operations with invalid inputs. This is equivalent to a decimal (floating point) null, but nan() is provided for more explicit usage in mathematical expressions. |
nan([]) | nan() | null |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | null⠀() | Returns a null value. |
null⠀([value]) | null() | null |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | runtimetypeof() | Returns the numerical representation of an Appian system data type when used during process execution. |
runtimetypeof([value]) | runtimetypeof( 12345) | 9 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | typename() | Returns the type name of a given type number. |
typename([typeNumber]) | typename(typeof(1)) | Number (Integer) |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Informational | InformationalUsed within expressions to expose system values and translate other information. | typeof() | Returns the type number of a given value. |
typeof([value]) | typeof("a") | 3 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Logical | LogicalUsed within expressions to derive logical results. | and() | Returns |
and([value]) | and(true(), false()) | false |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Logical | LogicalUsed within expressions to derive logical results. | choose() | Evaluates the |
choose([key], [choice1], [choiceN]) | choose(2, "a", "b", "c") | b |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Logical | LogicalUsed within expressions to derive logical results. | false() | Returns the Boolean value |
false([returns]) | false() | false |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Logical | LogicalUsed within expressions to derive logical results. | if() | Returns |
if([condition], [valueIfTrue], [valueIfFalse]) | if(isleapyear(2021), 1, 2) | 2 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Logical | LogicalUsed within expressions to derive logical results. | not() | Converts |
not([value]) | not(true(), false()) | false, true |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Logical | LogicalUsed within expressions to derive logical results. | or() | Returns |
or([value]) | or(true(), false()) | true |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Logical | LogicalUsed within expressions to derive logical results. | true() | Returns the Boolean value |
true([returns]) | true() | true |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Looping | LoopingUsed within expressions to perform operations that call a rule or function for each item in an array. | a!forEach() | Evaluates an expression for each item in a list and returns a new array of the results. |
a!forEach([items], [expression]) | a!forEach(items: {1, 2, 3}, expression: fv!item + 10) | {11, 12, 13} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Looping | LoopingUsed within expressions to perform operations that call a rule or function for each item in an array. | all() | Calls a rule or function that returns either true or false for each item in list, asks the question, "Do all items in this list yield true for this rule/function?", and returns true if all items in list evaluates to true. |
all([predicate], [list], [context]) | all(fn!isnull, {10, null, 30}) | false |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Looping | LoopingUsed within expressions to perform operations that call a rule or function for each item in an array. | any() | Calls a rule or function that returns either true or false for each item in list by asking the question, "Do any items in this list yield true for this rule/function?" with the intent to discover if any item(s) yield true. |
any([predicate], [list], [context]) | any(fn!isnull, {10, null, 30}) | true |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Looping | LoopingUsed within expressions to perform operations that call a rule or function for each item in an array. | apply() | Calls a rule or function for each item in a list, and provides any contexts specified. |
apply([function], [list], [context]) | apply(fn!sum, {-1, 2, 3}, 2) | {1, 4, 5} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Looping | LoopingUsed within expressions to perform operations that call a rule or function for each item in an array. | filter() | Calls a predicate for each item in a list and returns any items for which the returned value is true. |
filter([predicate], [list], [context]) | filter(fn!isleapyear, {2015, 2016, 2017}) | {2016} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Looping | LoopingUsed within expressions to perform operations that call a rule or function for each item in an array. | merge() | Takes a variable number of lists and merges them into a single list (or a list of lists) that is the size of the largest list provided. |
merge([list]) | merge({10, 20}, {30, 40}) | {{10, 30}, {20, 40}} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Looping | LoopingUsed within expressions to perform operations that call a rule or function for each item in an array. | none() | Calls a rule or function that returns either true or false for each item in list by asking the question, "Do all items in this list yield false for this rule/function?" with the intent to discover if no items will yield true. |
none([predicate], [list], [context]) | none(fn!isnull, {1, null, 3}) | false |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Looping | LoopingUsed within expressions to perform operations that call a rule or function for each item in an array. | reduce() | Calls a rule or function for each item in a list, passing the result of each call to the next one, and returns the value of the last computation. |
reduce([function], [initial], [list], [context]) | reduce(fn!sum, 1, {2, 3, 4}) | 10 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Looping | LoopingUsed within expressions to perform operations that call a rule or function for each item in an array. | reject() | Calls a predicate for each item in a list, rejects any items for which the returned value is true, and returns all remaining items. |
reject([predicate], [list], [context]) | reject(fn!isnull, {1, null, 3}) | {1, 3} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | abs() | Returns the absolute value(s) of the specified number(s). |
abs([number]) | abs(-1) | 1 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | ceiling() | Rounds the number up to the nearest multiple of the specified significance. |
ceiling([number], [significance]) | ceiling(1.6) | 2 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | combin() | Calculates the number of unique ways to choose m elements from a pool of n elements. |
combin([n], [m]) | combin(4, 2) | 6 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | a!distanceBetween() | Returns the distance between the two locations (in meters) specified by the start and end coordinates. The distance is calculated by tracing a line between the two locations that follows the curvature of the Earth, and measuring the length of the resulting arc. |
a!distanceBetween([startLatitude], [startLongitude], [endLatitude], [endLongitude]) | a!distanceBetween(startLatitude: 38.932290, startLongitude: -77.218490, endLatitude: 38.963058, endLongitude: -77.363701) | 13015.34 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | e() | Returns the value of e. |
e([]) | e() | 2.718282 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | enumerate() | Returns a list of integer numbers from 0 through n-1. |
enumerate([n]) | enumerate(5) | 0, 1, 2, 3, 4 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | even() | Rounds positive numbers up to nearest even integer and negative numbers down to the nearest even integer. |
even([number]) | even(5) | 6 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | exp() | Returns e raised to the specified power. |
exp([power]) | exp(2) | 7.389056 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | fact() | The factorial of specified number. |
fact([number]) | fact(4) | 24 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | factdouble() | The double factorial of specified number (mathematically n!!). |
factdouble([number]) | factdouble(3) | 3 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | floor() | Rounds the number down to the nearest multiple of the specified significance. |
floor([number], [significance]) | floor(2.8888, .01) | 2.88 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | int() | Rounds the specified number down to the nearest integer. |
int([number]) | int(2.8888) | 2 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | ln() | Returns the natural logarithm of the specified number, which is the power that e must be raised to in order to equal the specified number. |
ln([number]) | ln(e()) | 1 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | log() | Returns the logarithm of the number using the specified base, which is the power that base must be raised to, to equal the number. |
log([number], [base]) | log(25, 5) | 2 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | mod() | Returns the remainder of dividend when divided by the divisor. |
mod([dividend], [divisor]) | mod(40, 15) | 10 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | mround() | Rounds the number to the specified multiple. |
mround([number], [multiple]) | mround(2.8888, .01) | 2.89 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | multinomial() | Adds the specified integers and divides the factorial of the sum by the factorial of the individual numbers. |
multinomial([integer]) | multinomial(1, 2, 3) | 60 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | odd() | Rounds positive numbers up to nearest odd integer and negative numbers down to the nearest odd integer. |
odd([number]) | odd(10) | 11 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | pi() | Returns the value of pi. |
pi([]) | pi() | 3.141593 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | power() | Returns the base number raised to the specified exponent. |
power([base], [exponent]) | power(10, 2) | 100 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | product() | Returns the product of the specified numbers. |
product([factor]) | product(10, 2) | 20 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | quotient() | Returns the quotient when numerator is divided by the denominator, and drops the remainder. |
quotient([numerator], [denominator]) | quotient(20, 10) | 2 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | rand() | Returns a random number between 0 and 1 based on an even probability distribution, which is seeded by the transaction time. |
rand([count]) | rand() | 0.4506349 |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | round() | Rounds off the number to the specified number of digits. |
round([number], [num_digits]) | round(2.8888, 2) | 2.89 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | rounddown() | Rounds the number down to the specified digit. |
rounddown([number], [num_digits]) | round(2.8888, 2) | 2.88 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | roundup() | Rounds the number up to the specified digit. |
roundup([number], [num_digits]) | round(2.8888, 2) | 2.89 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | sign() | Returns the number divided by its absolute value, which is 1 if the number is positive and -1 if the number is negative. |
sign([number]) | sign(-10) | -1 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | sqrt() | Returns the square root(s) of the specified number(s). |
sqrt([number]) | sqrt(25) | 5 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | sqrtpi() | Multiplies the number by pi, then returns the square root of the product. |
sqrtpi([number]) | sqrtpi(25 / pi()) | 5 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | sum() | Returns the sum of the specified numbers. |
sum([addend]) | sum(1, 2, 3) | 6 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | sumsq() | Squares each number and then returns the sum of the squares. |
sumsq([number]) | sumsq(2,3) | 13 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Mathematical | MathematicalUsed within expressions to perform mathematical operations. | trunc() | Truncates a decimal number to the specified number of places after the decimal point. |
trunc([value], [numberOfDecimals]) | trunc(2.8888, 3) | 2.888 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | a!doesGroupExist() | Verifies whether a group with the specified group ID already exists in the environment. |
a!doesGroupExist([groupId]) | a!doesGroupExist(6) | true |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | a!groupMembers() | Returns a DataSubset of group members of a given group. |
a!groupMembers([group], [direct], [memberType], [pagingInfo]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
People | PeopleUsed to perform evaluations and operations on users and groups. | a!groupsByName() | Returns an array of groups with the given name, or an empty array if no group exists. |
a!groupsByName([groupName]) | a!groupsByName("Purchase Request Viewers - " & ri!prId) | {[Group:8]} |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | a!groupsByType() | Returns a DataSubset of the groups of a given group type. |
a!groupsByType([groupType], [pagingInfo]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
People | PeopleUsed to perform evaluations and operations on users and groups. | a!isUserMemberOfGroup() | Identifies whether or not a user is a member of the specified groups. By default, this function returns true if the user is in at least one of the specified groups. |
a!isUserMemberOfGroup([username], [groups], [matchAllGroups]) | a!isUserMemberOfGroup("john.doe", 2) | false |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | getdistinctusers() | Retrieves users from a set of users and groups. |
getdistinctusers([peopleArray]) | getdistinctusers(topeople(cons!MY_GROUP)) | {test.user1, test.user2} |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | getgroupattribute() | Retrieves the value of the specified group attribute for the given group. |
getgroupattribute([group], [attribute]) | getgroupattribute(cons!MY_GROUP, "created") | 12/16/05 6:37 PM GMT |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | group() | Returns information for group. |
group([groupId], [property]) | group(2, "created") | 12/16/05 6:37 PM GMT |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | isusermemberofgroup_21r2() | Identifies whether or not a user belongs to a group. |
isusermemberofgroup_21r2([username], [groupId]) | isusermemberofgroup_21r2("john.doe", 2) | false |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | isusernametaken() | Verifies whether a user account with the specified username is already present. |
isusernametaken([username]) | isusernametaken("john.doe") | true |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | loggedInUser() | Returns the current user logged in to the application. |
loggedInUser([]) | loggedInUser() | current.user |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | supervisor() | Returns the supervisor of the user if they have one. |
supervisor([userinfo]) | supervisor("john.doe") | jane.smith |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | togroup() | Converts a value to Group. |
togroup([value]) | togroup(1) | [Group:1] |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | topeople() | Converts a value to People. |
topeople([value]) | topeople(1, "john.doe") | {[Group:1], john.doe} |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | touser() | Converts a value to User. |
touser([value]) | touser("john.doe") | john.doe |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
People | PeopleUsed to perform evaluations and operations on users and groups. | user() | Returns selected properties from a user's profile and preferences. |
user([username], [property]) | user("jane.smith", "created") | 12/20/05 10:36 PM GMT |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!aggregationFields() | Used to define a query against record data that performs an aggregation in |
a!aggregationFields([groupings], [measures]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | a!isNativeMobile() | Returns true if the interface is being viewed within the Appian for Mobile application. Returns false otherwise. |
a!isNativeMobile([]) | Click on the function name for examples. | Boolean |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | a!isPageWidth() |
a!isPageWidth([pageWidths]) |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|||||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | a!urlForTask() | This function returns the URL of a process task given the task ID. |
a!urlForTask([taskIds], [returnTaskPathOnly]) | a!urlForTask(taskIds: 12345, returnTaskPathOnly: false) | https://<sitename>/suite/tempo/tasks/task/<task_path> |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | averagetaskcompletiontimeforprocessmodel() | Returns the average elapsed time in days between task assignment and task completion for all assigned, accepted, and completed tasks in all processes started from a given process model. |
averagetaskcompletiontimeforprocessmodel([Id], [includeSubProcessData]) | averagetaskcompletiontimeforprocessmodel(4) | 0.6979317434217448 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | averagetasklagtimeforprocessmodel() | Returns the average elapsed time in days between task assignment and task acceptance for all assigned, accepted, and completed tasks in processes for the specified process model. |
averagetasklagtimeforprocessmodel([Id], [includeSubProcessData]) | averagetasklagtimeforprocessmodel(4) | 0.4155682319223637 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | averagetaskworktimeforprocessmodel() | Returns the average elapsed time in days between task acceptance and task completion for all accepted and completed tasks in processes for this process model. |
averagetaskworktimeforprocessmodel([Id], [includeSubProcessData]) | averagetaskworktimeforprocessmodel(processModelId) | 0.00003523892184732956 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | community() | Returns the properties of a given community. |
community([communityId], [property]) | community(1, "numberOfDocuments") | 40 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | datetext() | Interprets the date or datetime specified in the user's preferred calendar and returns its string representation using given format. |
datetext([value], [format]) | datetext(userdatevalue("8/18/1427"), "yyyy/MM/dd") | 1427/8/18 |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | document() | Returns property information for a document. |
document([documentId], [property]) | document(101, "expirationDate") | 12/21/05 2:28 PM GMT |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | folder() | Returns a property of the requested folder. |
folder([folderId], [property]) | folder(54, "knowledgeCenterName") | System Knowledge Center |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | getprocessemail() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | getprocessmodelemail() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | isNativePhone() [Deprecated] |
isNativePhone() |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | isNativeTablet() [Deprecated] |
isNativeTablet() |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|||||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | isInDaylightSavingTime() | Returns whether the given date and timezone are in daylight saving time. |
isInDaylightSavingTime([date], [timezone]) | isInDaylightSavingTime(date(2005,12,13), "America/Los_Angeles") | false |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | knowledgecenter() | Returns the properties of a knowledge center. |
knowledgecenter([knowledgeCenterId], [property]) | knowledgecenter(2, "name") | System Knowledge Center |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktocommunity() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktocommunityinternal() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktodocument() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktodocumentinternal() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktofolder() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktofolderinternal() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktogroup() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktogroupinternal() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktoknowledgecenter() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktoknowledgecenterinternal() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktoprocessdashboard() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktoprocessdashboardinternal() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktoprocessmodeldashboard() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktoprocessmodeldashboardinternal() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktouser() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | linktouserinternal() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | numontimeprocessesforprocessmodel() | This function eturns the number of active and completed processes of the specified process model that are on time (not past the deadline). |
numontimeprocessesforprocessmodel([processModelId], [includeSubProcessData]) | numontimeprocessesforprocessmodel(processModelId, true) | 38 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | numontimetasksforprocessmodel() | Returns the number of tasks in process instances of the specified process model that are currently on time (if the task is still active) or were completed on time. |
numontimetasksforprocessmodel([processModelId], [includeSubProcessData]) | numontimetasksforprocessmodel(processModelId, true) | 147 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | numoverdueprocessesforprocessmodel() | Returns the number of active and completed processes for the specified process model, which are past the deadline. |
numoverdueprocessesforprocessmodel([processModelId], [includeSubProcessData]) | numoverdueprocessesforprocessmodel(processModelId) | 1 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | numoverduetasksforprocessmodel() | Returns the number of tasks in both active and completed process instances of the specified process model, which are currently overdue (if the task is still active) or were completed past their deadline. |
numoverduetasksforprocessmodel([processModelId], [includeSubProcessData]) | numoverduetasksforprocessmodel(processModelId) | 10 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | numprocessesforprocessmodelforstatus() | Counts and returns the number of process instances with the specified status for the process model. |
numprocessesforprocessmodelforstatus([processModelId], [status], [includeSubProcessData]) | numprocessesforprocessmodelforstatus(processModelId, "completed") | 38 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | numtasksforprocessmodelforstatus() | Returns the number of tasks with the specified status in process instances of the process model. |
numtasksforprocessmodelforstatus([processModelId], [status], [includeSubProcessData]) | numtasksforprocessmodelforstatus(processModelId, "completed", true) | 112 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | offsetFromGMT() | Returns the offset (in minutes) from GMT of the given date and timezone. |
offsetFromGMT([date], [timezone]) | offsetFromGMT(date(2005,12,13), "America/Los_Angeles") | -480 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | page() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | property() | This function extracts a bean's property under a given key name (the |
property([bean], [nameOfProperty], [valueIfMissing]) | property(msg!properties, "name", "no name was sent") | no name was sent |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | queryrecord() [Deprecated] |
queryrecord( recordType, query ) |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|||||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | repeat() | This function takes an input of Any Type and returns a list with the input repeated a specified number of times. |
repeat([times], [input]) | repeat(2, "strawberry") | {"strawberry", "strawberry"} |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | todatasubset() | The function takes an array of values as well as optional paging/sorting configurations and returns a DataSubset value with a subset of the array in a specified sort order and the total count of items in the initial array. |
todatasubset([arrayToPage], [pagingConfiguration]) | todatasubset({1, 2, 3}) | [startIndex=1, batchSize=-1, sort=, totalCount=3, data=1; 2; 3, identifiers=1; 2; 3] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | topaginginfo() | Returns a PagingInfo value for use with the |
topaginginfo([startIndex], [batchSize]) | topaginginfo(1, 25) | [startIndex=1, batchSize=25] |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | torecord() | Converts XML to a value of the given data type. |
torecord([xml], [type]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | toxml() | Converts a value to its equivalent XML form. |
toxml([value], [format], [name], [namespace]) | Click on the function name to see examples. |
|
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | urlforrecord() | This function allows you to return the URLs for one or more records or a record list view that can then be used in a link component. |
urlforrecord([recordType], [recordIds]) | urlforrecord(cons!MY_RECORD_TYPE) | "https://<sitename>/suite/tempo/records/type/<record_type>/view/all" |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | urlwithparameters() | This function allows you to build a URL from an expression, using arrays of process and constant data. |
urlwithparameters([parameterNames], [parameterValues]) | "<a href=" & urlwithparameters("/tio/viewPayments.do", {"claimNumber"}, 100) & ">View Payments</a>" | View Payments |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | userdate() | Identifies the date represented by year, month, and day and then interprets it in the user preferred calendar, converting it into a serial number. |
userdate([year], [month], [day]) | datetext(userdate(1427, 8, 18), "mm/dd/yyyy") | 8/18/1427 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | userdatetime() | Interprets the given date and time in the user preferred calendar and converts it into a serial number. |
userdatetime([year], [month], [day], [hour], [minute], [second]) | datetext(userdatetime(1427, 8, 18, 1, 2, 0)) | 08/18/1427 01:02 AM |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | userdatevalue() | Interprets the given date in the user preferred calendar and converts it into an equivalent serial number. |
userdatevalue([date_text]) | datetext(userdatevalue("8/18/1427"), "yyyy/MM/dd") returns | 38 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | userday() | Returns the day of the month from the date or datetime specified in the user preferred calendar. |
userday([date]) | userday(11/31/2007) | 31 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | userdayofyear() | Returns the number of day within in a specified date/datetime. |
userdayofyear([date]) | userdayofyear(2/28/2006) | 58 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | userdaysinmonth() | Interprets the year/month specified in the user preferred calendar and returns the number of days in a that month. |
userdaysinmonth([month], [year]) | userdaysinmonth(04, 2006) | 30 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | useredate() | Returns the date that is the number of months before or after the given starting date in the user preferred calendar. |
useredate([start_date], [months]) | useredate(11/20/2006, -6) | 05/20/2006 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | usereomonth() | Returns the date for the last day of the month that is the number of months before or after the given starting date in the user preferred calendar. |
usereomonth([starting_date], [months]) | usereomonth(11/27/06, -6) | 5/31/06 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | userisleapyear() | This functions lets you know if a given year is a leap year in the user preferred calendar. |
userisleapyear([year]) | userisleapyear(2021) | false |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | userlocale() | Returns the preferred locale of the given user or the site primary locale if the user doesn't have a preference set. |
userlocale([user]) | userlocale("john.doe") | en_US |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | usermonth() | Returns the month from the specified date or datetime in the user preferred calendar. |
usermonth([date]) | usermonth(11/20/2006) | 11 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | usertimezone() | Returns the site primary timezone if the application is configured to override user preferences; otherwise it returns the preferred timezone of the given user or the site primary timezone if the user doesn't have a preference set. |
usertimezone([user]) | usertimezone(loggedinuser()) | GMT |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | userweekday() | Returns the day of the week of the specified date or datetime in the user preferred calendar. |
userweekday([date], [return_type]) | userweekday(07/10/2006, 1) | 1 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | userweeknum() | Returns the week number within the year for the given date or datetime in the user preferred calendar, using a given methodology. |
userweeknum([date], [methodology]) | userweeknum(02/06/2018, 1) | 6 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | useryear() | Returns the year from the date or datetime specified in the user preferred calendar. |
useryear([date]) | useryear(11/20/2018) | 2018 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | webservicequery() | Invokes a web service configured by a WsConfig object with the supplied input data. |
webservicequery([config], [data]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | webservicewrite() | Returns a Writer that can be used as the setter of a variable created using the bind() function. |
webservicewrite([config], [data]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | xpathdocument() | This function finds information in an XML document stored in Appian's document management system. |
xpathdocument([docId], [expression], [prefix]) | xpathdocument(cons!my_xml_document, "//temp/text()") & " degrees today" | Collab |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Scripting | ScriptingUsed within expressions to perform operations on process data and Appian objects. | xpathsnippet() | This function finds information in an XML document provided as Text. |
xpathsnippet([snippet], [expression], [prefix]) | xpathsnippet("<weather><temp>72.3</temp><sky>Cloudy</sky></weather>", "//temp/text()") & " degrees today" | 72.3 degrees today |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Array | Set | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | SetUsed within your expressions to manipulate values from arrays. | contains() | Checks whether an array contains the value. |
contains([array], [value]) | contains({10, 20, 30}, 20) | true |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
Array | Set | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | SetUsed within your expressions to manipulate values from arrays. | difference() | Returns the values in array1 and not in array2. |
difference([array1], [array2]) | difference({10, 20, 30, 40}, {30, 40}) | {10, 20} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
Array | Set | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | SetUsed within your expressions to manipulate values from arrays. | intersection() | Returns only those elements that appear in all of the given arrays. |
intersection([array1], [array2]) | intersection({10, 20, 30}, {20, 30, 40}) | {20, 30} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
Array | Set | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | SetUsed within your expressions to manipulate values from arrays. | symmetricdifference() | Returns the values unique to two arrays but are not in the intersection of them. |
symmetricdifference([array1], [array2]) | symmetricdifference({10, 20, 30}, {20, 30, 40}) | {10, 40} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
Array | Set | ArrayUsed within your expressions to manipulate, insert, and/or select values from arrays. | SetUsed within your expressions to manipulate values from arrays. | union() | Returns all unique elements from the given arrays. |
union([array1], [array2]) | union({10, 20, 30}, {20, 30, 40}) | {10, 20, 30, 40} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
Statistical | StatisticalUsed within expressions to perform statistical operations. | avedev() | Returns the average deviation of the specified number(s). |
avedev([number]) | avedev(1, 2, 3, 4) | 1 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | average() | Returns the average of the specified number(s). |
average([number]) | average(1, 2, 3, 4) | 2.5 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | count() | Returns the number items in all arrays passed to the function. |
count([value]) | count({1, 2, 3, 4}) | 4 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | frequency() | Uses the bin array to create groups bounded by the elements of the array. |
frequency([data_array], [bins_array]) | frequency({64, 74, 75, 84, 85, 86, 95}, {70, 79, 89}) | {1, 2, 3, 1} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | gcd() | Returns the greatest common denominator of the specified non-negative number(s), which is the largest number that divides all the given numbers without a remainder. |
gcd([number]) | gcd(4, 12, 36) | 4 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | geomean() | Returns the geometric mean of the specified number(s). |
geomean([number]) | geomean(4, 9) | 6 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | harmean() | Returns the harmonic mean of the specified number(s), which is the number of terms divided by the sum of the terms' reciprocals. |
harmean([number]) | harmean(1, 2, 3) | 1.636364 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | lcm() | Returns the least common multiple of the specified non-negative number(s), which is the smallest number that is a multiple of all the given numbers. |
lcm([number]) | lcm(5,10,15) | 30 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | lookup() | Returns location of data within multiple values, or valueIfNotPresent. |
lookup([multipleValues], [dataToLookup], [valueIfNotPresent]) | lookup({"a", "b", "c", "d"}, "c", -1) | 3 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | max() | Returns the maximum of the specified number(s). |
max([number]) | max(1, 2, 3, 4) | 4 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | median() | Returns the median of the specified number(s). |
median([number]) | median(1, 2, 3, 4) | 2.5 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | min() | Returns the minimum of the specified number(s). |
min([number]) | min(1, 2, 3, 4) | 1 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | mode() | Returns the mode of the specified number(s), which is the most commonly repeated element. |
mode([number]) | mode(1, 2, 2, 3, 3, 3, 4) | 3 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | rank() | Returns an integer representing the rank of the number in the specified array. |
rank([number], [array], [order]) | rank(2, {1, 2, 3, 4}, false) | 3 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | stdev() | Returns the standard deviation of the specified number(s). |
stdev([number]) | stdev(1, 2, 3, 4) | 1.290994 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | stdevp() | Returns the standard deviation of the specified number(s), assuming that the numbers form the entire data set and not just a sample. |
stdevp([number]) | stdevp(1, 2, 3, 4) | 1.118034 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | var() | Returns the variance of the specified number(s). |
var([number]) | var(1, 2, 3, 4) | 1.666667 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Statistical | StatisticalUsed within expressions to perform statistical operations. | varp() | Returns the variance of the specified number(s), assuming that the numbers form the entire data set and not just a sample. |
varp([number]) | varp(1, 2, 3, 4) | 1.25 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!applyComponents() | Calls a rule or function for each item in a list and supports the preservation of the local state on interfaces. |
a!applyComponents([function], [array], [arrayVariable]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!dataSubset() | Creates a value of type DataSubset for defining the source of expression-backed records and for use with |
a!dataSubset([startIndex], [batchSize], [sort], [totalCount], [data], [identifiers]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!deployment() | Returns a specific property of a direct deployment. |
a!deployment([deploymentUuid], [property]) | `deployment(101, "reviewedDate")` | `12/21/05 2:28 PM GMT` |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!entityData() | Creates an Entity Data for use with a!writeToMultipleDataStoreEntities() |
a!entityData([entity], [data]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!entityDataIdentifiers() | Creates an EntityDataIdentifiers configuration for use with a!deleteFromDataStoreEntities(). |
a!entityDataIdentifiers([entity], [identifiers]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!facet() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!facetOption() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
System | SystemUsed within expressions to perform platform operations and data transformations | a!fromJson() | Converts a JSON string into an Appian value. |
a!fromJson([jsonText]) | a!fromJson("{""name"":""John Smith"", ""age"":49, ""likes"":[""green"",""dogs"",""long walks""]}") | [name:John Smith,age:49,likes:green; dogs; long walks] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!fromJson_19r2() | Converts a JSON string into an Appian value. |
a!fromJson_19r2([jsonText]) | a!fromJson("{""name"":""John Smith"", ""age"":49, ""likes"":[""green"",""dogs"",""long walks""]}") | [name:John Smith,age:49,likes:green; dogs; long walks] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!httpResponse() | Returns an HTTP Response object for use in a Web API. |
a!httpResponse([statusCode], [headers], [body]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!httpResponse_17r4() | Returns an HTTP Response object for use in a Web API. |
a!httpResponse_17r4([statusCode], [headers], [body]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!iconIndicator() | Returns the specified image from a list of standard indicator icons. Indicator icons can be used on interface within a document image. |
a!iconIndicator([icon]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!iconNewsEvent() | Returns the specified image from a list of standard news event icons in one of six colors: blue, green, gray, orange, purple, or red. |
a!iconNewsEvent([icon], [color]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!integrationError() | Creates an integration error value. Use when configuring custom error handling for integration objects. |
a!integrationError([title], [message], [detail]) | Click on the function name for examples. |
|
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!jsonPath() | Finds information in a JSON string. JSONPath is used to navigate through elements and attributes in a JSON string. |
a!jsonPath([value], [expression]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!latestHealthCheck() | Returns the start time, run status, zip file, and report for the latest Health Check run. |
a!latestHealthCheck([]) | a!latestHealthCheck() | [startDateTime=04/25/2020 16:18:38 GMT+00:00, runStatus=COMPLETED, zip=[Document:1408], report=[Document:1409]] |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!listViewItem() | Creates a value of type ListViewItem for use with record type definitions. |
a!listViewItem([title], [details], [image], [timestamp]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!pagingInfo() | Creates a value of type PagingInfo for use with grids, queries, and |
a!pagingInfo([startIndex], [batchSize], [sort]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!query() | Creates a |
a!query([selection], [aggregation], [logicalExpression], [filter], [pagingInfo]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!queryAggregation() | Creates an |
a!queryAggregation([aggregationColumns]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!queryAggregationColumn() | Creates an |
a!queryAggregationColumn([field], [alias], [visible], [isGrouping], [aggregationFunction], [groupingFunction]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!queryColumn() | Creates a |
a!queryColumn([field], [alias], [visible]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!queryEntity() | Executes a query on a given data store entity and returns the result. |
a!queryEntity([entity], [query], [fetchTotalCount]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!queryEntity_18r3() | Executes a query on a given data store entity and returns the result. |
a!queryEntity_18r3([entity], [query]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!queryFilter() | Creates a value of type |
a!queryFilter([field], [operator], [value], [applyWhen]) | a!queryFilter(field: "name", operator: "=", value: 1) | [field=name, operator==, valueExpression=, value=1] |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!queryLogicalExpression() | Creates a |
a!queryLogicalExpression([operator], [logicalExpressions], [filters], [ignoreFiltersWithEmptyValues]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!queryProcessAnalytics() | Executes process reports and returns the resulting data. |
a!queryProcessAnalytics([report], [query], [contextGroups], [contextProcessIds], [contextProcessModels], [contextUsers]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!querySelection() | Returns a |
a!querySelection([columns]) | a!querySelection(columns: a!queryColumn(field: "name")) | [columns=[field=name, alias=name, visible=true]] |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!recordFilterChoices() | Creates choices of a user filter for an expression-backed record. |
a!recordFilterChoices([choiceLabels], [choiceValues]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!recordFilterDateRange() | Creates a user filter for a record list. |
a!recordFilterDateRange([name], [field], [isVisible], [defaultFrom], [defaultTo]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!recordFilterDateRange_20r2() | Creates a user filter for a record list. This is an older version of the |
a!recordFilterDateRange_20r2([name], [field], [defaultFrom], [defaultTo], [isVisible]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!recordFilterList() | Creates a user filter category for the record list. |
a!recordFilterList([name], [options], [defaultOption], [isVisible], [allowMultipleSelections]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!recordFilterListOption() | Creates a filter option for the |
a!recordFilterListOption([id], [name], [filter], [dataCount]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!sentimentScore() | Returns a list of scores representing the emotional or subjective sentiment expressed in each of the provided text values, ranging from 1.0 (positive) to -1.0 (negative). |
a!sentimentScore([text]) | a!sentimentScore({"Hi, I hope you're having a great day"}) | {0.79} |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!sortInfo() | Creates a value of type SortInfo for use with grids and record queries. |
a!sortInfo([field], [ascending]) | a!sortInfo(field: "a", ascending: true()) | [field=a, ascending=true] |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!toJson() | Converts a value into a JSON string. |
a!toJson([value], [removeNullOrEmptyFields]) | a!toJson(a!pagingInfo(startIndex: 1, batchSize: 10)) | {"startIndex":1,"batchSize":10} |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!toJson_17r1() | Converts a value into a JSON string. |
a!toJson_17r1([value]) | a!toJson_17r1(a!pagingInfo(startIndex: 1, batchSize: 10)) | {"startIndex":1,"batchSize":10} |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!toRecordIdentifier() | Matches record IDs with their record type to return a value of type Record Identifier for each record ID passed to the function. |
a!toRecordIdentifier([recordType], [identifier]) | a!toRecordIdentifier(recordType!<Record Type Name>, 1) | 0 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!userRecordFacets() [Deprecated] |
a!userRecordFacets() |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|||||
System | SystemUsed within expressions to perform platform operations and data transformations | a!userRecordFilterList() | Returns the default user filters for the User record type. For use on the User record type only. |
a!userRecordFilterList([]) | 0 | 0 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!userRecordIdentifier() | Returns a value of type Record Identifier for each user passed to the function. |
a!userRecordIdentifier([users]) | a!userRecordIdentifier("john.smith") | 0 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!userRecordListViewItem() | Returns the default list view item for the User record type. For use on the User record type only. |
a!userRecordListViewItem([record]) | 0 | 0 |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!map() | Creates a map of values (Any Type) with each value stored at the corresponding string key. Values stored in maps are not wrapped in variants. |
a!map([key1], [keyN]) | a!map(id: 1, name: "Jane Doe") | a!map(id: 1, name: "Jane Doe") |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
System | SystemUsed within expressions to perform platform operations and data transformations | a!queryRecordType() | Executes a query on a given record type and returns the result. |
a!queryRecordType([recordType], [fields], [filters], [pagingInfo], [fetchTotalCount], [relatedRecordData]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!queryRecordType_20r4() | Executes a query on a given record type and returns the result. This is an older version of the |
a!queryRecordType_20r4([recordType], [selection], [filters], [pagingInfo], [fetchTotalCount]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!recordData() | This function references a set of records from a record type and allows additional filtering in a read-only grid or chart that uses a record type as the source. When referencing one-to-many relationships in grid columns, you can filter, sort, and limit that related record set using the relatedRecordData parameter and the |
a!recordData([recordType], [filters], [relatedRecordData]) | Click on the function name for examples. |
~om-crf
Partially compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
System | SystemUsed within expressions to perform platform operations and data transformations | a!relatedRecordData() | References a one-to-many relationship defined on a record type and allows for additional filtering, sorting, and limiting of the related record set. |
a!relatedRecordData([relationship], [limit], [sort], [filters]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|||
Smart Service | Testing | Smart ServiceUsed within an interface component or Web API to execute a particular Appian Smart Service. | Testing | a!testRunResultForId() | Provided a test-run ID, this function returns a TestRunResult data type containing the results of a rule test run. If the status of the test is IN PROGRESS, TestRunResult will contain only results for completed tests; if the status is COMPLETE, TestRunResult contains all test results. |
a!testRunResultForId([testRunId]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Smart Service | Testing | Smart ServiceUsed within an interface component or Web API to execute a particular Appian Smart Service. | Testing | a!testRuleStatusForId() | Provided a test-run ID, this function queries for the status of an expression rule test run. |
a!testRuleStatusForId([testRunId]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Text | TextUsed within expressions for manipulating text strings of data. | cents() | Converts a number into its value in cents by effectively appending a cent sign to a fixed representation and one comma for every three digits preceding the decimal. |
cents([number], [decimals]) | cents( 123412 ) | 123,412.00¢ |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | char() | Converts a number into its Unicode character equivalent. |
char([number]) | char( 65 ) | A |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | charat() | Returns the character at given index within specified string. |
charat([text], [index]) | charat( "string", 2 ) | t |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | clean() | Returns the specified text, minus any characters not considered printable. Printable characters are the 95 printable ASCII characters plus three special characters: BACKSPACE (0x08), TAB (0x09), and NEWLINE (0x0a). |
clean([text]) | clean( "Please enter value in £" ) | Please enter value in |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | cleanwith() | Returns the specified text, minus any characters not in the list of valid characters. |
cleanwith([text], [with]) | cleanwith( "text string", "xte" ) | textt |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | code() | Converts the text into Unicode integers. |
code([text]) | code( "Convert to Unicode" ) | 67, 111, 110, 118, 101, 114, 116, 32, 116, 111, 32, 85, 110, 105, 99, 111, 100, 101 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | concat() | Concatenates the specified strings into one string, without a separator. |
concat([text]) | concat( {"a", "b", "c"}, {"d", "e", "f"} ) | abcdef |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | currency() | Converts a decimal number into a generic currency value by effectively adding a generic currency symbol (¤), a decimal point, and one comma for every three digits preceding the decimal. |
currency([number], [decimals]) | currency( 13213.43 ) | ¤13,213.43 |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | dollar() | Converts a decimal number into a dollar value by effectively adding a dollar sign ($), a decimal point, and optional comma for every three digits preceding the decimal. |
dollar([number], [decimals], [no_commas]) | dollar( 13213.43 ) | $13,213.43 |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | euro() | Converts a decimal number into a euro value by effectively adding a euro symbol (€), a decimal point, and optional comma for every three digits preceding the decimal. |
euro([number], [decimals], [no_commas]) | euro( 13213.43 ) | €13,213.43 |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | exact() | Compares two given text strings in a case-sensitive manner, returning true only if they are exactly the same. |
exact([text1], [text2]) | exact( "Copy of the other", "Copy of the other" ) | true |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | extract() | Returns the value (or values, if the text contains multiple delimited values) between the delimiters from the given text. |
extract([text], [startDelimiter], [endDelimiter]) | extract( "name: Bob, name: Karen, name: Sam", ":", "," ) | {"Bob", "Karen"} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | extractanswers() | Returns an array of strings that respond to the questions provided. |
extractanswers([questions], [text]) | extractanswers( {"What is your name?", "What is your age?"}, "1. What is your name? Ben 2. What is your age? 47 " ) | {"Ben", "47"} |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | find() | Returns index location of case-sensitive substring with given string. |
find([search_text], [within_text], [start_num]) | find( "to", "Boston", 1 ) | 4 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | fixed() | Rounds the specified number off to a certain number of decimals and returns it as text, with optional commas. |
fixed([number], [decimals], [no_commas]) | fixed( 7.36819 ) | 7.37 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | fromHtml() [Deprecated] |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||||||
Text | TextUsed within expressions for manipulating text strings of data. | initials() | Returns only the uppercase characters from within the given text. |
initials([text]) | initials( "John P. Smith" ) | JPS |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | insertkey() | Returns the provided text, wrapped with the specified delimiters. |
insertkey([key], [startDelimiter], [endDelimiter]) | insertKey( "hello", "[", "]" ) | [hello] |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | insertkeyval() | Returns the provided key-value pairs, wrapped with the specified delimiters. |
insertkeyval([key], [value], [startDelimiter], [endDelimiter]) | insertkeyval( {"hello", "goodbye"}, {"alpha", "beta"}, "[", "]") | [hello=alpha][goodbye=beta] |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | insertquestions() | Returns an array of questions with a ==EOQ== at the end, returning a single string that can be parsed with |
insertquestions([questions]) | insertquestions({"What is your name?", "What is your age?"}) | 1. What is your name? 2. What is your age? |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | keyval() | Returns the value(s) associated with the given key(s). |
keyval([text], [keys], [separators], [delimiters]) | keyval("[hello=alpha][goodbye=beta]", {"hello"}, "=", "]") | alpha |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | left() | Returns a specified number of characters from the text, starting from the first character. |
left([text], [num_chars]) | left("Boston",3) | Bos |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | leftb() | Returns a specified number of bytes from the text, starting from the first byte. |
leftb([text], [num_bytes]) | leftb("Boston",3) | Bos |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | len() | Returns the length in characters of the text. |
len([text]) | len("Boston") | 6 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | lenb() | Returns the length in bytes of the text. |
lenb([text]) | lenb("Boston") | 6 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | like() | Tests whether a string of text is like a given pattern. |
like([stringA], [stringB]) | like("brian","*ian") | true |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | lower() | Converts all characters in the text into lowercase (Unicode case folding). |
lower([text]) | lower("BOSTON") | boston |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | mid() | Returns a substring from the middle of the specified text. |
mid([text], [start_num], [num_chars]) | mid("Boston", 4, 2) | to |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | midb() | Returns a substring from the middle of the specified text. |
midb([text], [start_num], [num_bytes]) | midb("Boston", 4, 2) | to |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | padleft() | Pads text with spaces on the left so that it is a certain length. |
padleft([text], [length]) | padleft("Boston", 10) | Boston |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | padright() | Pads text with spaces on the right so that it is a certain length. |
padright([text], [length]) | padright("Boston", 10) | Boston |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | pound() | Converts the number into pounds by effectively adding a pound symbol (£), a decimal point, and one comma for every three digits preceding the decimal. |
pound([number], [decimals], [no_commas]) | pound(3213.43,2) | £3,213.43 |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | proper() | Converts each character in the text into proper case, meaning it will capitalize the first first letter of every word and convert the rest into lowercase. |
proper([text]) | proper("coNvert eaCH cHaRacter iNTo ProPeR caSe") | Convert Each Character Into Proper Case |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | replace() | Replaces a piece of the specified text with new text. |
replace([old_text], [start_num], [num_chars], [new_text]) | replace("oldtext",1,3,"new") | newtext |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | replaceb() | Replaces a piece of the specified text with new text. |
replaceb([old_text], [start_num], [num_chars], [new_text]) | replaceb("oldtext",1,3,"new") | newtext |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | rept() | Concatenates the text to itself a specified number of times and returns the result. |
rept([text], [repetitions]) | rept("do",3) | dododo |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | resource() | Retrieves a string of translated text appropriate for the current user, according to their language preference, by matching a given key with text. |
resource([key]) | resource("city") | ciudad |
~om+crf
Partially compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | right() | Returns a specified number of characters from the text, starting from the last character. |
right([text], [num_chars]) | right("Boston",3) | ton |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | search() | Searches the text for a particular substring, returning the positional index of the first character of the first match. |
search([search_text], [within_text], [start_num]) | search("to","Boston",1) | 4 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | searchb() | Searches the text for a particular substring, returning the positional index of the first byte of the first match. |
searchb([search_text], [within_text], [start_num]) | searchb("to","Boston",1) | 4 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | soundex() | Returns the soundex code, used to render similar sounding names via phonetic similarities into identical four (4) character codes. |
soundex([text]) | soundex("John Smith") | J525 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | split() | Splits text into a list of text elements, delimited by the text specified in the separator. |
split([text], [separator]) | split("Smith, John. Smith, Jane",".") | Smith, John; Smith, Jane |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | strip() | Returns the provided text, minus any characters considered printable. Printable characters are the 95 printable ASCII characters plus three special characters: BACKSPACE (0x08), TAB (0x09), and NEWLINE (0x0a). |
strip([text]) | strip("this text is stripped") | [empty result] |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | stripHtml() | Changes the provided HTML string into a plain text string by converting |
stripHtml([html]) | striphtml("<p>Click <b>Save</b>.</p>") | Click Save. |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | stripwith() | The function returns the provided text, minus any characters on the list of invalid characters. |
stripwith([text], [with]) | stripwith("text string","xt") | e sring |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | substitute() | Substitutes a specific part of a string with another string. |
substitute([text], [find], [replace_with]) | substitute("hello world","hello","my") | my world |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | a!swissFranc() | Converts the number into a Swiss franc value. Effectively adds a decimal point and an apostrophe for every three digits preceding the decimal. It also adds an optional Swiss franc symbol preceding the value. |
a!swissFranc([number], [decimals], [noApostrophes], [showPrefixSymbol]) | a!swissFranc( 3213.43 ) | 3'213.43 |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | text() | The text() function allows you to format Number, Date, Time, or Date and time values as you convert them into text strings. |
text([value], [format]) | text(10.25, "$00.0000") | $10.2500 |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | toHtml() | Converts a string in plain text to the HTML equivalent that displays appropriately in an HTML page, by replacing reserved characters with their escaped counterparts. |
toHtml([text]) | toHtml("Hello <br> World") | Hello <br> World |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | trim() | Removes all unnecessary spaces from the text. |
trim([text]) | trim(" this text needs trimming ") | this text needs trimming |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | upper() | Converts all letters in the text into uppercase. |
upper([text]) | upper("Boston") | BOSTON |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | value() | Converts text representing a number into an actual number or datetime. |
value([text], [format]) | value("1,2,3",",") | 1; 2; 3 |
-om+crf
Incompatible Offline MobileCompatible Custom Record Field Expressions |
||
Text | TextUsed within expressions for manipulating text strings of data. | yen() | Converts the number into yen by effectively adding a yen symbol (¥), a decimal point, and one comma for every three digits preceding the decimal. |
yen([number], [decimals]) | yen(3213.43) | ¥3,213.43 |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
||
Trigonometry | TrigonometryUsed within expressions to perform trigonometry operations. | acos() | Returns the arccosine(s) of the specified number(s) in radians. |
acos([number]) | acos(-1) | 3.141593 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Trigonometry | TrigonometryUsed within expressions to perform trigonometry operations. | acosh() | Returns the hyperbolic arccosine(s) of the specified number(s) in radians. |
acosh([number]) | acosh(2) | 1.316958 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Trigonometry | TrigonometryUsed within expressions to perform trigonometry operations. | asin() | Returns the arcsine(s) of the specified number(s) in radians. |
asin([number]) | asin(1) | 1.570796 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Trigonometry | TrigonometryUsed within expressions to perform trigonometry operations. | asinh() | Returns the hyperbolic arcsine(s) of the specified number(s) in radians. |
asinh([number]) | asinh(2) | 1.443635 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Trigonometry | TrigonometryUsed within expressions to perform trigonometry operations. | atan() | Returns the arctangent(s) of the specified number(s) in radians. |
atan([number]) | atan(1) | 0.7853982 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Trigonometry | TrigonometryUsed within expressions to perform trigonometry operations. | atanh() | Returns the hyperbolic arctangent(s) of the specified number(s) in radians. |
atanh([number]) | atanh(.9) | 1.472219 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Trigonometry | TrigonometryUsed within expressions to perform trigonometry operations. | cos() | Returns the cosine(s) of the specified number(s). |
cos([number]) | cos(pi()) | -1 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Trigonometry | TrigonometryUsed within expressions to perform trigonometry operations. | cosh() | Returns the hyperbolic cosine(s) of the specified number(s). |
cosh([number]) | cosh(1) | 1.543081 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Trigonometry | TrigonometryUsed within expressions to perform trigonometry operations. | degrees() | Converts the measure(s) of the specified angle(s) from radians to degrees. |
degrees([angle_in_radians]) | degrees(pi()/2) | 90 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Trigonometry | TrigonometryUsed within expressions to perform trigonometry operations. | radians() | Converts the measure of the specified angle from degrees to radians. |
radians([angle_in_degrees]) | radians(180) | 3.141593 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Trigonometry | TrigonometryUsed within expressions to perform trigonometry operations. | sin() | Returns the sine(s) of the specified number(s). |
sin([number]) | sin(pi()/2) | 1 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Trigonometry | TrigonometryUsed within expressions to perform trigonometry operations. | sinh() | Returns the hyperbolic sine(s) of the specified number(s). |
sinh([number]) | sinh(1) | 1.175201 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Trigonometry | TrigonometryUsed within expressions to perform trigonometry operations. | tan() | Returns the tangent(s) of the specified number(s). |
tan([number]) | tan(pi()/4) | 1 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Trigonometry | TrigonometryUsed within expressions to perform trigonometry operations. | tanh() | Returns the hyperbolic tangent(s) of the specified number(s). |
tanh([number]) | tanh(1) | 0.7615942 |
+om+crf
Compatible Offline MobileCompatible Custom Record Field Expressions |
||
Interface Component | Charts | Interface ComponentUsed to create Appian interfaces. | Charts | a!barChartField() | Displays numerical data as horizontal bars. Use a bar chart to display several values at the same point in time. |
a!barChartField([label], [instructions], [categories], [series], [xAxisTitle], [yAxisTitle], [yAxisMin], [yAxisMax], [stacking], [referenceLines], [showLegend], [showDataLabels], [showTooltips], [allowDecimalAxisLabels], [labelPosition], [helpTooltip], [accessibilityText], [showWhen], [colorScheme], [height], [xAxisStyle], [yAxisStyle], [data], [config], [refreshAlways], [refreshAfter], [refreshInterval], [refreshOnReferencedVarChange], [refreshOnVarChange]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Charts | Interface ComponentUsed to create Appian interfaces. | Charts | a!barChartConfig() | Contains configuration for how to display data in a bar chart. |
a!barChartConfig([primaryGrouping], [secondaryGrouping], [measures], [sort], [dataLimit], [link], [showIntervalsWithNoData]) | Click on the function name for examples |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Inputs | Interface ComponentUsed to create Appian interfaces. | Inputs | a!barcodeField() | Displays and allows entry of a barcode value using a barcode scanner or manual input. |
a!barcodeField([label], [labelPosition], [instructions], [acceptedTypes], [value], [saveInto], [refreshAfter], [required], [requiredMessage], [readOnly], [disabled], [validations], [validationGroup], [align], [placeholder], [helpTooltip], [masked], [accessibilityText], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Layouts | Interface ComponentUsed to create Appian interfaces. | Layouts | a!billboardLayout() | Displays a background color, image, or video with optional overlay content. |
a!billboardLayout([backgroundMedia], [backgroundColor], [showWhen], [height], [marginBelow], [overlay], [accessibilityText], [marginAbove]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Layouts | Interface ComponentUsed to create Appian interfaces. | Layouts | a!billboardLayout_19r1() | Displays a background color, image, or video with optional overlay content. |
a!billboardLayout( [backgroundMedia], [backgroundColor], [overlayPositionBar], [overlayPositionColumn], [overlayColumnWidth], [overlayStyle], [overlayContents], [height], [showWhen] ) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Layouts | Interface ComponentUsed to create Appian interfaces. | Layouts | a!boxLayout() | Displays any arrangement of layouts and components within a box on an interface. |
a!boxLayout([label], [contents], [style], [showWhen], [isCollapsible], [isInitiallyCollapsed], [marginBelow], [accessibilityText], [padding], [shape], [marginAbove]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Display | Interface ComponentUsed to create Appian interfaces. | Display | a!richTextBulletedList() | Displays a bulleted list within a rich text component. |
a!richTextBulletedList([items], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Action | Interface ComponentUsed to create Appian interfaces. | Action | a!buttonArrayLayout() | Displays a list of buttons in the order they are specified. Use this layout for buttons within interfaces rather than for submission buttons at the bottom of forms |
a!buttonArrayLayout([buttons], [showWhen], [align], [marginBelow], [accessibilityText]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Action | Interface ComponentUsed to create Appian interfaces. | Action | a!buttonWidget() | Displays a button that can conditionally be used to submit a form. |
a!buttonWidget([label], [style], [confirmMessage], [value], [saveInto], [disabled], [submit], [validate], [validationGroup], [size], [width], [confirmHeader], [confirmButtonLabel], [cancelButtonLabel], [showWhen], [icon], [accessibilityText], [tooltip], [loadingIndicator]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Action | Interface ComponentUsed to create Appian interfaces. | Action | a!buttonLayout() | Displays a list of buttons grouped by prominence. Use this layout in cases where prominence needs to be explicitly specified. |
a!buttonLayout([primaryButtons], [secondaryButtons], [accessibilityText], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Charts | Interface ComponentUsed to create Appian interfaces. | Charts | a!colorSchemeCustom() | A custom list of colors to apply to any chart. |
a!colorSchemeCustom([Colors]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Charts | Interface ComponentUsed to create Appian interfaces. | Charts | a!chartReferenceLine() | Contains the reference line value for each threshold that is defined on a column, bar, or line chart. |
a!chartReferenceLine([label], [value], [showWhen], [color], [style]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Charts | Interface ComponentUsed to create Appian interfaces. | Charts | a!chartSeries() | Defines a series of data for a bar, column, line, or pie chart. |
a!chartSeries([label], [data], [links], [color], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Selection | Interface ComponentUsed to create Appian interfaces. | Selection | a!checkboxFieldByIndex() | Displays 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!checkboxFieldByIndex([label], [instructions], [required], [disabled], [choiceLabels], [value], [validations], [saveInto], [validationGroup], [requiredMessage], [align], [labelPosition], [helpTooltip], [choiceLayout], [accessibilityText], [showWhen], [choiceStyle]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Selection | Interface ComponentUsed to create Appian interfaces. | Selection | a!checkboxField() | Displays 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!checkboxField([label], [instructions], [required], [disabled], [choiceLabels], [choiceValues], [value], [validations], [saveInto], [validationGroup], [requiredMessage], [align], [labelPosition], [helpTooltip], [choiceLayout], [accessibilityText], [showWhen], [choiceStyle]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Charts | Interface ComponentUsed to create Appian interfaces. | Charts | a!columnChartField() | Displays numerical data as vertical bars. Use a column chart to graphically display data that changes over time. |
a!columnChartField([label], [instructions], [categories], [series], [xAxisTitle], [yAxisTitle], [yAxisMin], [yAxisMax], [stacking], [referenceLines], [showLegend], [showDataLabels], [showTooltips], [allowDecimalAxisLabels], [labelPosition], [helpTooltip], [accessibilityText], [showWhen], [colorScheme], [height], [xAxisStyle], [yAxisStyle], [data], [config], [refreshAlways], [refreshAfter], [refreshInterval], [refreshOnReferencedVarChange], [refreshOnVarChange]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Charts | Interface ComponentUsed to create Appian interfaces. | Charts | a!columnChartConfig() | Contains configuration for how to display data in a column chart. |
a!columnChartConfig([primaryGrouping], [secondaryGrouping], [measures], [sort], [dataLimit], [link], [showIntervalsWithNoData]) | Click on the function name for examples |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Layouts | Interface ComponentUsed to create Appian interfaces. | Layouts | a!columnLayout() | Displays a column that can be used within the columns layout. |
a!columnLayout([contents], [width], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Browsers | Interface ComponentUsed to create Appian interfaces. | Browsers | a!hierarchyBrowserFieldColumns() | Displays hierarchical data in the form of drillable columns with selectable cells. |
a!hierarchyBrowserFieldColumns([label], [labelPosition], [instructions], [helpTooltip], [firstColumnValues], [nodeConfigs], [pathValue], [pathSaveInto], [nextColumnValues], [selectionValue], [selectionSaveInto], [height], [accessibilityText], [showWhen]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Browsers | Interface ComponentUsed to create Appian interfaces. | Browsers | a!hierarchyBrowserFieldColumnsNode() | Returns a Hierarchy Browser Field Columns Node, used in the Node Configurations parameter of the Columns Browser to determine how items in the hierarchy are displayed. |
a!hierarchyBrowserFieldColumnsNode([id], [label], [image], [link], [isSelectable], [isDrillable], [nextColumnCount], [showWhen]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Layouts | Interface ComponentUsed to create Appian interfaces. | Layouts | a!columnsLayout() | Displays any number of columns alongside each other. On narrow screens and mobile devices, columns are stacked. |
a!columnsLayout([columns], [alignVertical], [showWhen], [marginBelow], [stackWhen], [showDividers], [spacing], [marginAbove]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Pickers | Interface ComponentUsed to create Appian interfaces. | Pickers | a!pickerFieldCustom() | Displays an autocompleting input for the selection of one or more items from an arbitrary data set. For an example of how to configure the picker, see the Configure an Array Picker SAIL Recipe. |
a!pickerFieldCustom([label], [instructions], [required], [readOnly], [disabled], [maxSelections], [suggestFunction], [selectedLabels], [selectedTooltips], [value], [validations], [saveInto], [validationGroup], [requiredMessage], [labelPosition], [placeholder], [helpTooltip], [selectedLinks], [accessibilityText], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!dashboardLayout() [Deprecated] |
a!dashboardLayout([contents], [showWhen]) |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!dashboardLayout_17r1() [Deprecated] |
a!dashboardLayout_17r1( [firstColumnContents], [secondColumnContents] ) |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|||||
Interface Component | Inputs | Interface ComponentUsed to create Appian interfaces. | Inputs | a!dateField() | Displays and allows entry of a single date (year, month, day). To display a read-only date using a custom format, use a text component. |
a!dateField([label], [instructions], [required], [readOnly], [disabled], [value], [validations], [saveInto], [validationGroup], [requiredMessage], [align], [labelPosition], [helpTooltip], [accessibilityText], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Inputs | Interface ComponentUsed to create Appian interfaces. | Inputs | a!dateTimeField() | Displays and allows entry of a single date and time (year, month, day, hour, minute, second). To display a read-only date and time using a custom format, use a text component. |
a!dateTimeField([label], [instructions], [required], [readOnly], [disabled], [value], [validations], [saveInto], [validationGroup], [requiredMessage], [labelPosition], [helpTooltip], [accessibilityText], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Browsers | Interface ComponentUsed to create Appian interfaces. | Browsers | a!documentBrowserFieldColumns() | Displays the contents of a folder and allows users to navigate through a series of folders to find and select a document. |
a!documentBrowserFieldColumns([label], [labelPosition], [instructions], [helpTooltip], [rootFolder], [navigationValue], [navigationSaveInto], [selectionValue], [selectionSaveInto], [showWhen], [readOnly], [height], [accessibilityText]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Browsers | Interface ComponentUsed to create Appian interfaces. | Browsers | a!documentBrowserFieldColumns_17r3() | Displays the contents of a folder and allows users to navigate through a series of folders to find and download documents. |
a!documentBrowserFieldColumns_17r3( [label], [labelPosition], [instructions], [helpTooltip], [folder], [height], [knowledgeCenter] ) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Display | Interface ComponentUsed to create Appian interfaces. | Display | a!documentImage() | Displays an image from document management. |
a!documentImage([document], [altText], [caption], [link], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Action | Interface ComponentUsed to create Appian interfaces. | Action | a!documentDownloadLink() | Defines a link used to download a document. |
a!documentDownloadLink([label], [document], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Pickers | Interface ComponentUsed to create Appian interfaces. | Pickers | a!pickerFieldDocuments() | Displays an autocompleting input for the selection of one or more documents. |
a!pickerFieldDocuments([label], [labelPosition], [instructions], [required], [requiredMessage], [readOnly], [disabled], [maxSelections], [folderFilter], [value], [validations], [validationGroup], [saveInto], [placeholder], [helpTooltip], [accessibilityText], [showWhen]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Display | Interface ComponentUsed to create Appian interfaces. | Display | a!documentViewerField() | Displays a document from document management on an interface. |
a!documentViewerField([label], [labelPosition], [instructions], [helpTooltip], [document], [showWhen], [height], [altText], [disabled], [accessibilityText], [marginAbove], [marginBelow]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Browsers | Interface ComponentUsed to create Appian interfaces. | Browsers | a!documentAndFolderBrowserFieldColumns() | Displays the contents of a folder and allows users to navigate through a series of folders to find and select a folder or document. |
a!documentAndFolderBrowserFieldColumns([label], [labelPosition], [instructions], [helpTooltip], [rootFolder], [navigationValue], [navigationSaveInto], [selectionValue], [selectionSaveInto], [showWhen], [readOnly], [height], [accessibilityText]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Pickers | Interface ComponentUsed to create Appian interfaces. | Pickers | a!pickerFieldDocumentsAndFolders() | Displays an autocompleting input for the selection of one or more documents or folders. |
a!pickerFieldDocumentsAndFolders([label], [labelPosition], [instructions], [required], [requiredMessage], [readOnly], [disabled], [maxSelections], [folderFilter], [value], [validations], [validationGroup], [saveInto], [placeholder], [helpTooltip], [accessibilityText], [showWhen]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Selection | Interface ComponentUsed to create Appian interfaces. | Selection | a!dropdownFieldByIndex() | Displays a list of choices for the user to select one item and saves the index of the selected choice. |
a!dropdownFieldByIndex([label], [labelPosition], [instructions], [required], [disabled], [choiceLabels], [placeholder], [value], [validations], [saveInto], [validationGroup], [requiredMessage], [helpTooltip], [accessibilityText], [showWhen], [searchDisplay]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Selection | Interface ComponentUsed to create Appian interfaces. | Selection | a!dropdownFieldByIndex_20r2() | Displays a limited set of choices from which the user must select one item and saves the index of the selected choice. |
a!dropdownFieldByIndex_20r2([label], [labelPosition], [instructions], [required], [disabled], [choiceLabels], [placeholderLabel], [value], [validations], [saveInto], [validationGroup], [requiredMessage], [helpTooltip], [accessibilityText], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Selection | Interface ComponentUsed to create Appian interfaces. | Selection | a!dropdownField() | Displays a list of choices for the user to select one item and saves a value based on the selected choice. |
a!dropdownField([label], [labelPosition], [instructions], [required], [disabled], [choiceLabels], [choiceValues], [placeholder], [value], [validations], [saveInto], [validationGroup], [requiredMessage], [helpTooltip], [accessibilityText], [showWhen], [searchDisplay]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Selection | Interface ComponentUsed to create Appian interfaces. | Selection | a!dropdownField_20r2() | Displays a limited set of choices from which the user must select one item and saves a value based on the selected choice. |
a!dropdownField_20r2([label], [labelPosition], [instructions], [required], [disabled], [choiceLabels], [choiceValues], [placeholderLabel], [value], [validations], [saveInto], [validationGroup], [requiredMessage], [helpTooltip], [accessibilityText], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Action | Interface ComponentUsed to create Appian interfaces. | Action | a!dynamicLink() | Defines a link that triggers updates to one or more variables. |
a!dynamicLink([label], [value], [saveInto], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Grids | Interface ComponentUsed to create Appian interfaces. | Grids | a!gridLayout() | Displays a tabular layout of SAIL components to provide quick inline editing of fields. For an example of how to configure an editable grid, see the Add, Edit, and Remove Data in an Inline Editable Grid SAIL Recipe. |
a!gridLayout([label], [instructions], [headerCells], [columnConfigs], [rows], [validations], [validationGroup], [selectable], [selectionDisabled], [selectionRequired], [selectionValue], [selectionSaveInto], [addRowLink], [totalCount], [emptyGridMessage], [helpTooltip], [labelPosition], [showWhen], [shadeAlternateRows], [spacing], [height], [borderStyle], [selectionStyle], [rowHeader], [accessibilityText]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Inputs | Interface ComponentUsed to create Appian interfaces. | Inputs | a!encryptedTextField() | Allows entry of a single line of text that is encrypted when saved into a variable. The value remains encrypted while on the server and is only decrypted when displayed in the component. |
a!encryptedTextField([label], [instructions], [required], [readOnly], [disabled], [value], [saveInto], [refreshAfter], [validationGroup], [requiredMessage], [align], [labelPosition], [placeholder], [helpTooltip], [masked], [accessibilityText], [showWhen], [inputPurpose]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Inputs | Interface ComponentUsed to create Appian interfaces. | Inputs | a!fileUploadField() | Allows users to upload one or more files. File upload is only supported on start forms and task forms. Uploaded documents are not accessible until after form submission. |
a!fileUploadField([label], [labelPosition], [instructions], [helpTooltip], [target], [fileNames], [fileDescriptions], [maxSelections], [value], [saveInto], [required], [requiredMessage], [disabled], [validations], [validationGroup], [uploadMethods], [buttonStyle], [buttonSize], [accessibilityText], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Inputs | Interface ComponentUsed to create Appian interfaces. | Inputs | a!fileUploadField_17r1() | Allows users to upload a file. |
a!fileUploadField_17r1( [label], [labelPosition], [instructions], [helpTooltip], [target], [documentName], [documentDescription],[value], [saveInto], [required], [requiredMessage], [disabled], [validations], [validationGroup] ) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Inputs | Interface ComponentUsed to create Appian interfaces. | Inputs | a!floatingPointField() | Displays and allows entry of a single decimal number, stored with a floating point representation. |
a!floatingPointField([label], [instructions], [required], [readOnly], [disabled], [value], [validations], [saveInto], [validationGroup], [requiredMessage], [align], [labelPosition], [refreshAfter], [placeholder], [helpTooltip], [accessibilityText], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Browsers | Interface ComponentUsed to create Appian interfaces. | Browsers | a!folderBrowserFieldColumns() | Displays the contents of a folder and allows users to navigate through a series of folders to find and select a folder. |
a!folderBrowserFieldColumns([label], [labelPosition], [instructions], [helpTooltip], [rootFolder], [navigationValue], [navigationSaveInto], [selectionValue], [selectionSaveInto], [readOnly], [showWhen], [height], [accessibilityText]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Pickers | Interface ComponentUsed to create Appian interfaces. | Pickers | a!pickerFieldFolders() | Displays an autocompleting input for selecting one or more folders. |
a!pickerFieldFolders([label], [labelPosition], [instructions], [required], [requiredMessage], [readOnly], [disabled], [maxSelections], [folderFilter], [value], [validations], [validationGroup], [saveInto], [placeholder], [helpTooltip], [accessibilityText], [showWhen]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Layouts | Interface ComponentUsed to create Appian interfaces. | Layouts | a!formLayout() | Displays any arrangement of layouts and components beneath a title and above buttons. Use this as the top-level layout for start and task forms. |
a!formLayout([label], [instructions], [contents], [buttons], [validations], [validationGroup], [skipAutoFocus], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Layouts | Interface ComponentUsed to create Appian interfaces. | Layouts | a!formLayout_17r1() | Displays up to two columns of components beneath a title and above buttons. Use this as the top-level layout of start and task forms. |
a!formLayout_17r1( [label] , [instructions], [firstColumnContents], [secondColumnContents], [buttons], [validations], [validationGroup], [skipAutoFocus] ) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Display | Interface ComponentUsed to create Appian interfaces. | Display | a!gaugeField() | Displays completion percentage in a circular style with optional text. |
a!gaugeField([label], [labelPosition], [instructions], [helpTooltip], [percentage], [primaryText], [secondaryText], [color], [size], [align], [accessibilityText], [showWhen], [tooltip], [marginAbove], [marginBelow]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Display | Interface ComponentUsed to create Appian interfaces. | Display | a!gaugeFraction() | Displays text in fractional format for use within the gauge field primary text parameter. |
a!gaugeFraction([denominator]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Display | Interface ComponentUsed to create Appian interfaces. | Display | a!gaugeIcon() | Displays an icon for use within the gauge field primary text parameter. |
a!gaugeIcon([icon], [altText], [color]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Display | Interface ComponentUsed to create Appian interfaces. | Display | a!gaugePercentage() | Displays the configured percentage of the gauge as an integer for use within the gauge field primary text parameter. |
a!gaugePercentage([label], [labelPosition], [instructions], [helpTooltip], [percentage], [primaryText], [secondaryText], [color], [size], [align], [accessibilityText], [showWhen], [tooltip]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Grids | Interface ComponentUsed to create Appian interfaces. | Grids | a!gridColumn() | Displays a column of data as read-only text, links, images, or rich text within the read-only grid. |
a!gridColumn([label], [sortField], [helpTooltip], [value], [showWhen], [align], [width]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Grids | Interface ComponentUsed to create Appian interfaces. | Grids | a!gridLayoutColumnConfig() | Defines a column configuration for use in an editable grid (a!gridLayout). |
a!gridLayoutColumnConfig([width], [weight], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Grids | Interface ComponentUsed to create Appian interfaces. | Grids | a!gridLayoutHeaderCell() | Defines a column header for use in an editable grid (a!gridLayout). |
a!gridLayoutHeaderCell([label], [helpTooltip], [align], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!gridImageColumn() [Deprecated] |
a!gridImageColumn([label], [field], [data], [showWhen], [size], [isThumbnail], [style]) |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!gridImageColumn_17r3() [Deprecated] |
a!gridImageColumn_17r3( [label], [field], [data], [size] ) |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|||||
Interface Component | Grids | Interface ComponentUsed to create Appian interfaces. | Grids | a!gridRowLayout() | Displays a row of components within an editable grid (a!gridLayout). |
a!gridRowLayout([contents], [id], [selectionDisabled], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!gridSelection() [Deprecated] |
a!gridSelection([pagingInfo], [Selected]) |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|||||
一Deprecated一 | [Deprecated]These functions have been deprecated and will be removed in a future release of Appian. | a!gridTextColumn() [Deprecated] |
a!gridTextColumn([label], [field], [data], [alignment], [links], [showWhen]) |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|||||
Interface Component | Browsers | Interface ComponentUsed to create Appian interfaces. | Browsers | a!groupBrowserFieldColumns() | Displays group membership structure in columns. Users can navigate through the structure and select a single group. |
a!groupBrowserFieldColumns([label], [labelPosition], [instructions], [helpTooltip], [rootGroup], [pathValue], [pathSaveInto], [selectionValue], [selectionSaveInto], [readOnly], [height], [hideUsers], [accessibilityText], [showWhen]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Pickers | Interface ComponentUsed to create Appian interfaces. | Pickers | a!pickerFieldGroups() | Displays an autocompleting input for selecting one or more groups. |
a!pickerFieldGroups([label], [instructions], [required], [readOnly], [disabled], [maxSelections], [groupFilter], [value], [validations], [saveInto], [validationGroup], [requiredMessage], [labelPosition], [placeholder], [helpTooltip], [accessibilityText], [showWhen]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Charts | Interface ComponentUsed to create Appian interfaces. | Charts | a!grouping() | Determines the fields to group by in a query or chart that uses a record type as the source. The grouping should incorporate a record field or a related record field, an alias, and an optional interval to group by a date. |
a!grouping([field], [interval], [alias], [formatValue]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Layouts | Interface ComponentUsed to create Appian interfaces. | Layouts | a!headerContentLayout() | Displays any arrangement of layouts and components beneath a card or billboard flush with the edge of the page. |
a!headerContentLayout([header], [contents], [showWhen], [backgroundColor], [contentsPadding]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Display | Interface ComponentUsed to create Appian interfaces. | Display | a!richTextHeader() | Displays heading-styled text within a rich text component. |
a!richTextHeader([text], [size], [link], [linkStyle], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Display | Interface ComponentUsed to create Appian interfaces. | Display | a!imageField() | Displays an image from document management or the web. |
a!imageField([label], [labelPosition], [instructions], [helpTooltip], [images], [showWhen], [size], [isThumbnail], [style], [align], [accessibilityText], [marginAbove], [marginBelow]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Display | Interface ComponentUsed to create Appian interfaces. | Display | a!imageField_17r3() | Displays an image from document management or the web. |
a!imageField_17r3( [label], [labelPosition], [instructions], [helpTooltip], [images], [size] ) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Display | Interface ComponentUsed to create Appian interfaces. | Display | a!richTextImage() | Displays an image within a rich text component. |
a!richTextImage([image], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Inputs | Interface ComponentUsed to create Appian interfaces. | Inputs | a!integerField() | Displays and allows entry of a single integer number. |
a!integerField([label], [instructions], [required], [readOnly], [disabled], [value], [validations], [saveInto], [validationGroup], [requiredMessage], [align], [labelPosition], [refreshAfter], [placeholder], [helpTooltip], [masked], [accessibilityText], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Charts | Interface ComponentUsed to create Appian interfaces. | Charts | a!lineChartField() | Displays a series of numerical data as points connected by lines. Use a line chart to visualize trends of data that changes over time. |
a!lineChartField([label], [instructions], [categories], [series], [xAxisTitle], [yAxisTitle], [yAxisMin], [yAxisMax], [referenceLines], [showLegend], [showDataLabels], [showTooltips], [allowDecimalAxisLabels], [labelPosition], [helpTooltip], [showWhen], [connectNulls], [accessibilityText], [colorScheme], [height], [xAxisStyle], [yAxisStyle], [data], [config], [refreshAlways], [refreshAfter], [refreshInterval], [refreshOnReferencedVarChange], [refreshOnVarChange]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Charts | Interface ComponentUsed to create Appian interfaces. | Charts | a!lineChartField_19r1() | Displays a series of numerical data as points connected by lines. Use a line chart to visualize trends of data that changes over time. |
a!lineChartField_19r1([label], [instructions], [categories], [series], [xAxisTitle], [yAxisTitle], [yAxisMin], [yAxisMax], [referenceLines], [showLegend], [showDataLabels], [showTooltips], [allowDecimalAxisLabels], [labelPosition], [helpTooltip], [showWhen], [connectNulls], [accessibilityText]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Charts | Interface ComponentUsed to create Appian interfaces. | Charts | a!lineChartConfig() | Contains configuration for how to display data in a line chart. |
a!lineChartConfig([primaryGrouping], [secondaryGrouping], [measures], [sort], [dataLimit], [link], [showIntervalsWithNoData]) | Click on the function name for examples |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Action | Interface ComponentUsed to create Appian interfaces. | Action | a!linkField() | Displays 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!linkField([label], [instructions], [links], [labelPosition], [align], [helpTooltip], [showWhen], [accessibilityText]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Display | Interface ComponentUsed to create Appian interfaces. | Display | a!richTextListItem() | Displays a numbered list within a rich text component. |
a!richTextListItem([text], [nestedList], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Charts | Interface ComponentUsed to create Appian interfaces. | Charts | a!measure() | Determines the numerical values to display on a query or chart. The measure should incorporate a record field or a related record field, the appropriate calculation to run on the field, and an alias. If your record type has data sync enabled, you can also apply filters to determine which values are included in the calculation. |
a!measure([field], [function], [alias], [label], [filters]) | Click on the function name for examples |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Display | Interface ComponentUsed to create Appian interfaces. | Display | a!milestoneField() | Displays the completed, current, and future steps of a process or sequence. |
a!milestoneField([label], [instructions], [steps], [links], [active], [labelPosition], [helpTooltip], [showWhen], [orientation], [accessibilityText], [color], [marginAbove], [marginBelow]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Selection | Interface ComponentUsed to create Appian interfaces. | Selection | a!multipleDropdownFieldByIndex() | Displays a list of choices for the user to select multiple items and saves the indices of the selected choices. |
a!multipleDropdownFieldByIndex([label], [labelPosition], [instructions], [required], [disabled], [placeholder], [choiceLabels], [value], [validations], [saveInto], [validationGroup], [requiredMessage], [helpTooltip], [accessibilityText], [showWhen], [searchDisplay]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Selection | Interface ComponentUsed to create Appian interfaces. | Selection | a!multipleDropdownFieldByIndex_20r2() | Displays a long list of choices from which the user may select none, one, or many items and saves the indices of the selected choices. |
a!multipleDropdownFieldByIndex_20r2([label], [labelPosition], [instructions], [required], [disabled], [placeholder], [choiceLabels], [value], [validations], [saveInto], [validationGroup], [requiredMessage], [helpTooltip], [accessibilityText], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Selection | Interface ComponentUsed to create Appian interfaces. | Selection | a!multipleDropdownField() | Displays a list of choices for the user to select multiple items and saves values based on the selected choices. |
a!multipleDropdownField([label], [instructions], [required], [disabled], [placeholder], [choiceLabels], [choiceValues], [value], [validations], [saveInto], [validationGroup], [requiredMessage], [labelPosition], [helpTooltip], [accessibilityText], [showWhen], [searchDisplay]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Selection | Interface ComponentUsed to create Appian interfaces. | Selection | a!multipledropdownField_20r2() | Displays a long list of choices from which the user may select none, one, or many items and saves values based on the selected choices. |
a!multipledropdownField_20r2([label], [instructions], [required], [disabled], [placeholder], [choiceLabels], [choiceValues], [value], [validations], [saveInto], [validationGroup], [requiredMessage], [labelPosition], [helpTooltip], [accessibilityText], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Action | Interface ComponentUsed to create Appian interfaces. | Action | a!newsEntryLink() | Defines a link to news entries. |
a!newsEntryLink([label], [entry], [showWhen]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Display | Interface ComponentUsed to create Appian interfaces. | Display | a!richTextNumberedList() | Displays a numbered list within a rich text component. |
a!richTextNumberedList([items], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Browsers | Interface ComponentUsed to create Appian interfaces. | Browsers | a!orgChartField() | Displays the organizational structure of users within Appian based on the users’ Supervisor field values. |
a!orgChartField([label], [labelPosition], [instructions], [value], [saveInto], [showAllAncestors], [helpTooltip], [accessibilityText], [showWhen]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Grids | Interface ComponentUsed to create Appian interfaces. | Grids | a!gridField() | Accepts a set of data and displays it as read-only text, links, images, or rich text in a grid that supports selecting, sorting, and paging. |
a!gridField([label], [labelPosition], [instructions], [helpTooltip], [emptyGridMessage], [data], [columns], [pageSize], [initialSorts], [secondarySorts], [pagingSaveInto], [selectable], [selectionStyle], [selectionValue], [selectionSaveInto], [selectionRequired], [selectionRequiredMessage], [disableRowSelectionWhen], [validations], [validationGroup], [showWhen], [spacing], [height], [borderStyle], [shadeAlternateRows], [rowHeader], [accessibilityText], [refreshAlways], [refreshAfter], [refreshInterval], [refreshOnReferencedVarChange], [refreshOnVarChange], [userFilters], [showSearchBox], [showRefreshButton], [showExportButton], [recordActions], [openActionsIn], [actionsDisplay]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Grids | Interface ComponentUsed to create Appian interfaces. | Grids | a!gridField_19r1() | Displays read-only text, links, and images in a grid that supports selecting, sorting, and paging. |
a!gridField( [label], [labelPostion], [instructions], [helpTooltip], [totalCount], [emptyGridMessage], [columns], [identifiers], [value], [saveInto], [selection], [requireSelection], [requiredMessage], [disabled], [validations], [validationGroup], [showWhen], [shadeAlternateRows], [spacing], [height], [borderStyle], [selectionStyle], [rowHeader] ) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Inputs | Interface ComponentUsed to create Appian interfaces. | Inputs | a!paragraphField() | Displays and allows entry of multiple lines of text. |
a!paragraphField([label], [instructions], [required], [readOnly], [disabled], [value], [validations], [saveInto], [refreshAfter], [labelPosition], [validationGroup], [requiredMessage], [height], [placeholder], [helpTooltip], [showWhen], [accessibilityText], [characterLimit], [showCharacterCount]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Charts | Interface ComponentUsed to create Appian interfaces. | Charts | a!pieChartField() | Displays numerical data as slices of a single circle. Use a pie chart to graphically display parts of a whole. |
a!pieChartField([label], [instructions], [series], [showDataLabels], [showTooltips], [showAsPercentage], [labelPosition], [helpTooltip], [accessibilityText], [showWhen], [colorScheme], [style], [seriesLabelStyle], [height], [data], [config], [refreshAlways], [refreshAfter], [refreshInterval], [refreshOnReferencedVarChange], [refreshOnVarChange]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Charts | Interface ComponentUsed to create Appian interfaces. | Charts | a!pieChartConfig() | Contains configuration for how to display data in a pie chart. |
a!pieChartConfig([primaryGrouping], [measures], [sort], [dataLimit], [link]) | Click on the function name for examples |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Action | Interface ComponentUsed to create Appian interfaces. | Action | a!processTaskLink() | Defines a link to a process task. |
a!processTaskLink([label], [task], [showWhen], [openLinkIn]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Display | Interface ComponentUsed to create Appian interfaces. | Display | a!progressBarField() | Displays a completion percentage in bar style. |
a!progressBarField([label], [instructions], [percentage], [labelPosition], [helpTooltip], [accessibilityText], [color], [showWhen], [style], [showPercentage], [marginAbove], [marginBelow]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Selection | Interface ComponentUsed to create Appian interfaces. | Selection | a!radioButtonFieldByIndex() | Displays a limited set of choices from which the user must select one item and saves the index of the selected choice. |
a!radioButtonFieldByIndex([label], [instructions], [required], [disabled], [choiceLabels], [value], [validations], [saveInto], [validationGroup], [requiredMessage], [labelPosition], [choiceLayout], [helpTooltip], [accessibilityText], [showWhen], [choiceStyle]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Selection | Interface ComponentUsed to create Appian interfaces. | Selection | a!radioButtonField() | Displays a limited set of choices from which the user must select one item and saves a value based on the selected choice. |
a!radioButtonField([label], [instructions], [required], [disabled], [choiceLabels], [choiceValues], [value], [validations], [saveInto], [validationGroup], [requiredMessage], [labelPosition], [choiceLayout], [helpTooltip], [accessibilityText], [showWhen], [choiceStyle]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Action | Interface ComponentUsed to create Appian interfaces. | Action | a!recordActionField() | Displays a list of record actions with a consistent style. A record action is an end-user action configured within a record type object, such as a related action or record list action. |
a!recordActionField([actions], [style], [display], [openActionsIn], [align], [accessibilityText], [showWhen]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Action | Interface ComponentUsed to create Appian interfaces. | Action | a!recordActionItem() | Displays a record action defined within a record action field or a read-only grid that uses a record type as the data source. A record action is an end-user action configured within a record type object, such as a related action or a record list action. |
a!recordActionItem([action], [identifier]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Action | Interface ComponentUsed to create Appian interfaces. | Action | a!recordLink() | Defines a link to a record view configured in the record type. |
a!recordLink([label], [recordType], [identifier], [dashboard], [showWhen], [openLinkIn]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Pickers | Interface ComponentUsed to create Appian interfaces. | Pickers | a!pickerFieldRecords() | Displays an autocompleting input for the selection of one or more records, filtered by a single record type. Suggestions and picker tokens use the title of the record. |
a!pickerFieldRecords([label], [labelPosition], [instructions], [helpTooltip], [placeholder], [maxSelections], [recordType], [filters], [value], [saveInto], [required], [requiredMessage], [readOnly], [disabled], [validations], [validationGroup], [accessibilityText], [showWhen]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Pickers | Interface ComponentUsed to create Appian interfaces. | Pickers | a!pickerFieldRecords_20r2() | Displays an autocompleting input for the selection of one or more records, filtered by a single record type. Suggestions and picker tokens use the title of the record. This is an older version of |
a!pickerFieldRecords_20r2([label], [labelPosition], [instructions], [helpTooltip], [placeholder], [maxSelections], [recordType], [filters], [value], [saveInto], [required], [requiredMessage], [readOnly], [disabled], [validations], [validationGroup], [accessibilityText], [showWhen]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Action | Interface ComponentUsed to create Appian interfaces. | Action | a!reportLink() | Defines a link to a report. |
a!reportLink([label], [report], [showWhen], [openLinkIn]) | Click on the function name for examples. |
-om-crf
Incompatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Display | Interface ComponentUsed to create Appian interfaces. | Display | a!richTextDisplayField() | Displays text in variety of styles, including bold, italics, underline, links, headers, and numbered and bulleted lists. |
a!richTextDisplayField([label], [labelPosition], [instructions], [align], [value], [helpTooltip], [accessibilityText], [showWhen], [preventWrapping], [tooltip], [marginAbove], [marginBelow]) | Click on the function name for examples. |
+om-crf
Compatible Offline MobileIncompatible Custom Record Field Expressions |
|
Interface Component | Layouts | Interface ComponentUsed to create Appian interfaces. | Layouts | a!sectionLayout() | This layout requires Appian for Mobile Devices version 17.2 or later. Displays any arrangement of layouts and components beneath a section title on an interface. |