Addon will take submissions from two separate similarly formatted google forms, log user submissions to a single google sheet for both forms, 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.
-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 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:
[url removed, login to view]
For the auto-update from Google Sheet feature above please see the existing and available addon 'FormRanger'. An auto-updating version of this functionality included in the addon you will be writing is what is required for this project. Form Ranger can be found here: [url removed, login to view]
For the admin email and directory designation on startup features above please see the sample addon 'Form Notifications' which implements this functionality and is a good starting point. It can be found here: [url removed, login to view]
The budget for this project is not to exceed $125.00. This is a fixed amount that will be paid when all requirements are met. If you bid below this amount I am more likely to award this project to you, depending on experience. This project requires prior experience with the Google apps Drive, Docs, Sheet, Gmail and Forms, as well as google apps script which ties these apps together. The project is tied directly to the form in the description, and edit access will be granted when project is awarded.
DO NOT TRY TO SUBCONTRACT THIS PROJECT. This is an unfair practice for everyone on Freelancer - the person who does the work will receive 100% of the profit, no middleman. I will deal only with software author directly. Re-posting this project or other untrustworthy actions will result in project cancellation. We will be working together, and trust in this working relationship is as important as the final product.