You’ve always been able to create Rollup columns, Single Value Columns and Join List columns from a multiple relation or an entire sheet, but now you can create them from an ARRAY COLUMN!
22 Likes
Yes Super
I saw the single value yesterday in the staging but didn’t think it was already in production.
This will simplify (or not) a lot of things.
Thanks for this video 
2 Likes
Superb! Thanks for sharing Bob.
2 Likes
very, very useful
3 Likes
Gosh!!! I was thinking about it today to do something in a app.
Now I know I can 
3 Likes
This is great!
Thanks!
So mysterious!
2 Likes
Hard to explain 
thanks @Robert_Petitto
very interesting: Lookup a column in a sheet w/o a relation to return an array 
I need to think through it.
Does this open the door to concatenating arrays using a template column, e.g. join 2 arrays columns together X Y?
Moreover, Could I then eliminate unwanted things by replacing any occurrence of ‘thing’ with empty string?
My use case it to concatenate a split list from one sheet with a split list from another (email of people that have ever attended an event) and remove specific users.
Very nice. Thanks for the overview.
But … I really want conditional relationships 
3 Likes
keep wanting 
2 Likes
@Robert_Petitto @Jeff_Hager @Darren_Murphy @Lucas_Pires
I saw Jeff and Rob talking about sorting a relation and create a chart from it a long while ago. Does this help solving the problem?
I imagine the steps should be like below:
- Create a multiple relation.
- Do a lookup to return the right column (do we need this?).
- Use Manu/Rob’s Yes-Code column to sort the relation/lookup array.
- Create a join text column from the sorted array.
3 Likes
Hola @ThinhDinh
I tested the Yes Code Column using a lookup as an array but unfortunately, the relation must be simple! 
When a lookup column depends on a multiple relation, it isn’t available in Yes-Code column’s fields.
It’s a tragedy!!
1 Like
Thanks my friend! Hope we can do it one day
1 Like
Hello @ThinhDinh , @gvalero
I don’t know what to look for exactly, but you can sort on an array from a multiple relation !!
I may be off topic
1 Like
Ufff… let me try and test again @Manu.n
Test with this
https://array-sort.manun2.repl.co
Source:
Interesting @Manu.n !!
your code includes an array as parameter and this explains why you can use a lookup from a multiple relation 
I was using the Mark’s glide-yes-code-hell-yes template and of course, none of parameters is set to work as an array, they all are string or primitive:
I little modification can improve and make more versatile the glide-yes-code-hell-yes template and save time/effort.
Thanks for this great trick and tip!
Feliz día!
2 Likes