Copy link to clipboard
Copied
Hi,
At the end of quiz, I need to send few informations to a google sheets document.
How can i do this ?
Thanks
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
Copy link to clipboard
Copied
Ok I found solution here : https://cluelabs.com/google-sheets-elearning-widget
This website propose a widget to do this.
Copy link to clipboard
Copied
Oups ! Sorry finally, it's not a free solution...
So I am still searching. Thanks !
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
It seems to be what I looking for. Very big thanks ! I will try this and I'll keep you informed. Thanks again.
Copy link to clipboard
Copied
...
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 !...
😉
...
Copy link to clipboard
Copied
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
});
Copy link to clipboard
Copied
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 !...
😉
Copy link to clipboard
Copied
It works for me too. You save my day ! Thanks a lot !