Over a million developers have joined DZone.
Platinum Partner

Use Google Drive & R to Build Questionnaires and Reports

· Big Data Zone

The Big Data Zone is presented by Exaptive.  Learn how rapid data application development can address the data science shortage.

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).



      The Big Data Zone is presented by Exaptive.  Learn about how to rapidly iterate data applications, while reusing existing code and leveraging open source technologies.

      Topics:

      Published at DZone with permission of Kay Cichini , DZone MVB .

      Opinions expressed by DZone contributors are their own.

      {{ parent.title || parent.header.title}}

      {{ parent.tldr }}

      {{ parent.urlSource.name }}