Leveling Up Update Requests
One of the features of forms that I use frequently is the ability to add a "hidden field" with a value that is written to the sheet upon submission. This is really useful when performing a simple evaluation of form submission completion to trigger actions in workflows, for example.
However, in contexts where I have a multi-step intake process (multiple parties are providing intake details), I lose access to forms functions on step 2 and greater and instead have to use the update request within the workflows.
I would like the ability to trigger an invite to fill in a form for an existing row in a sheet from a workflow.
The logic might look something like this:
1) first user clicks form #1 link and submits fields 1,2, and 3, field 4 is hidden and is just a simple counter that is set to "1" to indicate the initial form submission is complete.
2) the automated workflow recognizes the new row submission and triggers an invitation to user #2 to complete form #2
3) form #2 will display fields 1, 2, and 3 but all three fields are locked, fields 5, 6, and 7 are open for user 2 to complete, etc. Additionally, field 4 will be set to "2" to indicate step 2 form submission is complete.
This is a simple example. However, with this enhancement, I'm really looking to unlock all the features of the forms but on an existing row. We can call it "leveling up" the update request capabilities :-).
I'm imagining being able to send multiple 'step 2' form invites (or several layers of invites) out based on the completion of step 1 intake form, add hidden fields to the 'step 2' forms with values that are written to the sheet upon submission, and update and add to existing rows (replacing the existing update request capability).