Em Andamento

Create a Google Apps Scripts library that will email Form Responses

Hi,

I am in need of a Google Apps Script that will complete the following tasks once a Google Form response has been received to a Google Sheet:

- A 'confirmation' email is sent to the form submitter, showing all of the information that has been submitted. The email must use a Google Doc as the body template for easy editing.

- A 'response received' email is sent to one (or more) administrators, showing all of the information that has been received. Email addresses for the administrators should be stored in a new worksheet in the Google Sheets response file. The email must use a Google Doc as the body template for easy editing.

The Google Doc template will be something like this:

---------------------------------------

Hi <<Your Name>>,

Thank you, your form response was received on <<Timestamp>> and the a copy of the information submitted is below for your records.

<<Field Name>> :: <<Field Value>>

Regards,

Webmaster

---------------------------------------

There will be lots of forms that need to have this functionality so the main chunk of the script needs to be made in to a library script.

Habilidades: Google App Engine, Javascript, Desenvolvimento de Software

Ver mais: script sheets, scripts google forms, script google forms, library template, google scripts forms, google apps javascript, google apps email, template library, apps scripts google, apps script google, google sheet script, google forms scripts, google form scripts, responses, library information, google sheet, google forms, google doc, google apps, google apps scripts, google apps script sheets, apps script, apps install, javascript form copy, easy library

Acerca do Empregador:
( 3 comentários ) Hamilton, New Zealand

ID do Projeto: #6819464

Premiar a:

thanhhungqb

Dear sir, I am expert on Google Apps Scripts. I have just finished one that work with spreadsheet. You can see a demo send file from spreadsheet with content here: https://docs.google.com/spreadsheet/ccc?key=0Aj_aD Mais

$8 NZD / hora
(21 Avaliações)
3.9

2 freelancers estão ofertando em média $12/hora para este trabalho

margericcisq29

A proposal has not yet been provided

$16 NZD / hora
(0 Comentários)
0.0