Iterate through collection

Hello, I would like to know if there is a way to iterate over a whole collection (Glide table) to compute an output (in experimental code, passing the array of items ?)
Thank you !

We might need to know more about your use case, but you can pass an array to the code column as an input.

You either have to do a lookup to create an array, or a split text.

2 Likes

Thank you very much for your reply !
If I want to create a column array (in the same table) containing all of the letters of this one column (below), how may I do ?
image

Because it seems that the lookup only returns this one letter from the same row and does not append it

How are you creating that relation? The end result should be something like “H, M, L, H, H”?

Yes exactly ! This is how the relation is configured


Thanks so much

image

I think you can add a lookup to return the “ID” and then a join text column to return a list of all characters.

1 Like

Thank you so much for such help !!
However, there is something I don’t get … It does not show me ID Lookup in the list …


With a joint list, you can combine all the previous Lookup ID columns.

1 Like

Got it ! I had to create two joined lists, I don’t know why … But it works. A huge thanks !

1 Like

As a metter of fact, it does not detect the joined lists columns as arrays …

Use the split text to break the join list into an array first before you use the reverse array.

2 Likes

Seems like your relation was a multiple one. I assume there will ever only be one match so I used a single relation.

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.