Skip to main content
A
Anonymous
April 17, 2016
Question

Editing eLearning Brothers' Highscore table?

  • April 17, 2016
  • 2 replies
  • 400 views

What I tried to edit: How to Create a Leaderboard for eLearning with Google (Part 2) » eLearning Brothers

I am trying to modify the javascript used by captivate and the google script for the google sheet to fit my liking, but I'm not being successful.

What I'd like to do is have three data variables saved and displayed; myRank, id and score.

Here are my javascript: Javascript pastebin

and the google script: Google script pastebin

I took out the date/time and want to just display the top 10 people's ranks, id and scores in order from 1-10 going down the screen.

Also, I believe they are being saved in non-ordered fashion in the google sheet. I would like them ordered in the google sheet, or would this be too slow/unfeasible in a google sheet with 500+ records?

If anyone could please help me, that would be great. I'm new to Javascript and the whole google script thing is making things even more complicated for me.

Thank you in advance.

    This topic has been closed for replies.

    2 replies

    B
    BuiltClean
    Participant
    April 22, 2016

    Hey Pured,

    The support team at eLB passed your question on to me and sent them a response. Hopefully you got that?

    You didn't really say what isn't working for you. Without knowing what issues you are having it will be hard for me to find what is wrong in the code.

    As for the sorting... You are correct that when a score is submitted it is simply saved to the last (new) row. But when the top ten scores are sent back the sheet gets sorted by scores. The call to do that is in the addUser function (line 42). That calls  the sortByScore function (line 67). The net effect is that they should be sorted.

    Hope that helps!

    James Kingsley

    Lilybiri
    Lilybiri
    Legend
    April 17, 2016

    Please, could you try the eLearning Brothers website? This is the Captivate forum, and you can get help from other users on this forum about Captivate. As you are probably aware, those assets (thousands of them) come as an extra with Captivate, but you cannot expect the users around here to have expertise about all those interactions. I could help you with the included Learning interactions, not with the extra ones. Hope you understand?

    A
    Anonymous
    April 17, 2016

    That's a shame.

    Thank you anyways.

    Lilybiri
    Lilybiri
    Legend
    April 17, 2016

    Maybe you misunderstand: I'm just a user like you. I spend 1-2 hours a day to try to help other users with Captivate issues, for free. But I didn't download the 30,000 assets from the eLearning Brothers that you can use as well, not can we help with explaining how to use them. That is why I pointed to the website of the eLearning Brothers.

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices