COUNTIF

Returns the count of all elements in an array that are equal to the comparison argument.

Syntax 

COUNTIF(array, comparison)

Usage examples 

Example 1

Input

1
{
2
"my_action": {
3
"message": [
4
"north",
5
"south",
6
"east",
7
"west",
8
"north"
9
]
10
}
11
}

Formula

COUNTIF(my_action.message, "north")

Output

2

Example 2

Comparison can also be a lambda.

Input

1
{
2
"my_action": {
3
"message": [
4
{
5
"count": 6
6
},
7
{
8
"count": 2
9
},
10
{
11
"count": 1
12
},
13
{
14
"count": 3
15
}
16
]
17
}
18
}

Formula

COUNTIF(my_action.message, LAMBDA(item, item.count > 1))

Output

3

Sample Actions 

Event transform
COUNTIF
Event transform
My Action

Select an action to inspect.

You can also click "Copy actions" and paste them in your Tines story to see how they work.

Was this helpful?