- 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
- Referencing an Entity in Your App
- Replacing an Entity
- Using Apps With Data Service
- Leveraging Queues in Your App
- Application Lifecycle Management (ALM)
- Basic Troubleshooting Guide
Using Apps With Data Service
For more information on the functions and rules related to Entities, see the following guides:
- After the data is loaded, the entities data is refreshed only when a rule is executed. Any updates made on Data Service via processes or other means are not picked up automatically. Make sure that you refresh the data explicitly in these scenarios.
- The
in
operator only supports primitive data types, such asstring
,number
,boolean
,null
. Thein
operator is not supported in Data Service scenarios usingchoice-set
. You can use thecontains
operator instead, but only for one input.
Before starting this example, make sure that you have the proper permissions from Data Service. For more information, check the Data Service - Managing Access page.
For the purpose of this example we will use an entity called Customer with the following fields:
- Address
- Address 2
- City
- Name
- Phone
- Plan
- State
- Postal Code
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.
Use the Filter function to retrieve multiple entity records applicable to the given condition. To select a single record, use the Lookup function instead.
- Open your already existing application or start a new one.
- Create a new table.
-
Add an entity to your app by clicking on the next to the app's name and selecting Entity.
- Bind the newly-added entity to the table by adding it in the Data Source field of the table.
- Filter the information from the table by state. For this example, to filter the customer by the state of California, add the
following expression in the Data Source property of the table:
= Filter(Customer, [State, "=", "CA"])
.
- Open your already existing application or start a new one.
- Create a new table.
-
Add an entity to your app by clicking on the next to the app's name and selecting Entity.
-
Bind the newly-added entity to the table by adding it in the Data Source field of the table.
- Sort information from the table by by name in an descending order. For this example, add the following expression in the Data Source property of the table:
= Sort(Customer, Name, "Desc")
.
In this example we will build a data table with three buttons:
- Create New
- Edit Selected
- Delete Selected
The Create New and Edit Selected buttons will lead to the same page.
- Open your already existing application or start a new one.
- Create a new table.
-
Create two new buttons at the top of the table: Edit Selected and Create New. Create a third button at the bottom of the table called Delete Selected.
-
Add an entity to your app by clicking on the next to the app's name and selecting Entity.
-
Bind the newly-added entity to the table by adding it in the Data Source field of the table.
-
Create a new page called Edit/Create Customer and add the following controls:
6.1 Add corresponding text fields for each of the entity fields and bind them.
6.2 Add a button under the text fields and name it Save.
selectedCustomerId
by using a Set Value rule in the value change event of the table. Bind the variable to Table.SelectedValue.Id
to use it on another page.
6.4 Add an If-Then-Else rule to the Save button and configure it:
- Add the following expression in the If field:
=selectedCustomerId
==""
, as in the figure below.
=Lookup(Customer, [Id, "=", selectedCustomerId])
, where Id
is the id of the entity. Configure the rule as in the figure below.
7. Add a Delete Entity Record rule to the Delete Selected button from step 3 and add the following expression in the Which entity record should be deleted? field: Lookup(Customer, [Id, "=', Table.Id]).
- Configure both Edit Selected and Create New buttons from step 3 to lead to the Edit/Create Customer page.