# Using form buttom to edit row in sheet?

**URL:** <https://community.glideapps.com/t/using-form-buttom-to-edit-row-in-sheet/3507>\
**Category:** Ask for Help\
**Created:** [January 10, 2020, 10:39pm UTC](https://community.glideapps.com/t/using-form-buttom-to-edit-row-in-sheet/3507 "2020-01-10T22:39:09Z")\
**Posts on this page:** 1\
**Showing post:** 3

<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 10, 2020, 11:03pm UTC](https://community.glideapps.com/t/using-form-buttom-to-edit-row-in-sheet/3507/3 "2020-01-10T23:03:51Z")

</div>

Technically no, it’s not possible. But there may be a hacky way to do it. You could add a form button, pull in existing vision statement and user’s email, then provide an entry field to enter a new statement. This information will be submitted to a new sheet. Using the formula in the attached thread, you can pull the the most recent statement from the form response sheet and insert it into the user record. Unfortunately, I don’t think the formula is Arrayformulas friendly, so you would have to copy the formula down all of the user record rows.

> [@Display the latest item from my sheet](https://community.glideapps.com/t/display-the-latest-item-from-my-sheet/1141/2):
>
> Yes, this formula returns the last item that matches a search value: =IF(ISERROR(ARRAYFORMULA(LOOKUP(2, 1/(PhotoChoiceResponses!A$2:A=A3), PhotoChoiceResponses!B$2:B))), "", ARRAYFORMULA(LOOKUP(2, 1/(PhotoChoiceResponses!A$2:A=A3), PhotoChoiceResponses!B$2:B))) This is what I use in the Photo Choice example in [https://concepts.glideapp.io/](https://concepts.glideapp.io/) Here is a simplified version with the conversion from ( , ) to ( ; ) for you: =ARRAYFORMULA(LOOKUP(2; 1/(FormResponseSheet!A$2:A=A3); FormResponseSheet!B…

---

_[View the full topic](https://community.glideapps.com/t/using-form-buttom-to-edit-row-in-sheet/3507)._
