Email Settings & Features:
Understand how the tracking report system works.
1. Google Forms’ Default Spreadsheet Report
By default, Google Forms automatically generates a spreadsheet file that automatically updates the response timestamp:
This spreadsheet is automatically created by Google, and it is linked to your form. The sheet “Form Responses 1” of the file contains the timestamp and submitted responses:
2. How Performflow Reports Data on the Spreadsheet
2.1. Data on “Form Responses 1” Sheet
With PerformFlow activated on your form, the add-on automatically adds three more columns named Request #, Unique Request #, and Final Status to the “Form Responses 1” sheet:
- Request # shows the numbering of the request.
- Unique Request # shows the unique numbering of the request.
- Final Status shows the latest request status, including In Progress, Approved, or Rejected.
*Note: Do not edit this sheet to prevent the add-on from malfunctioning.
2.2. Data on “Detailed Approval Report” Sheet
Aside from three new columns on the “Form Responses 1” sheet, the add-on also creates a new sheet called “Detailed Approval Report”:
This sheet automatically updates all the approval data in real time, including each recipient’s approval status, comment, and approval time.
The sheet is set protected by default. You, as the form owner, can remove its protection status. However, it is highly recommended not to alter or remove any cell/column on this sheet since those actions may cause the report to malfunction.
*Overall, you do not have to do anything regarding the report spreadsheet because everything is automated.
3. How to Share Report Spreadsheet to Other Recipients
Only you, as the form owner, can see & edit this report spreadsheet by default.
If other recipients wish to view the spreadsheet, they must ask for your permission.
You can also intentionally share this spreadsheet with other recipients by clicking on the “Share” button on the spreadsheet. And if you want to allow recipients to view only, set those recipients’ authorization to “Can view.”