Ben SmithBen Smith
Ben Smith/
Count Select Instances
Count Select Instances
Count Select Instances

Count Select Instances

For
jMilton13
From
Reddit
Status
Updating
Formulas
length
length
Share
DB1
Name
Class
DB2
1
History
A
2
English
A
3
Chemistry
A
4
History
A
DB2
Name
DB1
Class
History Count
A
1
2
3
4
0

History Count

length(replaceAll(replaceAll(prop("Class"), "History", "*"), "[^*]", ""))
replaceAll(prop("Class"), "History", "*")
Replace every instance of History with an asterisk * or another special character that won't appear in any of the Class options.
replaceAll( ... ), "[^*]", "")
Replace everything except for the asterisks with nothing.
length( ... )
Count the number of asterisks.

Multiple Tags

DB1
Name
Tag
DB2
1
Learning
3
2
Learning
3
3
Learning
3
4
Learning
3
5
Learning
3
6
Learning
3
7
Learning
3
8
Important
3
9
Important
2
11
Event
1
12
Event
1
DB2
Name
DB1
Tags
Tag Count
Tag Count (Alt)
1
11
12
Event: 0 Important: 0 Learning: 0
2
9
Event: 0 Important: 0 Learning: 0
3
1
2
3
4
5
6
7
8
Event: 0 Important: 0 Learning: 0

Tag Count

"Event: " + format(length(replaceAll(replaceAll(prop("Tags"), "Event", "*"), "[^*]", ""))) + "\n" + "Important: " + format(length(replaceAll(replaceAll(prop("Tags"), "Important", "*"), "[^*]", ""))) + "\n" + "Learning: " + format(length(replaceAll(replaceAll(prop("Tags"), "Learning", "*"), "[^*]", ""))) + "\n"
Add a new + "Tag Name: " + format(length(replaceAll(replaceAll(prop("Tags"), "Tag Name", "*"), "[^*]", ""))) + "\n" for each new tag you add.

Tag Count (Alt)

if(length(replaceAll(replaceAll(prop("Tags"), "Event", "*"), "[^*]", "")) > 0, "Event: " + format(length(replaceAll(replaceAll(prop("Tags"), "Event", "*"), "[^*]", ""))) + "\n", "") + if(length(replaceAll(replaceAll(prop("Tags"), "Important", "*"), "[^*]", "")) > 0, "Important: " + format(length(replaceAll(replaceAll(prop("Tags"), "Important", "*"), "[^*]", ""))) + "\n", "") + if(length(replaceAll(replaceAll(prop("Tags"), "Learning", "*"), "[^*]", "")) > 0, "Learning: " + format(length(replaceAll(replaceAll(prop("Tags"), "Learning", "*"), "[^*]", ""))) + "\n", "")
Add a new + if(length(replaceAll(replaceAll(prop("Tags"), "Tag Name", "*"), "[^*]", "")) > 0, "Tag Name: " + format(length(replaceAll(replaceAll(prop("Tags"), "Tag Name", "*"), "[^*]", ""))) + "\n", "") for each new tag you add.
 
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!