Make Array is the newest column type in Glide that allows you to combine single values and/or array values to form a new array. There are a few use cases, but the main ones are: Combine images from a few different columns to create an image carousel: [CleanShot 2022-03-11 at 22.16.55@2x] Co…

Would you agree with the following written version: Turn a comma-separated list of n elements into a comma-separated list of p unique elements Comma-separated list (n elements) → Make array → Unique array → Join: result is comma-separated list (p unique elements) (The comma could be anythin…

[image] nathanaelb: Turn a comma-separated list of n elements into a comma-separated list of p unique elements I wouldn’t use Make Array in this case. I’d go: Split Text Unique Joined List I think if you pass a Joined List to Make Array, all you’ll get is an array of one item - which conta…

[image] 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.

Here’s a use case that saved me a bunch of columns :smiley: 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 m…

Here’s another one… [image] Math parameters min / max Feature Requests 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 Us…

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]

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

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]

@agung_Taufik you need a array column. A lookup column to create an array from your email column :point_up_2:

👪 Make Array — the newest column type!

Community Resources

Darren_Murphy April 4, 2022, 3:11am 24

Here’s another one…

Topic		Replies	Views
Write an array column (via Lookup) to Google sheet Report a Bug	42	4525	August 13, 2020
Array column is not created Ask for Help	5	549	May 5, 2021
🖼️🖼️ Glide Image Gallery and Multiple Image Picker — Now with Photo Rearranging! Community Resources tutorial	55	3275	June 12, 2025
Combining 2 identical columns into one Ask for Help	8	80	February 21, 2025
Is array column an option in glide tables Ask for Help	4	901	January 19, 2022

👪 Make Array — the newest column type!

Related topics