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
-
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
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives