Write some Software

Objective: Create an addon that ties together google apps using google apps script (javascript): [login to view URL] Addon will take submissions from two separate similarly formatted google forms, log user submissions to a single google sheet, and create a formatted PDF that is emailed to designated admin emails as well as to the email address provided by the user of the form each time the form is submitted. PDF will also be saved in an admin designated google drive folder, and google form will auto-update crew lists upon editing of respective google sheets containing the crew lists. Essential Features: -Google form follows given example format. -PDF follows given example format. -Admin email addresses are designated on startup/installation of addon, and can be changed as necessary. -Directory that PDF’s are stored in is designated on startup/installation of addon, and can be changed as necessary. -On form submission PDF is emailed to admin email addresses as well as email address submitted by the user of the form. -On form submission PDF is saved in the admin designated google drive folder. -Each of the google forms auto-update upon editing of the respective crew list google sheets. -In case of error addon sends email to admin email address with description of failure (does not fail silently) -Master google sheet that both google forms are tied to will be created by google when tied to the forms. Must contain all info/responses submitted by users of both forms in a single google sheet. -Addon must be flexible enough to allow for changes in number/names of vessels and number/names of crew if form is changed. Google form formats, google sheet crew list formats, and PDF format can be found here: [login to view URL]