Multi-Step Workflow: Creating and Linking Forms with Unique Identifiers
I'm trying the following in Smartsheet:
1. Create a form that has a field to input multiple emails, each submission has a Unique ID.
2. When the form gets submitted, it will send an email to the emails in the submition with a new form of a different sheet.
3. Once the second form is filled by the email receiver and submitted, a new row is created in the second sheet with the Unique ID of the first sheet.
I'm able to do 1 and 2, but I can't figure out how the piece in 3 could be created. Is it possible to achieve this with Smartsheet? Maybe with the help of Data Shuttle, DataMesh, Dynamic View?
I also thought that it might be possible to create new rows in the second sheet for each email recipient in the first form, and then send a form based on that second sheet. But, I don't know how to trigger the creation of new rows that would contain the Unique ID.
Any help would be immensely appreciated.
Help Article Resources
Check out the Formula Handbook template!