# 🆕 Rollups, Single Values and JoinLists FROM ARRAYS! **URL:** \ **Category:** Community Resources\ **Created:** [July 28, 2021, 3:52am UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634 "2021-07-28T03:52:00Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [July 28, 2021, 3:52am UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634/1 "2021-07-28T03:52:01Z")
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! ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [July 28, 2021, 4:01am UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634/2 "2021-07-28T04:01:32Z")
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 👍 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 28, 2021, 4:08am UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634/3 "2021-07-28T04:08:03Z")
Superb! Thanks for sharing Bob. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 28, 2021, 4:17am UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634/4 "2021-07-28T04:17:59Z")
very, very useful ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [July 28, 2021, 4:39am UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634/5 "2021-07-28T04:39:57Z")
Gosh!!! I was thinking about it today to do something in a app. Now I know I can 🤩🤩 ---
**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\ **Post date:** [July 28, 2021, 4:49am UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634/6 "2021-07-28T04:49:57Z")
This is great! Thanks! ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [July 28, 2021, 11:13am UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634/7 "2021-07-28T11:13:48Z")
> [@Lucas\_Pires](#): > > to do something in a app. So mysterious! ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [July 28, 2021, 11:34am UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634/8 "2021-07-28T11:34:23Z")
> [@Robert\_Petitto](#): > > mysterious Hard to explain 🤣 ---
**Author:** ![Gregory](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gregory/32/21180_2.png) [@Gregory](https://community.glideapps.com/u/Gregory)\ **Post date:** [July 28, 2021, 12:01pm UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634/9 "2021-07-28T12:01:30Z")
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. ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [July 28, 2021, 12:03pm UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634/10 "2021-07-28T12:03:15Z")
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. ---
**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\ **Post date:** [July 28, 2021, 12:46pm UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634/11 "2021-07-28T12:46:39Z")
Very nice. Thanks for the overview. But … I really want conditional relationships 🙂 ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [July 28, 2021, 12:48pm UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634/12 "2021-07-28T12:48:54Z")
keep wanting 😉 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 28, 2021, 11:42pm UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634/13 "2021-07-28T23:42:36Z")
@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. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [July 29, 2021, 12:33am UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634/14 "2021-07-29T00:33:58Z")
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!! ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [July 29, 2021, 12:42am UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634/15 "2021-07-29T00:42:24Z")
😣😣 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 29, 2021, 12:52am UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634/16 "2021-07-29T00:52:09Z")
Thanks my friend! Hope we can do it one day 😉 ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [July 29, 2021, 4:09am UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634/17 "2021-07-29T04:09:30Z")
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 😉 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/2/825222dd0c93d1d8f637b6a8c37d3cfbfac193fa.png) ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [July 29, 2021, 4:11am UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634/18 "2021-07-29T04:11:54Z")
Ufff… let me try and test again @Manu.n ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [July 29, 2021, 4:13am UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634/19 "2021-07-29T04:13:47Z")
Test with this [https://array-sort.manun2.repl.co](https://array-sort.manun2.repl.co) Source: > **[array-sort](https://replit.com/@ManuN2/array-sort#function.js)** > > A HTML, CSS, JS repl by ManuN2 ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [July 29, 2021, 6:14am UTC](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634/20 "2021-07-29T06:14:39Z")
Interesting @Manu.n !! your code includes an array as parameter and this explains why you can use a lookup from a multiple relation 🙃 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/4/8496eb5ad66c1f7c6b608b3be8d92ff14e3da0be.png) 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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/8/28dd92ea106b808c13bb373b23a067cf763ad7c2.png) 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! [Next page](https://community.glideapps.com/t/rollups-single-values-and-joinlists-from-arrays/29634.md?page=2)