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

03 Sep 2018Google, Tool

Analysing Event Feedback with Forms & Sheets

Dynamically and professionally handle your event feedback, gathered with a google form, analysed with sheets.

17 Feb 2018Sheet, Google, Example

Monitoring Data with Google Sheets

Easily monitor data collected weekly, with formatting to highlight missing & notable values.

16 Feb 2018Sheet, Google, Example

Tutorials


Articles

Google Calendars on the Web

Displaying Google Calendar events on the web, with this simple diary banner for your site.

01 Sep 2018Google, Coding, Javascript

Protecting Data with Google Drive

How to best protect and secure confidential data using Google Drive and Google Apps / G-Suite

14 Aug 2018Education, Google, Storage

Dealing with confidential information in schools

Using a simple traffic light system for categorising types of information commonly found in schools and the classroom.

24 Jul 2018Education, Google, Storage

Articles


Spreadsheet Functions

How to concatenate columns in a query

How to concatenate columns in a query and return the results.

05 Jul 2018Google, Sheet

Format values based on whether they appearance in another column

How to use conditional formatting to highlight cells that appear in another list.

05 Jul 2018Google, Sheet

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.

27 Nov 2017Google, Sheet


Coding

Running a Basic Helpdesk with Google Sheets

Create a simple helpdesk and request ticketing solution with just forms and sheets.

02 Jan 2018Sheet, Google, Example

Simple Bulk Emailing from Google Sheets

Send better looking emails to a bulk set of email addresses, straight from Google Sheets.

14 Dec 2017Google, 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 2017Google, Sheet, Javascript

Coding

© 2014-2018 LifeStack.io