Big Data/Analytics Zone is brought to you in partnership with:

Kay Cichini (MSc, Biology), Nature Protection Expert, Tyrol/Austria. I'm author of theBioBucket-Blog, where I share examples for data management, data processing, statistical analysis and report generation using the R-Software. Kay is a DZone MVB and is not an employee of DZone and has posted 28 posts at DZone. You can read more from them at their website. View Full User Profile

Use Google Drive & R to Build Questionnaires and Reports

09.19.2012
| 5156 views |
  • submit to reddit
Here's how I did it in 3 easy steps:

(1) Set up a form in Google Docs/Drive.

(2) Choose "Actions" and "Embed in Website" to get the URL for the iframe and put it in a post, like below. Then, go to the spreadsheet view of the form on Google Docs/Drive and set the share option to "everyone with the link" or "public" and copy the document key from here.

(3) Make a report with knitr in R using the responses that were put to a spreadsheet at Google Docs/Drive. Do (knit) something like THIS to produce a markdown-file, i.e. (I pushed the md-file to Github for publishing -- see it rendered to HTML HERE).



      Published at DZone with permission of Kay Cichini, author and DZone MVB. (source)

      (Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)