Update column with new form submission


I was wondering if it was possible to update a column when a user submits a new form within my app.

For example, I have a column labeled “Status” and when the form is submitted I want the Status column to automatically update to “In Progress” (the status column is not a user inputted field on the actual form).

It seems like that should be doable, but I’m not seeing how I can make it happen.

Any ideas or help would be super appreciated.

Thanks in advance!

1 Like

Create a template column with the value ‘In Progress’ within the sheet of the tab that contains the form button. Then pass that column using the Column Value components, in the form, to your form response sheet.

1 Like

Thanks, @Jeff_Hager

1 Like