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!
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
Superb! Thanks for sharing Bob.
very, very useful
Gosh!!! I was thinking about it today to do something in a app.
Now I know I can
This is great!
Hard to explain
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
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.
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!!
Thanks my friend! Hope we can do it one day
Ufff… let me try and test again @Manu.n
Test with this
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!