# Could not send a "Lookup" column by Form and workaround

**URL:** <https://community.glideapps.com/t/could-not-send-a-lookup-column-by-form-and-workaround/4000>\
**Category:** Report a Bug\
**Created:** [January 27, 2020, 9:11am UTC](https://community.glideapps.com/t/could-not-send-a-lookup-column-by-form-and-workaround/4000 "2020-01-27T09:11:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![gshirato](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gshirato/32/2795_2.png) [@gshirato](https://community.glideapps.com/u/gshirato)\
**Post date:** [January 27, 2020, 9:11am UTC](https://community.glideapps.com/t/could-not-send-a-lookup-column-by-form-and-workaround/4000/1 "2020-01-27T09:11:22Z")

</div>

Hey guys,

I encountered this problem in Form, which is I couldn’t send a data column to the spreadsheet (it made an empty cell) if the column is created by “Lookup” of a relation.

Then I found it works correctly if I use the column as a component.

As a workaround, because I did not make it appear, I made a template of `<!--ID-->` where `ID` is the column I wanted to send to the spreadsheet. Then I used the template as a component of the form.

Finally, boom!!

I am posting this because I thought a data column alone should be sent to the spreadsheet correctly in the first place.

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [January 28, 2020, 1:04am UTC](https://community.glideapps.com/t/could-not-send-a-lookup-column-by-form-and-workaround/4000/2 "2020-01-28T01:04:13Z")

</div>

Are you saying you want to set a column from a form that takes its value from a Lookup column?

Could you maybe share an app where you do that and it doesn’t work?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 31, 2020, 3:38am UTC](https://community.glideapps.com/t/could-not-send-a-lookup-column-by-form-and-workaround/4000/3 "2020-01-31T03:38:27Z")

</div>

I don’t seem to have a problem doing this, unless I’m misunderstanding what you are trying to do. I have a main sheet with a lookup column that gets a value from a different sheet. When I am viewing the details of an item from the main sheet, I create a form button and then I add a COLUMNS component that contains the value from the lookup. When I submit the form, that value is added to the sheet.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 13, 2020, 7:23pm UTC](https://community.glideapps.com/t/could-not-send-a-lookup-column-by-form-and-workaround/4000/4 "2020-02-13T19:23:20Z")

</div>

@gshirato

I’m encountering this same issue. Your trick didn’t work for me. Take a look at my posts here:  
[https://community.glideapps.com/t/bug-with-sending-data-via-form-button-from-a-lookup-column](https://community.glideapps.com/t/bug-with-sending-data-via-form-button-from-a-lookup-column/4572)