The “Join” computed column would operate on an array column. It takes one column as input, namely the array.
what you call “Join” computed column is a Template column?
Let me understand you step by step with basic questions to be happy 
Saludos @Mark
1 Like
It’s not a Template column - the Template column already exists.
It’s somewhat similar to a Rollup. You would give it your LK_ListaPlatosPedidos column, and tell it to use a newline to join it. Then for each row it would produce a single text that has all the items in the LK_ListaPlatosPedidos, one line for each. That’s exactly what you want to write to the sheet, right?
1 Like
yes Mark!
My LK_ListaPlatosPedidos column (lookup) is what I want to use and write to GS.
Another question: your “Join” computed column is something new in Glide or what?
No, it doesn’t exist yet, I’m just brainstorming a solution.
1 Like
I think Our dream coming true, soon. 
but the solution is close @Mark!! (well, depending on of effort to make changes in Glide code). Here my 2 cents:
- To allow a Template column to work with Lookup (single or multiple relations). I know the blank spaces inside array can generate a headache (e.g: Red, , Green, , , Blue , , ) to understand/handle the result but if those spaces can be eliminated we could have a clean list ready to work in anywhere (Red,Green, Blue)
- As I wrote days ago, an array column with multiple values can’t be used with a Template, Math or IF-Then-Else tool and this is understandable but why can’t it be written to GS using a Form’s column?
If you remove the restriction that forbids to use a multiple relation lookup with a column in a Form component, the solution is almost done!.
It’s is my favorite option!
What do you think Mark?
Saludos y feliz fin de semana!
1 Like
You can try out Join Texts on our staging instance.
It works very much like a Rollup, but you can also specify a separator. If you use just a newline as the separator you won’t see it in the Data Editor, but it’ll be there if you save the column to a sheet.
Writing the array column to the spreadsheet is not just a “restriction” we can remove. Google Sheets don’t support arrays, so we’d have to decide how to write them. For example, how to separate individual values, which Join Texts lets you do 
10 Likes
Well, it looks fantastic and if I can use a newline as the separator, it looks even better!!!
When may I celebrate with a party? How long do I have to wait to have it in production? 
Gracias @Mark
1 Like
I can’t make any promises. I hope sometime next week.
5 Likes
Oh my goodness. This is awesome.
2 Likes
Can we also build in rank/sort as part of the array to make sure the names are joined in some organized fashion?
3 Likes
I 100% have a use for this. Looking forward to it. Thank you!
2 Likes
Hey @Mark…Would it be difficult to build the reverse join (ie “split”)? I have a column of comma separated values in a single cell, but I need Glide to recognize it as an array column. Thoughts?
1 Like
@Robert_Petitto Could you describe the exact use case, please? Where do those comma separated values come from, and what do you want to do with them once they’re split?
Sure thing!
Currently, three scenarios from which they’re created:
1.) from a transposed concatenation of rows
2.) from a many-to-many export from an external database (eg Airtable)
3.) from a checklist question in Google forms
I want to be able to create relations using these comma separated values. This can only be done using an array column—otherwise the cell wouldn’t find a match.
Example: a comma separated list of Item Ids. I want to relate each ID to its respective details page. I can’t simple create a relation from the Comma separated list in the cell to the sheet.
Currently, I have to first split the values into their own columns using a =SPLIT() formula and then manually create each column header as item_id 1… item_id 2…etc. While this works, it’s not dynamic as I have to ensure there’s a column header for each column whenever a new value is added to the comma separated list.
A Split-to-Array Column would solve these issues. Either that or “simply” allow a comma separated list in a cell to be recognized as an array column? Just like how timestamps/dates and number columns can be formatted…allowing us to mark whether a comma separated list should be an array column? Just thinking out loud.
As always, appreciate all the work and innovation you bring!
Bob
4 Likes
Do those comma separated values ever contain commas themselves? How is that handled?
2 Likes
If they do, then that’s pretty poor formatting on the part of the data entry. I’d assume in that scenario, the user wouldn’t be looking to create an array column of the data. Take for instance a block of welcome text:
Welcome, Bob! On behalf of everyone here, we hope you have a delightful experience. Remember to watch, like, and subscribe to our YouTube channel, too!
5 commas…this is not CSV 
1 Like
Anyone else want this feature and can chime in?
2 Likes
As a matter of fact! 
It will be usefull when you use a Google Form to collect data, GF has Multiple Choice as an option and the answer is saved to one cell as comma separated values. This is a smart and simple solution but try to load that data to Glide and use it later is another tale.
Thanks @Robert_Petitto for reminding me this!
Saludos!
1 Like