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
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
Just a few tips and tricks for either creating or modifying pdfs under linux.
You will need to have ghostscript, imagemagick and pdftk installed.
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
A few tips on moving a drupal 7 production site to a local server: Continue reading
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
I have a penchant for making full screen slideshows with a clock on them
We 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.
- 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 ?