# Write an array column (via Lookup) to Google sheet

**URL:** https://community.glideapps.com/t/write-an-array-column-via-lookup-to-google-sheet/13062
**Category:** Report a Bug
**Created:** [July 24, 2020, 8:13pm UTC](https://community.glideapps.com/t/write-an-array-column-via-lookup-to-google-sheet/13062 "2020-07-24T20:13:30Z")
**Posts on this page:** 1
**Showing post:** 32

<div class="post-metadata">

### Author: ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [August 1, 2020, 4:44pm UTC](https://community.glideapps.com/t/write-an-array-column-via-lookup-to-google-sheet/13062/32 "2020-08-01T16:44:25Z")

</div>

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)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/13c0e3794628cea0bb76c279b7230480eb901a5c.png)

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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/041f469782fa7eaf2c82e7ab9bb786da247c7708.png)

What do you think Mark?

Saludos y feliz fin de semana!

---

_[View the full topic](https://community.glideapps.com/t/write-an-array-column-via-lookup-to-google-sheet/13062)._