Write an array column (via Lookup) to Google sheet

but the solution is close @Mark!! (well, depending on of effort to make changes in Glide code). Here my 2 cents:

  1. 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)

  1. 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!

image

What do you think Mark?

Saludos y feliz fin de semana!

1 Like