๐Ÿ†• Rollups, Single Values and JoinLists FROM ARRAYS!

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!

21 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 :+1:

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 :star_struck::star_struck:

3 Likes

This is great!
Thanks!

So mysterious!

2 Likes

Hard to explain :rofl:

thanks @Robert_Petitto

very interesting: Lookup a column in a sheet w/o a relation to return an array :exploding_head:
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 :slight_smile:

3 Likes

keep wanting :wink:

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! :face_with_thermometer:

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

:persevere::persevere:

Thanks my friend! Hope we can do it one day :wink:

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 :wink:

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 :upside_down_face:

image

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:

image

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