Display Google form results within a slide
Jul 29, 2015
By
Dan Toomey
Hi everyone,
I have seen a couple examples of using Google docs/forms and displaying the results in a spreadsheet, although I would like to have the learners take a poll and have the results aggregate to an up-to-date data set that is embedded in the next slide. I have been able to add the responses as a link that opens in a new window but have been unable to embed it within a slide.
Kind of like this:
Slide 1 - learner enters data in Google form
Slide 2 - learner responses embedded in slide
Any thoughts?
Thanks,
Dan
6 Replies
In both cases, you could try displaying the form(s) within Storyline web objects. Here is some info on options.
Thanks Michael I did try that yesterday with no luck on the responses but today it does appear to be working! I think it was a permission error.
I can see the results in spreadsheet form, but wonder if it is possible to present the data as a chart?
Thanks Daniel for the update on working within Google docs - I don't know if they have an option to display the information in a chart, but if you get it set up, you'll want to link to that as a web object as well.
Best of luck!
Hi Daniel,
I think I have done something similar to what you mention in a test I created a few weeks ago.
I have some sample data in a Google sheet
In a sub sheet I take the data and put it into a simple bar chart
I then published this sheet to web (the downside to this is that it takes 5 minutes to refresh and update the published chart with new data.)
I then took this URL and put it into a web object within S2
Nice Darren - thanks for sharing that here. Looks really good!
Thanks Darren! We are looking for real time feedback, but this is appealing and could be a solution for what we are hoping to do. The 5 minute update is still pretty close, and will get us much closer.
I appreciate the helpful feedback!
Dan
This discussion is closed. You can start a new discussion or contact Articulate Support.