👪 Make Array — the newest column type!

[Robert_Petitto]

@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.

[Darren_Murphy]

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

[Robert_Petitto]

That’s a real neat use case!

[Darren_Murphy]

Here’s another one…

Math parameters min / max

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

[agung_Taufik]

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?

[Darren_Murphy]

Two columns:

• A lookup column to create an array from your email column
• Then use the Unique Elements 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.

Transpose Columns to an Inline List: The Miracle Method

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]

[agung_Taufik]

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**

[Dilon_Perera]

@agung_Taufik you need a array column.

A lookup column to create an array from your email column

[agung_Taufik]

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

[Dilon_Perera]

You can watch this video. Robert shows how to do this!

Make Array — the newest column type!

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?

[Robert_Petitto]

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.

Could also clean up the City & State columns with Text Plugin columns first to make sure they’re capatilized.

[morgan]

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.

[Food2Soil]

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.

[ThinhDinh]

Does it work if you use a joined list column to join the emojis?

[Food2Soil]

Same issue with Join Array As well. Only the first icon of the list shows up.

[Darren_Murphy]

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.

[ThinhDinh]

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.

[Darren_Murphy]

oh, inline list - I missed that.
Yeah, agreed. You’d need to pre-prepare a separate image. Or maybe do something with Cloudinary.

[Jeff_Hager]

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.