I’ve got a user ID and and item ID joined into a template column that is then fed into a list column and set as the buy button’s product ID/SKU.
I’m allowing clients to add multiple items to their cart prior to checking out and need to count how often an item ID occurs in the array column that is formed from splitting the list column.
Is there a way to count occurrences?
Have you tried a rollup?
Or are you trying to get something like 2,1,1 out of the array?
I’m trying to get just “2” from that first value that is seen twice.
@Jonathon_Kohn Well, I dont know your cenario, but I tried to replicate it.
You have this first relation I called rel/ items. Having this, you could try:
The 2 steps below I’m not sure if you need it, but I made it anyway:
See above screenshot. I want to count the number of times an ID occurs within an array column. The array column here is 2 comma separated lists combined into 1 column then split into an array. I want to count the times each ID occurs within that single column.
I think I have a Yes Code column almost ready to sent your way. Just to confirm, do you have this one in a comma-delimited format instead of an array?
Exactly… is that not currently possible without the code column?
Comma-delimited version:
Array version:
Enjoy 
Ah I can’t immediately think of a solution without using the XC column but the links are there in the reply above, just plug it in and run!
Love this phrase! 
One of the best things about XC/YC column eh
