How to create a leader board that automatically updates results?

Jan 20, 2014

Good Morning Heroes, 

I am wondering if there are any features available in Storyline that allow me to have a leader board slide displaying quiz results for all users at the end of a game as up to date as possible.  So for instance, I have my learners enter their name at the beginning of the "quiz" and track their results.  But I'm not a programmer so I don't know if I can automatically update a list with user name and scores like a leader board.  The only thing I can think of is to add a web object linked to a page I manually update with results.  This of course would only be updated as I can keep up with it during the day/week.

Any ideas?  We are trying to really hone in on sales enablement the first half of this year, and what gets sales moving like a little competition!

Thanks!

10 Replies
Michael Hinze

One option may be to use a GoogleDocs spreadsheet to track and display the results. This options does require some programming, see here for info: http://community.articulate.com/forums/t/22519.aspx

And here is an example that uses a GoogleDoc to capture and display user 'votes': http://dev.keypointlearn.com/xcl71_SL/Soccer/story.html

Michael Hinze

Kristin Shantz said:

Michael - This is a fantastic example!  Thank you so much for sharing.  I wasn't searching for the right terms this morning when looking thru the forum.  I'll need to review this a bit to understand how I add the script and such, but I am hopeful. 

Thanks again for the great links!


Kristin, I had written a short blog post to go along with the example, that might provide about more info, see here: http://wp.me/p2BoUf-8t

Steve Flowers

I use a little different method to define the endpoint. This lets me define the field targets as I like, rather than the odd names the forms like to apply. This lets me hit the endpoint and send data fields using GET or POST labeled as I have them in the spreadsheet. Works great.

https://script.google.com/macros/s/KEY/exec?field1=this value&another-field=another value

** Note this one won't work since my spreadsheet doesn't contain those field headers.

Probably a really similar mechanism to the Form endpoint. Couple of reasons I like deployed web app scripts better. First, more flexibility in what you want it to do. If you want to have it mail the user once they enter their address, you can script that in (within limits as you have a daily limit to the number of emails you can send). You could also retrieve spreadsheet row values as JSON if you work some script MOJO.

It's also less guesswork as the field names are defined in the header of your spreadsheet.

You can find some documentation on how to setup the endpoint here. From there, the AJAX script used above will work just fine.

http://mashe.hawksey.info/2011/10/google-spreadsheets-as-a-database-insert-with-apps-script-form-postget-submit-method/

SARAH KRIEHN

Thanks, but many companies are going to have security issues passing the data to another provider/storage area. Anyone used excel online? Sharepoint?

This e-mail and any attachments may contain confidential information of Northwestern Mutual. If you are not the intended recipient of this message, be aware that any disclosure, copying, distribution or use of this e-mail and any attachments is prohibited. If you have received this e-mail in error, please notify Northwestern Mutual immediately by returning it to the sender and delete all copies from your system. Please be advised that communications with {SECURE MESSAGE} in the subject line have been sent using a secure messaging system. Communications that do not have this tag may not be secure and could be observed by a third party. Thank you for your cooperation.

This discussion is closed. You can start a new discussion or contact Articulate Support.