Closed

Write some Software

This project was awarded to abdulghaffar11 for $100 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
4
Project Description

Objective: Create an addon that ties together google apps using google apps script (javascript): [url removed, login to view]

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:

[url removed, login to view]

Awarded to:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online