GAS – Get Array from Data Validated Range

Been happily grabbing data ranges from cell ranges in google sheets for ages, but never spotted that if you have a range where all the cells have data validation in them (e.g. a list of values or list from range), then even if they are blank, e.g. no selection has been made, GAS still counts them if you get the “length” of the array. This little snippet deals with that! Continue reading

GAS – Restore Data Validation

A downside with GAS spreadsheets is the inability to share them and properly protect them at the same time, whilst remaining usable by an end user. So if I want an “unknown” and “untrusted” user to access the sheet and select from dropdowns etc., i must give them editing rights.

This example shows how to check and restore a cell validation each time the sheet is opened. Continue reading

Automate Printing of Completed Google Form

I need to write this up before I forget what I did!

This is quite complex and draws on several resources. Why do this? Because in my organisation many have not/cannot move to online systems, we do not have the resources (e.g. tablets/laptops), or what we need is not yet written/ready, so whilst we can easily input data with google forms, we still need a paper copy in order to act on the contents and record actions. In addition this gets the data into a digital format we can work with (on the google sheet), making it easier to work with and interrogate later, without having to input it from the paper form. Continue reading

CSS3 Only Spinner Full Page Solution

Everybody’s doing it! Just search for CSS3 spinner on the intererweb or visit codepen.io and you will find a variety of spinners. One thing that they all seem to have in common is that they don’t give you the complete solution, i.e. how to make the darn thing run on a web page and disappear when you want it to. This post seeks to address this, along with the sister post about a loading image spinner. Right down to business! Continue reading

CSS3 Only Spinner Image Solution

As you may have seen from my other post CSS3 Only Spinner Full Page Solution, everyone is good at making spinners and putting up demos, but hardly anyone publishes the full solution on how to make it work. Attempt to put that right here. Admittedly there are many many ways to do this, I went for the quickest and easiest. Scenario: you want to display a high quality image on your web page, this will take some time to load, and you want to show a spinner while it loads. I will use a div as a placeholder for the spinner and the image. These are made the same size so that when the image has loaded it completely covers the spinner. I used the z-index property to ensure that the image overlayed the spinner. There is no javascript in this one, just CSS. Continue reading

Fullscreen Browser Slideshow with Clock

I have a penchant for making full screen slideshows with a clock on them

Screenshot-Slideshow

This time around I looked to make one up to run on a slghtly higher specced machine, running a GUI, but in a web browser, using php and javascript. The eventual target was an OS called Webconverger because of its ability to just fire up and present in this way. Continue reading

Automating Framebuffer Digital Photo Frame

dpf6We have seen in my previous post how I setup the DPF to work against the framebuffer. Now it was time to automate things a bit.

Task List:

  • Autologin on Startup
  • Start gnu screen on Boot
  • Uploading New Images
  • Screen On/Off Timer
  • Reboot Timer
  • Shutdown Timer
  • Unique names/shuffle for file list
  • Cycle Colour Change for Clock ?

Continue reading