I’ve tried everything I can think of in the storyline file (increased the size of the text where the variable is, made the text box itself very large). Having this information in front of them inspires more frequent data-centric conversations and cultivates a more data-driven approach within the organization. 18 var SCRIPT_PROP = PropertiesService.getScriptProperties(); I just set up google spreadsheet and GS code, Captivate JS code following : http://elearningbrothers.com/how-to-create-a-leaderboard-elearning-google/, http://elearningbrothers.com/how-to-create-a-leaderboard-elearning-google-part-2/, This worked. Beautifully — on one complete business dashboard! Share your thoughts in the comments! (If I had “10 stages” would it be possible to track the stages that the user is progressing through?). What this gives us: Finally, the data dashboard accurately captures our business goal in two dimensions—it not only tells us how far we are from the goal but also how much time is left to reach it. but it’s not working. Why is Soulknife's second attack not Two-Weapon Fighting? We will create them using the names I used in the sample. Thank you so much for sharing this! Thank you for this – it’s great to see some of the more in-depth functionality that’s available. Every company operates around objectives and uses key performance indicators (KPIs) to track progress towards those objectives. I tried it in SL360 and it works perfectly. 2. If you already have a variable for one of the three items above you can update the JavaScript to use it (rather than my names). Experience has taught you that in order to drastically increase your chances for success, you need to consistently track progress. While our data dashboard is already very informative, it may still be hard to gauge how many installs we’re going to have by the end of the time period, provided we continue at the same rate. Bonus points for impressing your colleagues by applying your brand’s colors! If you are experienced with JavaScript you can make some changes to the script (lines 30-41) to tweak how those results look. Let’s fix that. And how to do it for free? i want to remove the name automatically from the 1st attempt so that only one name will be showed in list. Suppose your team just launched a new app (or blog post, landing page, email campaign, etc.). It’s 500 per week. 1. The Google Apps Script is a very important part of getting this functioning! Thanks for the great instructions. Could you provide a link to the course? I’m wondering why the date displays a day later. I put the address in my browser, and found out it was incorrect. That is almost always their email address. You can use any value for a separator, as well as specifying it in the concatenate function itself, such as =concatenate(A1, " - ", C1). Hopefully, we can share those with you soon! Can that be done using part of your example? I am trying to figure how to edit 3 columns in my spreadsheet via the web app. Consequently, we still can’t answer the simple business question posed in the beginning: “Are we on track to hit the goal?”. So any one tell what can i do for that warning resolve? Wonderful tutorial – thanks so much for posting! Dasheroo has partnered with TapClicks. So you end up making the box pretty big to accommodate potentially large blocks of text. Thanks for detailed write up and videos – excellent job James! By using our site, you acknowledge that you have read and understand our Cookie Policy, Privacy Policy, and our Terms of Service. At the moment it does not reflect if some other user have taken the same course at same time or may be few secs after me. When do we ever see the "commander" on xcom game? You could indeed track progress. This is excellent, especially after two days at the UK Learning Technologies show where all the buzz was about gamification! Keep an eye out for it soon! But how to add a Leaderboard? Dmitry Pashkevich With GAS I was able to turn a spreadsheet into a web application that will receive data from a course and send back a list of the top ten users. Time to make our data dashboard ready for the big screen! I’ve been having problems getting the leaderboard to work recently and your method has fixed it! I have implemented in my LMS and it’s working absolutely fine. B1:B17) or click and drag over the desired cells in the, When you’re happy with your Leaderboard, click the green, As this was created in Google Sheets, choose the. I don't know how to make it so that it will COUNTUNIQUE the number of times that a certain class has another unique state that a …