Captivate to Google Sheets

[Aschilles]

Hi,

At the end of quiz, I need to send few informations to a google sheets document.

How can i do this ?

Thanks

[Aschilles]

Ok I found solution here : https://cluelabs.com/google-sheets-elearning-widget

This website propose a widget to do this.

[Aschilles]

Oups ! Sorry finally, it's not a free solution...

So I am still searching. Thanks !

[TLCMediaDesign]

This is not easy to do.

I have developed a solution for a client that records quiz attempts and the answers for each attempt to Google Sheets. But I don't do that for free.

You must have a very good grasp of JavaScript for both the Captivate end and the GAS scripts in the sheets.

eLearning brothers have a YouTube video on it, but their blog with resources is no longer there.

[Aschilles]

Hi,

Yes I saw the "eLearning brothers's" video, but exactetly... their blog is no longer there.

Your solution, can I easily adapt it to my project ? And how much for that ?

Thanks

[Stagprime · Accepted solution]

Not sure which resources you are talking about but when I worked on a project like this once - these were the resources I used from eLearning Brothers.

https://blog.elblearning.com/blog/how-to-create-a-leaderboard-elearning-google

https://blog.elblearning.com/blog/how-to-create-a-leaderboard-elearning-google-part-2

[Aschilles]

It seems to be what I looking for. Very big thanks ! I will try this and I'll keep you informed. Thanks again.

[Dirlo]

...

Very big thanks for these links !... (And also big thanks to James Kingsley by the way !...)

I've just implemented these ressources on one of my project and it works perfectly !...

The only problem I have is that I would want the results to be presented chronologically.

As it's an easy quiz, many learners will score 10/10, so I want the last attempt to be presented first on the leaderboard... Maybe you have already worked on this ?...

Anyway... Thanks again for this useful contribution !...

😉

...

[TLCMediaDesign]

If you want it sorted by date, in the GAS script chage this:

range.sort({
column: 2,
ascending: false
});

to this

range.sort({
column: 3,
ascending: false
});

[Dirlo]

Thanks TLC !...

I was sure it was this solution !... 

I also changed "sortByScore" by "sortByDate" (2 times) even if I know it doesn't really change anything in the script !...

😉

[Aschilles]

It works for me too. You save my day ! Thanks a lot !