Automated Workflow to populate form
I'm currently working on a solution to have a data condition on Sheet1 (ColumnA is set to "Ready for Submission") trigger an automated workflow to populate a form on Sheet2 with data from the triggering row in Sheet1. The only (potential) solve I've been able to think of for this is to have a workflow in Sheet1 to "Alert someone" when ColumnA is set to a given value, and within that alert build a URL to the form on Sheet2 with variables within the link meant to populate the form fields.
So effectively the flow would be:
1) User populates all necessary data in a given row.
2) Once complete, user update ColumnA to "Ready for Submission"
3) Workflow triggers an alert email which is sent to pre-defined person, and within that email is a URL to Sheet2's form with variables in the URL (ex: https://app.smartsheet.com/b/form/908324098230498234?var1=colB_val&var2=colC_val&var3=colD_val) that the user can click to take them to the auto-filled form.
4) They review data, click "submit" on the form.
My question is, is there a way to do this without the email, where upon changing the value in ColumnA a new window pops up for the URL mentioned in step 3, with the form pre-populated? I can't find a way to do this, so I'm guessing the answer is "no", but wanted to ask all the same. :) Thanks in advance for any insight you can provide!