Please recommend new features for this module here

Comments

charlie-s’s picture

charlie-s commented

Currently it only supports spreadsheets, but would anyone want to see documents as well? I can't think of a situation where that would be helpful, but who knows...

TimelessDomain’s picture

TimelessDomain commented
  • Unique Values to Update Existing Content: Allow webform submissions to update preexisting rows in google spreadsheet by having a specific webform field marked as a unique value. Settings could include ignore, update or replace preexisting entries based unique value.
  • Multiple Value Formatting: Combine multiple values within a single multi-value webform field into a single cell on the google spreadsheet using any desired separator (ex. , or ||).
TimelessDomain’s picture

TimelessDomain commented

Webform to Google Documents would be amazing. Thanks csdco.

You may want to rename this module to "Webform to Google Drive" if you truly want to support more than spreadsheets long-term, otherwise "Webform to Google Spreadsheets" would be better.

More Spreadsheet Features

  • Conditional Destination Spreadsheets Per Webform: Allow users to choose which spreadsheet data should be added to. This could be completed in a similar way to conditional emails http://drupal.org/node/273806 (aka have the key value determine which spreadsheet it should go to).
  • Multiple Destination Spreadsheets Per Webform: Extend Conditional Destination Spreadsheets Per Webform to allow more than 1 destination spreadsheet.
  • Formatted Webform Field: Allow a custom html template with field tokens to determine the format of the google spreadsheet cells created by each field from the webform submission. Allow other fields tokens to be used in each field output. This could be accomplished in a similar manner to webform email templates http://drupal.org/node/1760332

Document Features

  • Formatted Webform Submission: Allow a custom html template with field tokens to determine the format of the google doc created/updated by a webform submission. This could be accomplished in a similar manner to webform email templates http://drupal.org/node/1760332

GDrive Features (docs, spreadsheets, etc.)

  • Add to Existing or New Doc (+ Select Existing Collection if New Doc)
charlie-s’s picture

charlie-s commented

I think the naming convention can be argued for all of those suggested – Google Drive, Google Docs, and Google Spreadsheet. I think Google Docs is best for now as Google Drive would suggest, to me at least, that submissions can also be stored as standalone blobs or something, whereas this module is only meant to deal with Google Docs as is historically accepted as "documents" and "spreadsheets".

I think updating records is cool, on the action that someone edits and submits a submission. This would probably only work with spreadsheets.

Multiple values is certainly a must. I would almost consider that a bug and it should probably be opened up as its own issue.

Other items sound interesting. I would certainly welcome patches :)

charlie-s’s picture

charlie-s commented

I'm going to add a couple more features that I need to implement asap for my own usage:

  • List fields (selects, radios, etc) should allow key OR label (or even both) to be saved to the spreadsheet; default machine names are not often useful.
  • Since GDocs can be temperamental about content being inserted – if the bottom-most "empty" row has a comment attached to a cell for example – and no content can be inserted, an administrator may want to be informed of such issues via email / rules trigger OR we need to find a more concrete way to insert a new row.
escoles’s picture

escoles commented

Does it already work with Fusion Tables? If not, that would be my suggestion.

charlie-s’s picture

charlie-s commented

It looks like Google's Fusion Tables lets you pull from existing spreadsheets, so I can't see why it wouldn't already work. This module just dumps your data into the spreadsheets.

sheila8stamp’s picture

sheila8stamp commented

My site is running on 7.4 but noticed this issue was tied to Drupal 6 but I very much like the suggestion that TimelessDomain had:

Multiple Destination Spreadsheets Per Webform: Extend Conditional Destination Spreadsheets Per Webform to allow more than 1 destination spreadsheet.

I have a complex webform that I want to send to different spreadsheets and this would work a treat.

You don't need it to be tied to the conditional destination spreadsheets surely? Just don't include the column title in the destination spreadsheet and it won't appear (or am I missing something?)

Thanks for a great module!

Sheila