# Write to sheet based on form selected

**URL:** <https://community.glideapps.com/t/write-to-sheet-based-on-form-selected/9405>\
**Category:** Ask for Help\
**Created:** [May 19, 2020, 5:24am UTC](https://community.glideapps.com/t/write-to-sheet-based-on-form-selected/9405 "2020-05-19T05:24:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![pluhg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pluhg/32/177_2.png) [@pluhg](https://community.glideapps.com/u/pluhg)\
**Post date:** [May 19, 2020, 5:24am UTC](https://community.glideapps.com/t/write-to-sheet-based-on-form-selected/9405/1 "2020-05-19T05:24:07Z")

</div>

Hello All! I would like to have three from buttons on one screen and have a value written to my sheet based on the form selected. So If I have Forms X, Y and Z, if the user selects form Y then Y is written to a cell in my sheet on the same row that the data in the form will be submitted. Is there a way to do this?

Thanks!

---

<div class="post-metadata">

**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\
**Post date:** [May 19, 2020, 7:31am UTC](https://community.glideapps.com/t/write-to-sheet-based-on-form-selected/9405/2 "2020-05-19T07:31:03Z")

</div>

Create 3 single value columns in your data editor having values X, Y and Z.  
Then in each form button, push this single value column data in your required cell using the “columns” component in forms.