# šŸ‘Ŗ Make Array ā€” the newest column type! **URL:** \ **Category:** Community Resources\ **Tags:** tutorial\ **Created:** [March 12, 2022, 3:21am UTC](https://community.glideapps.com/t/make-array-the-newest-column-type/39540 "2022-03-12T03:21:34Z")\ **Posts on this page:** 19\ **Page:** 2
**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:** [April 1, 2022, 10:04am UTC](https://community.glideapps.com/t/make-array-the-newest-column-type/39540/21 "2022-04-01T10:04:46Z")
> [@Darren\_Murphy](#): > > I think if you pass a Joined List to Make Array, all youā€™ll get is an array of one item - which contains the entire joined list. Correct. ---
**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:** [April 2, 2022, 5:09am UTC](https://community.glideapps.com/t/make-array-the-newest-column-type/39540/22 "2022-04-02T05:09:17Z")
Hereā€™s a use case that saved me a bunch of columns šŸ˜ƒ Just thinking about this one after I made the video, I guess the other way without Makearray would be a template to create a joined list, then a split text column, and then carry on from there. But still, Makearray definitely makes these things easier šŸ™‚ ---
**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:** [April 2, 2022, 6:36pm UTC](https://community.glideapps.com/t/make-array-the-newest-column-type/39540/23 "2022-04-02T18:36:21Z")
Thatā€™s a real neat use case! ---
**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:** [April 4, 2022, 3:11am UTC](https://community.glideapps.com/t/make-array-the-newest-column-type/39540/24 "2022-04-04T03:11:30Z")
Hereā€™s another oneā€¦ > [@Math parameters min / max](https://community.glideapps.com/t/math-parameters-min-max/22608/8): > > With all the new plugin column types, there could be an alternative way to approach thisā€¦ Use a MakeArray column to create an array of all the columns involved Use the Sort Array plugin to sort it Use a Single Value column to pick the first element from the sorted array (eg. the minimum value) More columns, of course. But probably a bit less error-prone slight_smile ---
**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\ **Post date:** [April 11, 2022, 2:47pm UTC](https://community.glideapps.com/t/make-array-the-newest-column-type/39540/25 "2022-04-11T14:47:44Z")
Hi @Robert_Petitto let me ask, usually i remove duplicate data using the ā€œuniqeā€ formula. My question is, can this be done on glide? If so, how? ![Screenshot_2022-04-11-21-42-01-221_com.google.android.apps.docs.editors.sheets](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/0/c0c9832679310106194d8ea048fd5600c4b03e5f.jpeg) ---
**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:** [April 11, 2022, 3:00pm UTC](https://community.glideapps.com/t/make-array-the-newest-column-type/39540/26 "2022-04-11T15:00:05Z")
Two columns: - A lookup column to create an array from your email column - Then use the [Unique Elements](https://www.glideapps.com/plugins/uniq) plugin to extract the unique items If you need something that you can use in a choice component or an inline list, then you need to coerce the array into a list. Use the ā€œMiracle Methodā€ for that. > [@fishbaguette\_breadbasket Transpose Columns to an Inline List: The Miracle Method](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766): > > Iā€™m often asked how to take columns of data (say form responses) and display them in an inline list. Hereā€™s one way to do itā€”the MIRACLE METHOD. [[Glide: Transpose Data Columns into an Inline List with the MIRACLE METHOD] ](https://www.youtube.com/watch?v=t-sh_Q3WbQc) ---
**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\ **Post date:** [April 11, 2022, 3:51pm UTC](https://community.glideapps.com/t/make-array-the-newest-column-type/39540/27 "2022-04-11T15:51:54Z")
Hi @Darren_Murphy thank you for your feedback, but i donā€™t understand yet, how to find the data ` **Kode Arisan** ` in `uniqe element`? because thatā€™s how I tried it on `uniqe element` there is no option to put the column ` **Kode arisan** ` ![Screenshot 2022-04-11 224155](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/8/0869a867e2829db3c44f481ae7ce79f422c88cf0.jpeg) ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [April 11, 2022, 4:05pm UTC](https://community.glideapps.com/t/make-array-the-newest-column-type/39540/28 "2022-04-11T16:05:52Z")
@agung_Taufik you need a array column. > A lookup column to create an array from your email column šŸ‘† ---
**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\ **Post date:** [April 11, 2022, 4:33pm UTC](https://community.glideapps.com/t/make-array-the-newest-column-type/39540/29 "2022-04-11T16:33:54Z")
sorry, I donā€™t understand how `unique elements` work, can you explain it with picturesā€¦ the results I want to get are like the example in the `expected results` column sorry i bother you ![KJJKKJ](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/5/b5f06f26811701e2895476d7ad9fdf73d5fa2841.jpeg) ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [April 11, 2022, 4:39pm UTC](https://community.glideapps.com/t/make-array-the-newest-column-type/39540/30 "2022-04-11T16:39:41Z")
You can watch this video. Robert shows how to do this! > [@family Make Array ā€” the newest column type!](https://community.glideapps.com/t/make-array-the-newest-column-type/39540/18): > > Another use for the ā€œMake Arrayā€ column: Create a clean delineated string from columns that may or may not contain values: Keep 'em coming!!! How else are you using this versatile column type? ---
**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:** [April 13, 2022, 3:11pm UTC](https://community.glideapps.com/t/make-array-the-newest-column-type/39540/31 "2022-04-13T15:11:32Z")
Another use of **Make Array** : Displaying `City, State` . There are times when your users wonā€™t fill out a city or leave both fields blank but you want to display something pretty based on what they filled in. A template column leaves awkward punctuation and missing fields. A combination of a **Make Array** and a **Join List** rectifies that. ![CleanShot 2022-04-13 at 11.08.04@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/7/6767ce0e2ef0f79127d2c5e5aa62564ac3f82c7c.png) Could also clean up the City & State columns with **Text** Plugin columns first to make sure theyā€™re capatilized. ---
**Author:** ![morgan](https://avatars.discourse-cdn.com/v4/letter/m/0ea827/32.png) [@morgan](https://community.glideapps.com/u/morgan)\ **Post date:** [August 5, 2022, 12:24pm UTC](https://community.glideapps.com/t/make-array-the-newest-column-type/39540/32 "2022-08-05T12:24:44Z")
I seem to get the desired functionality of a basic array column for roles when I use Airtable. I create a table of users in Airtable and I have a separate table for projects. On the users table, I link to projects, and I can select many projects. I then use a lookup field on the projects, looking up a records id, and it gives me a simple looking comma separated values in Airtable. But in Glide, that list shows up as an array colum, but it doesnā€™t have the green highlight. And I can use it as a roles field, and it then allows me to add projects to a user in Airtable, and that then controls their access in Glide like a normal roles field, where project id is then a row owner field. Here are some screenshots to show what is happening. This is a pretty neat feature for controlling access to something like projects with a unique id. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/d/bd71e0b5bec170af8f5fb715396230a715869732.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/d/1d1c31fc7c5cf30115e868aa65adb9cf90902174.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/5/f5376a6c670c5747c8debe6ed37f1b6e0fda0985.png) ---
**Author:** ![Food2Soil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/food2soil/32/659_2.png) [@Food2Soil](https://community.glideapps.com/u/Food2Soil)\ **Post date:** [October 19, 2022, 8:57pm UTC](https://community.glideapps.com/t/make-array-the-newest-column-type/39540/33 "2022-10-19T20:57:58Z")
I am using this make array column to combine emojis from different columns. e.g. column 1 shows a āš” sign if certain conditions are true, column 2 shows a ā› sign is certain conditions are true. My Make array column is Column 3 and is combining Columns 1 & 2. Now I want to use the list component on this sheet and use the make array column as my image column. It only shows the first icon in Column 3 and not all the array components. So for e.g. if the make array has āš”ā› it will only show āš” in the image. How do I fix this so my list shows āš”ā› where there are multiple icons. ---
**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:** [October 20, 2022, 12:06pm UTC](https://community.glideapps.com/t/make-array-the-newest-column-type/39540/34 "2022-10-20T12:06:24Z")
Does it work if you use a joined list column to join the emojis? ---
**Author:** ![Food2Soil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/food2soil/32/659_2.png) [@Food2Soil](https://community.glideapps.com/u/Food2Soil)\ **Post date:** [October 20, 2022, 1:53pm UTC](https://community.glideapps.com/t/make-array-the-newest-column-type/39540/35 "2022-10-20T13:53:41Z")
Same issue with Join Array As well. Only the first icon of the list shows up. ---
**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:** [October 20, 2022, 2:22pm UTC](https://community.glideapps.com/t/make-array-the-newest-column-type/39540/36 "2022-10-20T14:22:38Z")
So these are a series of emojis in separate columns in a single row? I guess they must be if you were using MakeArray. Use a template column instead. ---
**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:** [October 22, 2022, 12:02am UTC](https://community.glideapps.com/t/make-array-the-newest-column-type/39540/37 "2022-10-22T00:02:25Z")
I think itā€™s just how the inline list handles the emoji as an image. It only takes whatever is first, so anything we do here wonā€™t work. I also think itā€™s hard to support 2+ emojis in a single image due to sizing problems. ---
**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:** [October 22, 2022, 12:36am UTC](https://community.glideapps.com/t/make-array-the-newest-column-type/39540/38 "2022-10-22T00:36:56Z")
oh, inline list - I missed that. Yeah, agreed. Youā€™d need to pre-prepare a separate image. Or maybe do something with Cloudinary. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 22, 2022, 1:15am UTC](https://community.glideapps.com/t/make-array-the-newest-column-type/39540/39 "2022-10-22T01:15:04Z")
Emoji is just text, so I guess I would just use a Template column to join the emoji columns together and display it in any list settings that accept text, such as Title, Description, etc. [Previous page](https://community.glideapps.com/t/make-array-the-newest-column-type/39540.md?page=1)