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!