I have 2 workflows for a Business process, one to send the Form to customers in a batch(i have a sql table with about 400 rows of data with the customer details. I fetch the email address and run the workflow so all the 400 customers get the forms) They are requested to fill the form and submit the form.
Once the form gets saved to repository after the submission i have another workflow process which gets executed based on the workflow rule. This workflow is used to update the SQL table with a specific value from the form.
If i need to send reminder emails to the customers who have not submitted the form, my original idea was to use the input parameters for initial trigger and reminder trigger and based on the values i can run the reminder branch in the first workflow. I have 2 branches (Init branch and remind branch in first workflow)
The first workflow send the forms to the 400 customers.
Second workflow picks the data from repository and updates the SQL table.
Where and how can i run the remind logic... the second workflow has access to the submission date but i need to run the remind branch in the first workflow.