Allow selected people to validate or reject the file generated.
Time to complete
Between 5 min & 10 min to set up
Created a google forms and configured Form Publisher (Learn more)
1 - Add Validators
To use this option you should choose validators to approve your files.
Click on the add-on menu icon, then 'Form Publisher' and 'Sharing Options & Notifications' and add validators.
Remember to click on the button “ADD”
Important: All people in your list can approve or reject your files.
2 - Activation option “Validation workflow”
In the sidebar “Sharing Options & Notifications, activate option “Validation workflow”
3 - Create the named ranges in your responses spreadsheet
First, be sure that a Google Form is linked to your spreadsheet. If it's not the case, please check Google documentation to know how to do so.
Form Publisher will write in your responses spreadsheet the status “PENDING”.
Create a new column called exactly “[Form Publisher] Validation”
Then define the named ranges for the two following columns.
|Name of the column (column header)
||Name of the Named Ranges|
|[Form Publisher] Validation||FormPublisherValidationURL[+]FORM_ID|
You can find the FORM ID in the URL of the Google Form: https://docs.google.com/forms/d/FORM_ID/edit?usp=drive_web#responses
You have to remove any dashes (-) in the form ID before copying and pasting it in the Named ranges!
For example, in the following image:
The Form ID is: 1yeieX42b3Kb9OGPodGCevRIaRGv-UmErh_w7JoyZX5I
So the Named ranges for the timestamp is, after removing the dash:
To define a named range, go to Data > Named Ranges... > Add a range:
4 - Test the validations
First, you need to submit your form.
1 - Approve or Reject the response
Following the submission by the responder, the validators receive a confirmation email with two buttons “Approve” and “Reject” :
To test the configuration, select one of the two options.
2 - Check your responses spreadsheet
Check your responses spreadsheet