Guide
Basic
Automation Guide
Integration Guide
Open API
Template Guide
Cookbook
Reference
Automation Triggers
Automation Actions
Integrations
Node Resources
Database Views
Database Fields
Dashboard Widgets
Missions
Ai Wizard
Formula
Space
Release Notes
Videos
Recommend Reading
- Revolutionize Your Website Monitoring with Bika.ai's HTTP Monitoring Template
- Automated Currency Data Retrieval (JavaScript): Airtable Alternative to Portfolio Analysis
- Airtable Pricing vs. Bika.ai Pricing: Which Offers Better Automation Value for AI Create X Tweets Automatically?
- Data Automation with Bika.ai: Unlocking New Potential for Automated Stock Data Retrieval (Python) in Quantitative modeling
- Data Automation with Bika.ai: Unlocking New Potential for AI Project Issues and Tickets in Collecting requirements
![Counts the number of times a keyword appears in values.
values: Specifies where to look for data. Supports array or text type data.
keyword: The keyword to search for and count.
operation: Comparison operator, optional. You can enter condition symbols greater than ">", less than "<", equal to "=", not equal to "!=". If not filled, the default is equal to.
In example one, no comparison operator is filled, so it counts the number of values equal to "A".
In example two, the comparison operator ">" is filled, meaning it counts the number of values greater than "2".
Use cases:
1) It can count the number of times the character "A" appears in a text array [A, B, C, D, A], as shown in example one.
2) It can count the number of numbers greater than 3 in a number array [1, 2, 3, 4, 5], as shown in example two.
3) It can count the number of times "grape" appears in a text string "Eat grapes without spitting out the skins", as shown in example three.](/assets/icons/formula/array.svg){kind=icon}
