Forum: The Racing Rules of Sailing

Rev #2: Online Protest Form/System using Google Forms, Docs and Gmail (this version fills in a Google Form that looks like a protest form with the back-page included too!)

P
Angelo Guarino
Nationality: United States of America
Certifications:
  • Judge In Training
  • Fleet Measurer
I figured-out how to populate a Google Doc with the Online Protest-Questionnaire results.  The questionaire is basically the same, but now instead of just sending an email with the answers in HTML, this version fills-in a Google-Doc version of a standard Protest/Redress/Reopen form. 

Here is an example of what a completed form looks like (as well how the doc is auto-named): Protest by Boat against Boat & Request for Redress - 2019 Regatta Cup - FiledBy: Angelo Guarino

This version of the protest system is live now so feel free to play with it.

To get to the form you can either click this link: Protest Form (Google Doc) or send an email to protestform@gmail.com with the word "form" anywhere in the subject (it will email you a link .. easy to remember that way).

To get a real feel for how the form works, and to populate the form most fully, I'd recommend choosing Boat v Boat and Redress (others work as well) and also use real names etc .. not just gibberish 

Couple things to take note of:

  1. You MUST put in a valid email address for yourself, otherwise you will not receive the complete form!
  2. Email will come from the "RepName", but will be sent from protestform@gmail.com
  3. If you supply an email-address for the Race Office as detailed in the SI's, it email the submitter's email and "cc" the Race Office.  The Race Office email is not required.
  4. The ReplyTo field of the form email is set to the Rep's email address.  Therefore responses will go to the filer-email address automatically, not back to protestform@gmail.com
  5. The subject of the email will be the combination of: 'Type-of-Filing' - 'EventName' - RepName: 'Rep-Name'.  So you can see just from the subject the what/where/who
  6. The email will have a link to the completed Google-Doc (set to view-only).  Anyone with the link can view the doc without signing-in to anything so the email can be forwarded to others and shared.
  7. You can Download the completed Protest- Form as any of the following formats (as well as print of course) 

As it turns out, Google doesn't count native Google Docs/Sheets against your storage quota, so basically the storage is unlimited in quantity and time.

Feel free to provide feedback.

Ang
Created: 19-Jul-20 16:19

Comments

P
Angelo Guarino
Nationality: United States of America
Certifications:
  • Judge In Training
  • Fleet Measurer
0
Here is a direct link to a blank version of the Google-Doc Protest Form. Blank Protest Form
Created: 19-Jul-20 17:42
P
Angelo Guarino
Nationality: United States of America
Certifications:
  • Judge In Training
  • Fleet Measurer
0
OK .. I think I'm "done" (famous last words).  I'm just going to leave the system up "live".

The email that is generated has both the filled-in form (that looks like a paper form) as well as a simple table of the Q&A at the bottom (belt + suspenders).  I figured this way, if there was a problem with the form, or the Race Office's internet goes down after receiving the email, the original email will still contain the info to process the filing.

To get to the Q&A Automated Protest Form. you can either click this link: Protest Form (Google Doc) or send an email to protestform@gmail.com with the word "form" anywhere in the subject (it will email you a link .. easy to remember that way). 

Let me know if you find any bugs or typos (I'm sure there will be both).
Created: 19-Jul-23 18:27
[You must be signed in to add a comment]