Welcome to LifeStack We write clear, helpful and informative content to help you get the very best from technology. Below are our most recent posts, including articles, tutorials, snippets & links. Looking for something else? You can find everything in the archive, or by clicking on any tags. Or take a moment to read more about our vision, approach and philosophy!
Tutorials
Cleaning Browser Auth Cookies at Mac OS X log off
How to use a logoff script to clear authenticated web sessions on a Mac
Analysing Event Feedback with Forms & Sheets
Dynamically and professionally handle your event feedback, gathered with a google form, analysed with sheets.
Monitoring Data with Google Sheets
Easily monitor data collected weekly, with formatting to highlight missing & notable values.
Articles
Google Calendars on the Web
Displaying Google Calendar events on the web, with this simple diary banner for your site.
01 Sep 2018 ► Google, Coding, Javascript
Protecting Data with Google Drive
How to best protect and secure confidential data using Google Drive and Google Apps / G-Suite
Dealing with confidential information in schools
Using a simple traffic light system for categorising types of information commonly found in schools and the classroom.
Spreadsheet Functions
How to concatenate columns in a query
How to concatenate columns in a query and return the results.
Format values based on whether they appearance in another column
How to use conditional formatting to highlight cells that appear in another list.
Filtering data quickly and easily using the QUERY Function
How to create simple ‘drop-down’ filters in sheets to easily and quickly filter an imported range of data rows.
Coding
Running a Basic Helpdesk with Google Sheets
Create a simple helpdesk and request ticketing solution with just forms and sheets.
Simple Bulk Emailing from Google Sheets
Send better looking emails to a bulk set of email addresses, straight from Google Sheets.
14 Dec 2017 ► Google, Sheet, Coding, Javascript
Showing Menus in Container-Bound Google App Scripts
How to show menus and sidebars configuration to write more flexible App Scripts.
13 Oct 2017 ► Google, Sheet, Javascript