Hi friends! I don’t know if this a bug or a limitation but I try to understand why Glide doesn’t allow to write array column’s values created by a Lookup (multiple relation) to any Google sheet directly? I could create a dynamic list of selected items by a user using relations, templates and put a…

You can try out Join Texts on our staging instance . [2020-08-01 10.04.51] 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 arr…

Because probably Glide is not sure how we want that to be recorded in the Sheet. Do we want to combine them into one cell, or multiple cells from adjacent columns.

I just want it into one cell, it’s so simple! I don’t care the empty fields, only the fields with data as a list. I mean, if the lookup found: item 1 item 4 item 7 I’d like to have into a cell something like: item 1 item 4 item 7 With this I will make a party sure!! :tada: Thanks @Thi…

For reference: [image] Lookups from multiple realations @gvalero like @ThinhDinh mentioned in your other thread, there are probably several ways to approach that as far as how it should be treated. Do you save it as a comma delimited list (or some other type of delimite…

Hi again @Jeff_Hager Here I put a GIF to show you what I try to get (I know you hate GIFs but a set it to almost slow motion :smiley:) The steps are (sorry for Ping Pong effect that sometimes appears, it is like a plague) : You choose the restaurant (Firenze) See its menu to select dishes …

To @Wiz.Wazeer and @ThinhDinh I could read your posts and the little discussion about the script used in your APP and I understand both points of view. but I think Wiz was refering to use scripts in general to these cases and not to your specific script but anyway, l’m not going to re-open that …

@gvalero What is it that you need to with the array in the Google Sheet? What’s missing in Glide that requires that to be in the spreadsheet?

Mark, the problem we have been facing is a very simple one. We are not able to transfer multiple items created using a multiple relation to a new sheet via a lookup. Below is an example: Menu Sheet Customer X selects following items from sheet “Menu”: Item 1 (on row 1) Item 2 (on row 2) Item 3 …

Hola @Mark , thanks for replying My request is simple, as you know, a lookup is an array column with multiple values. Any lookup using a simple relation can be only used with a Template, Math, IF-Then-Else tool or into a single value component, this is understandable but what if the lookup uses a …

This makes me wonder if crossing the bridge between Glide Editor and GS is a difficulty for non-image Array columns in general. My challenge, for weeks, has been going in the opposite direction: Multiple TEXT columns in GS (heading 1, heading 2, heading 3) can’t be automatically merged as an Array …

@gvalero You want to write the array to the spreadsheet because you want to do some processing there with it that Glide can’t do right now, correct? What processing specifically is it that want to do with the array?

Write an array column (via Lookup) to Google sheet

Report a Bug

Jeff_Hager July 25, 2020, 9:45pm 4

For reference:

Topic		Replies	Views
Lookups from multiple realations Ask for Help	9	1135	July 25, 2020
Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help	125	14484	September 9, 2022
How to retrieve data after duplicating and relation in Google sheets Ask for Help	18	989	January 17, 2024
👪 Make Array — the newest column type! Community Resources tutorial	38	4764	October 22, 2022
Comma separated values in a single sheets column to drive the match multiple relations in Glide? Feature Requests	13	2321	February 9, 2020

Write an array column (via Lookup) to Google sheet

Related topics