Ending with a high score board

Sure!

So I just recorded a video showing the setup of my typeforms.

We created 3 quizzes with like an 8bit arcade game look and feel.

There are 2 different logics:

1. One of the games counts lives: player starts with 3 lives and for each wrong answer it subtracts one. For each question  there are two slides of answers, one for correct and one for wrong. After each wrong answer we check how many lives they have and if it is equal to zero it jumps to a “game over” ending. If the user ends the game with at least one life, they get to a “you win” ending, and dependning of how many spared lives the player gets XP: 50, 75 or 100XP according to the number of lives. 
2. Two other games are based on score. So the player will always go through all the questions, but score only on the correct answers. At the end, if you have low score you get to a “game over” ending, or else you get to a “you win” ending.

Before the ending, the game is submitted after the user choose to accept (yes/no) having their name on the score board, for obvious privacy reasons.

All the ending slides have a link the Leaderboard, wich is a page we created on Google Sites. We use Google GSuite, so the following components were created using its resources. 

To get the results to show at the page, here’s what we’ve done:

1. connected the quiz typeform to google sheets. It automatically creates a spreadsheet with all the collected data and is is updated on every form submission.
2. In the google sheet, we created a second sheet with filtered data, and a third one with a pivot table that lists only the names for the leaderboard in the decrescent order of scores.
3. To transform the pivot table in a better looking and responsive element we created a script that creates an html from the pivot table.
4. Using google sites, we created a page alusive to the game and embeded the html page generated by the script.

More details in the video: