- Getting Started
- Before You Begin
- How To
- Designing your App
- Events and Rules
- Rule: If-Then-Else
- Rule: Open a Page
- Rule: Open URL
- Rule: Close Pop-Over/Bottom Sheet
- Rule: Show Message
- Rule: Show/Hide Spinner
- Rule: Set Values
- Rule: Start Process
- Rule: Upload File to Storage Bucket
- Rule: Get File From Storage Bucket
- Rule: Create/Update Entity Record
- Rule: Delete Entity Record
- Rule: Add to Queue
- Function: And, Or, Not
- Function: Concat
- Function: Contains
- Function: Count
- Function: EndsWith
- Function: If
- Function: IsBlank
- Function: Length
- Function: List
- Function: StartsWith
- Function: Sum
- Function: Sort
- Function: Now
- Function: Today
- Function: Time
- Function: Year
- Function: Month
- Function: Day
- Function: Hour
- Function: Minute
- Leveraging RPA in your App
- Leveraging Entities in Your App
- Leveraging Queues in Your App
- Application Lifecycle Management (ALM)
- Basic Troubleshooting Guide
About Functions
To help you define particular Expressions or include individual operations while designing your app, an out of the box set of Functions is provided within the designer.
Start using the available functions by selecting the needed operator, input the parameters, and wait for the output value to be returned.
- The accepted parameters can be the same type of arguments or implicit cast of arguments.
- The output value can be primitive or an object.
Please access this page for more details.
|
Operator |
Description |
Example |
|---|---|---|
|
|
Addition |
|
|
|
Subtraction |
|
|
|
Multiplication |
|
|
|
Division |
|
|
|
Modulus (division remainder) |
|
|
|
Increment |
|
|
|
Decrement |
|
text1 = "Good ", text2 = "Morning", and text3 = "".
|
Operator |
Example |
text1 |
text2 |
text3 |
|---|---|---|---|---|
|
|
text1 += text2 |
"Good Morning" |
"Morning" |
"" |
|
|
text3 = text1 + text2 |
"Good " |
"Morning" |
"Good Morning" |
x = 5.
|
Operator |
Description |
Comparing |
Returns |
|---|---|---|---|
=, == |
equal to ("=" is the same as "==") |
|
false true |
|
|
greater than |
|
false |
|
|
greater than or equal to |
|
false |
|
|
not equal |
|
true |
|
|
less than |
|
true |
|
|
less than or equal to |
|
true |
x=6 and y=3.
|
Operator |
Function |
Description |
Example |
|---|---|---|---|
!, not, NOT |
Not() |
not |
|
&&, and, AND |
And() |
and |
|
||, or, OR |
Or() |
or |
|
in operator returns a true result if the specified property is in the specified object, otherwise, it returns a false result.
in operator only supports primitive data types, such as string, number, boolean, null.
in operator is not supported in Data Service scenarios using choice-set. You can use the contains operator instead, but only for one input.
Use this function to generate a unique identifier.
|
Syntax |
Description |
|---|---|
|
Guid() |
Returns a unique identifier. |
Use this function to create a new in-memory entity. This entity is not stored in the data service until a Create entity rule is run.
You can use the New function to create a new entity record, while the Lookup function creates a data context which can only be used to update an existing entity record.
For more information on using the function, see the Using the New Function page.
|
Syntax |
Description | Example |
|---|---|---|
| New(Entity) |
Creates a new in-memory entity. |
|
Use this function to find and return the first record in a table that satisfies a formula or condition.
|
Syntax |
Description |
Example |
|---|---|---|
|
Lookup(Entity, Condition) |
Returns the first entity record that matches the condition. |
|
Use this function to filter a table based on its fields.
This function performs a case insensitive check.
null. For example, you can use the following:
Filter(Customer, [If(IsBlank(Dropdown.Value), null, City), "=", Dropdown.Value])
In this case, the filter on City is only applied when the Dropdown contains a value other than blank.
|
Syntax |
Description |
Example |
|---|---|---|
|
Filter(Entity, Condition) |
The function returns all records that result in true. These expressions can reference fields/columns by name. |
|
