How can I update a row's information using a form?
I have a sheet that identifies each submission by a submission number. If I use that submission number as the "matcher" how can I update the other columns in that submission number row? I created a form but it only adds rows at the top. However, my coworkers will be using this and they won't have access to the sheet so I need an easy way for them to update the submission status and other columns related to that submission number.
Answers
-
@jhorvath Forms always insert new rows (you can control whether the row is at the top or the bottom.
For similar scenarios I have addressed, I usually create a report that shows the coworkers the information they need to see, and allows them to modify the specific columns.
The other approach is to use Update Request workflow, but your description doesn't make that seem suitable.
dm
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives