-1

I currently have a google form which appends responses to an Excel format file. I have also attached a script to it which parses the response and emails the results...

Building on that, how would I do the following additional steps:

  1. Keep the current behavior which appends responses to the default EXCEL spreadsheet format file.
  2. Convert the default EXCEL spreadsheet format file to a file called allresonses.txt (CSV format)
  3. Saves the current responses as mytest.txt (CSV format) and have this emailed as an attachment. (Currently I am able to only add them to an email using my script)

Any help would be appreciated Thank you

JSDBroughton
  • 3,966
  • 4
  • 32
  • 52
user3407537
  • 51
  • 1
  • 13
  • Do you mean Excel(`.xslx`) or simply spreadsheet (Google Sheets) in the format of the responses output you mentioned? Also, take a look at this question and answer: http://stackoverflow.com/questions/15685975/google-forms-onsubmit – JSDBroughton Jan 11 '16 at 15:18
  • Hi Jonathan ..Thank you kindly for the reply .. I am actually trying to have the response(s) saved as CSV and then mailed as a CSV attachment.see original post for clarity ..Hope that helps – user3407537 Jan 11 '16 at 16:41

1 Answers1

-1

The solution is to use scripts , I check the google forms script examples. Quick walk through: 1. Just create a form in google forms and add your questions. 2. Create a script on the add script page (of course google for the correct script or check the developer forum examples) 3. While the default is a spreadsheet format you can select one of the supported types (again I check the google developer examples,they're somewhat dated but do still work.)

All sorted now.

Thank you

user3407537
  • 51
  • 1
  • 13