Digital Slideshow and Clock – Conky / Lua

conkyluaimg1

It is a disgrace really! I have has this running on an ancient laptop for over three years non stop, and not written it up, even failed to write it up on #! Crunchbang forums, where I got all the help from mrpeachy, Sector11, dk75 and others. Time to put that to rights. What is different about this “one”, you ask? Well, we have two conkys running, they are both in the background, so you still have a fully functional PC if you want to use it, you get sexy rounded corners on your image and a nice big digital purple clock.
Continue reading

GAS – Sort a Single Column

You can do this with a flick of the wrist when working directly on a sheet, but to use a script to do the same thing is slightly more complicated! Google have decided in their infinite wisdom that if you want to sort a range, a column, you will want to sort the data around it as well. This is not always the case. Very often I have a sheet with columns full of unrelated lists: names, locations, dates, etc., and these often need to be sorted alphabetically, by themselves, in order for functions to work further down the line: match / vlookup / filter / index and so on. A few years ago, the clever people on the Google Docs forum came up with a solution, they said it only worked in G Suite for Work or Education, so you mileage may vary when running this in a standalone google sheet? Continue reading

GAS – Insert new row in Google Sheet using script

Probably not as quick as going Edit > Add Row Above/Below, but provides the starting pointing for extending this little snippet to add content, copy down formulas or “setFormulas” to some of the columns. Useful when working with long lists. This script will add a new row above the existing active cell.

Xubuntu 16.04 – Repair Nvidia Graphics Install

Don’t know / can’t remember exactly what happened but for some reason my proprietary Nvidia driver stopped working, I lost OpenGL, and with that a lot of functionality on the desktop. After living with it for a couple of months, and there are many different solutions to doing it, I finally got around to sorting it out like this: Continue reading

Startup Genymotion from CLI, resize and move it

My OpenGL for my graphics has been broken for a few weeks, and I have been missing using Genymotion for my AppInventor emulator. Finally fixed the graphics (another story) and Genymotion working once again. Would like a working environment on just one desktop, so need to resize the stock setup for Genymotion and move it over to the right. Here is a little bash script that does the lot: Continue reading

GAS – Send a Simple Email

Very often you want to email either yourself or another user with output from a script. In very simple terms you need to provide the email address, subject and body

You can, of course, replace the text areas with variables:

GAS – Vertically Align Rows in Sheet

Another simple but useful one, particularly for better presentation of Form Responses, so pop this into your onFormSubmit script:

GAS – Create PDF from Google Form Data, Save to Google Drive and Email It!

I’ll make some assumptions on this one, that you know how to create a Google Form and Responses sheet, and that you can create and edit a Google Doc

Create your Google Form with the questions you want. If you are inside a domain you can automatically collect the user’s email address too

Create a Google Document to use as a template. Leave space for user submissions, and in these spaces include a unique keyword for each answer Continue reading