apps
2022.4
false
- 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
Apps User Guide for Automation Suite
Last updated Apr 19, 2024
Function: Count
Check to see if a string contains a text fragment
Use this function to count the number of records in a table.
|
Syntax |
Description |
|---|---|
|
Count(Items [, Condition]) |
Returns the number of records in a table. |
For more information on arguments, see the table below.
|
Argument |
Type |
Description |
|---|---|---|
|
|
Required |
A list or a table. |
|
|
Optional |
A condition that must evaluate as true for the item to be counted. |
Assume
JamTypes is a list of different kinds of Jam:
List(“Apricot”, “Blackberry”, "Blueberry", "Cherry", “Raspberry”, “Peach”, “Strawberry”)List(“Apricot”, “Blackberry”, "Blueberry", "Cherry", “Raspberry”, “Peach”, “Strawberry”)Assume process output
JamPrefrences returns the following DataTable:
|
Name (Text) |
Country (Text) |
Jam Preference (Text) |
|---|---|---|
|
Adah |
Australia |
Apricot |
|
Betty |
Brazil |
Blackberry |
|
Bob |
Brazil |
Blueberry |
|
Carina |
Cyprus |
Cherry |
Count(
JamTypes): 7
Count(
JamPreferences): 4
