# 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:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![alittle116](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alittle116/32/2623_2.png) [@alittle116](https://community.glideapps.com/u/alittle116)\
**Post date:** [January 10, 2020, 10:39pm UTC](https://community.glideapps.com/t/using-form-buttom-to-edit-row-in-sheet/3507/1 "2020-01-10T22:39:10Z")

</div>

Is it possible to use a Form Button to edit the content on a page?

In this career coaching app (screenshot attached), every user has a personal “Vision Statement” on their home screen. Instead of relying on the Edit button in the upper-right, I would like to use a large button to edit this row.

Is it possible for the “Update Vision Statement” button to open a form that edits the text above it?

 ![Screen Shot 2020-01-10 at 2.36.33 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9a87793d2a89f514ec97caba293cdad85d77ba30.png)

---

<div class="post-metadata">

**Author:** ![alittle116](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alittle116/32/2623_2.png) [@alittle116](https://community.glideapps.com/u/alittle116)\
**Post date:** [January 10, 2020, 10:45pm UTC](https://community.glideapps.com/t/using-form-buttom-to-edit-row-in-sheet/3507/2 "2020-01-10T22:45:48Z")

</div>

If this is not possible, let me know so i can add it to the feature requests 🙂

---

<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…