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.



  • Dale Murphy
    Dale Murphy ✭✭✭✭✭✭

    @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.