• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers

Captivate to Google Sheets

Community Beginner ,
Jun 11, 2022 Jun 11, 2022

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

Views

206

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Advisor , Jun 13, 2022 Jun 13, 2022

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

 

Likes

Translate

Translate
Community Beginner ,
Jun 11, 2022 Jun 11, 2022

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.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jun 11, 2022 Jun 11, 2022

Copy link to clipboard

Copied

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

So I am still searching. Thanks !

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jun 13, 2022 Jun 13, 2022

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.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jun 13, 2022 Jun 13, 2022

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

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advisor ,
Jun 13, 2022 Jun 13, 2022

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

 

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jun 13, 2022 Jun 13, 2022

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.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Jun 17, 2022 Jun 17, 2022

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

😉

...

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jun 21, 2022 Jun 21, 2022

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
});

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Jun 21, 2022 Jun 21, 2022

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

😉

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jun 26, 2022 Jun 26, 2022

Copy link to clipboard

Copied

LATEST

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

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines