Operator Scope of Action:
Operator First Added:
The function count() counts the number of discrete items in the specified List or Set data type attribute.
The attribute argument is evaluated so can use, $attribute(note) or more complex expressions to get data - as long as the result is an attribute of the Set data type.
For example if $KeyAttributes for the current note is "Color;Color2;NameFont" then the code
and not surprisingly returns 3. Note that the count is not all unique values for the attribute across the whole TBX - scope is restricted to 'this' note or another nominated note. Specimen usage:
count($KeyAttributes(some other note))
To use count() with a list of items that are attributes or expressions, use list():
$MyNum = count(list(4+2,9+6)) (output: 2)
For more complex examples, where list items are action code expressions, it may be necessary to use eval() to wrap each list item expression e.g.
The following is a trivial example (given we could use $ChildCount instead) but shows how count can be used in a more subtle way:
$MyNum = count(collect(children,$Name))
The result of collect is a List, in this case a number of note titles. count(list) will return the number of values in the list (including duplicates). To get a de-duped count, chain the .unique function to the list reference inside count():