Formatting and filtering a Google Spreadsheet using Google Visualization API

Previously posted on

Quick blog post from the iPad where I have extended the functionality of the spreadsheet I created earlier. I found it very easy to complete all the functions on the iPad **except for the spreadsheet formatting function** (how do you reduce the number of decimal places for a number column on the iPad?). I used [Textastic]( to edit the HTML, [GDrive]( to upload the file (the Google Drive app crashed a lot) and the full desktop view of Google Drive within Chrome to get the necessary URL for the image file.

My first aim was to get the URL to become a hyperlink. I found a [blog post]( which quickly helped solve this issue.

Next I wanted to turn the hyperlink into a button which opened the URL in a new window. The CONCATENATE function in Google Sheets helped here.

Then I wanted to hide the preURL column from the view. This took a little while because I forgot I was dealing with a spreadsheet and used the column headers as field names!

Finally I build a simple filter which allowed me to limit the results displayed to the user.

I’m now ready to design and populate a single spreadsheet containing all the training material – YouTube videos, webinars, iTunesU courses, articles, blog posts and files – which will be automatically limited depending on which page the user visits (beginner, intermediate or advanced). This should reduce the time it currently takes to manually edit the HTML in Google Sites.

Does anyone else use Google Sites within their educational establishment to help deliver staff training or CPD? I’d love to hear from you.


Replit Uncategorized

Cost comparison of hosting vs using Replit cycles

Are you looking for a way to cut hosting costs for your website? Look no further! I recently faced a similar challenge with my site and I’m excited to share my findings with you. As many of us know, the cost-of-living crisis in the UK has made it important to reduce expenses wherever we […]

Read More
Student Attainment Teacher Training + Support Uncategorized

Using Replit to Deliver 21st Century Assessment #replitedfest2022

Below are the slides from my Replit EdFest 2022 session on 21st July 2022

Read More
Teacher Training + Support

Mail merge and splitting files Google Docs

We are in prelim season and just about at the stage where we analyse student marks individually and as a cohort. I wanted to use my Google Sheet prelim breakdown showing how students performed in each question of the exam as source for a mail merge so that I could generate individual reflection sheets for […]

Read More