How to change cell information using a Form

I have a sheet that the first row filled in using a form (Intake). At some point data in one column may change. I need to create form that will modify the cell content of row 1 to a new contact but leave all of the other data in place.


Anyone have an idea on how to accomplish this?

I have tried creating a form but all that does is add a new row. While that would work the individual that would complete the change form does not have access to see all of the other Meta data. So would not know who to assign in the other fields.

Best Answer

  • Austin Smith
    Austin Smith ✭✭✭✭✭
    Answer ✓

    @MSGFreebird

    You'll need to manually push or set up an automation that issues an update request to whomever you're seeking the data from. You can make these triggered in automations as needed. You can also manage the viewable data in a recurring automation template.

    Forms always only create a new row. They can not be used otherwise.

Answers

  • Austin Smith
    Austin Smith ✭✭✭✭✭
    Answer ✓

    @MSGFreebird

    You'll need to manually push or set up an automation that issues an update request to whomever you're seeking the data from. You can make these triggered in automations as needed. You can also manage the viewable data in a recurring automation template.

    Forms always only create a new row. They can not be used otherwise.