- Getting Started
- Before You Begin
- How To
- Build Your First App
- Build a Mobile-friendly App
- Embed Apps
- Embed Maps
- Include Excel Charts in Apps
- Include MailTo Links
- Include Star Ratings
- Use Count With Choice Set Values
- Use Document Viewer
- Use Master Detail View
- Use Selected Values From a Table
- Set External Context
- Work With Data Source and Value Bind
- General User Experience Guidelines
- Use the Send Interim Result Activity
- Notifications
- 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: Reset Values
- 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: Guid
- 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
- Function: New
- Function: Lookup
- Function: Filter
- Leveraging RPA in your App
- Leveraging Entities in Your App
- Leveraging Queues in Your App
- Application Lifecycle Management (ALM)
- Basic Troubleshooting Guide
Use Count With Choice Set Values
You can build an app to count the values from a table field that is of type Choice Set.
In this example we will use the Count function to do the following:
- Get the total count of Choice Set values.
- Get the count of Choice Set fields from a selected row inside a table.
To do this, you first need to prepare an entity with two Choice Set fields, as follows:
- Choices - not allowing multiple selections
- Multiple choices - allowing multiple selections
- Open your already existing application or start a new one.
-
Add the entity containing the two Choice Set fields. The entity fields and data should look similar to the example below.
- Add a table and bind the entity to the Data Source property of the table.
-
Add two labels next to each other inside a container.
4.1 Add the following in the Text property of the first label:The total number of values in the Choice Set:
.4.2 Add the Choices field of the entity using a Count function on the second label as shown in the example below.
-
Add two labels next to each other inside a second container.
5.1 Add the following in the Text property of the first label:The number of values on the selected row:
.5.2 Add the Table.entity.SelectedValues field using a Count function on the second label as shown in the example below.