We would like to have the data sent to the Google Spreadsheet to match, both in column order and formatting, the output of the Results/Download. This way we can use an initial download as a template for the Google Spreadsheet.
1. Create a Webform.
2. View, enter data and submit the Webform.
3. Go to Results/Download for a Webform. Using the defaults, and download the current results.
4. Upload these results to a Google Spreadsheet.
5. Under Setup/Email Handlers... Setup the Webform to now submit results to the url of the Google Spreadsheet.
I've created the following patch to handle this.
The patch could use some additional work in how it gets the list of fields. What is done in adjustFields() is a bit of a hack. :) Perhaps this is more an issue of the core Webform methods? Or... my lack of knowledge in some around this area. Any help is more than welcome.
Closed: outdated
2.0
Code
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.