Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Use Google Drive & R to Build Questionnaires and Reports

DZone's Guide to

Use Google Drive & R to Build Questionnaires and Reports

· Big Data Zone
Free Resource

Need to build an application around your data? Learn more about dataflow programming for rapid development and greater creativity. 

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



      Check out the Exaptive data application Studio. Technology agnostic. No glue code. Use what you know and rely on the community for what you don't. Try the community version.

      Topics:

      Published at DZone with permission of Kay Cichini, DZone MVB. See the original article here.

      Opinions expressed by DZone contributors are their own.

      THE DZONE NEWSLETTER

      Dev Resources & Solutions Straight to Your Inbox

      Thanks for subscribing!

      Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

      X

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

      {{ parent.tldr }}

      {{ parent.urlSource.name }}