yes the tables were available later.
It is true that you can use the practical “ glide-yes-code-hell-yes” routine to do a quick test.
also do not forget the return value in array format.
2 Likes
Hi @Robert_Petitto thanks for this helpful video.
Let me add an interesting aspect:
In a case, where the array has several values which are not necessarily unique, as in your example, and one wants to count the number of unique values in that array:
If you do a rollup on the array itself as shown in your video, you just get the number of items in that array.
But if you need information on just the unique items in that array, say the count or email addresses, you still need a relation based on that array and then do a rollup or lookup.
Use case: a shop cart holds selected items in an array and you want to count the different producers of these items.
1 Like
Amazing, super usefule. I’ve been looking for it for months!! Thanks for sharing 
The Rollup column does have a count unique option. Does this not work for an array directly?
You are genius, yes it works for count, never realised it.
But in my case I did also need some other columns from these unique rows, hence the relation was needed anyway.