We put in place the possibility to process manually as today this is the only work-around possible if triggers stop working on your current spreadsheet.
To process manually:
- Refresh Form Workflow sidebar
- Click on "Not Processed". This will generate a FW - ID number and a new email will be sent to reviewer requesting approval.
Link your Form to a new spreadsheet
The other option is to link your Form to a new spreadsheet to activate triggers once again. You will need to activate the add-on on this new spreadsheet and set up your reviewers.
1. On your current spreadsheet, choose Form // Edit Form. On your Form click on Responses then the 3 dots to the right.
2. This will open the page where you can "Choose response destination"
3. Choose "Create a new spreadsheet"
Click on "View responses in Sheets"
4. All your Form responses will be copied to this new spreadsheet. Delete these rows as all responses with Form Workflow status will be on your former spreadsheet.
If you do not delete rows that have been copied to your new spreadsheet new Form Workflow IDs will be generated and emails sent to reviewers for approval.
All rows left on the new spreadsheet will have new Form Workflow IDs generated when the first Form is submitted for approval.
5. Start processing your Form responses on this new spreadsheet