Gareth has created a number of moblie and desktop apps for friends, family and personal use using AppSheet, powered by Google Sheets and supplemented with several custom Google scripts (Javascript).

He also uses and develops Automate scripts for Android.

He also created a google site for hosting and demo'ing a few simple google gadgets for google sites. Unfortunately, these are not (yet) compatible with the new google sites.

Itinerary App

Gareth's travel app combines Google Sheets, Google Calendar and AppSheet with other Google services such as Google Maps etc to create a travel itinerary app.

It provides a simple interface for combining all travel information in one place (one record per line in the Google sheet), exporting to a calendar and creating a simple Android app and corresponding webpage, automatically filling in as much detail as possible such as:

• Context-based directions (eg driving, walking, public transport etc) to each event (eg to airports, hotels, stations etc)
• Creating a custom Google Calendar for the trip
• Sharing with selected friends and family
• Adding context-based notifications
• Adding travel documents (like plane tickets)
• Maps of events and suggested places of interest

Because the planning stage is Google Sheet-based, copy-and-pasting travel details and places of interest is easy. Sheets can be duplicated and tweaked to generate new calendars to see how options fare side-by-side in a Google Calendars webpage before committing to the trip.

The app allows all the itinerary to be available offline (once it has been synched earlier), and with limited online requirements is bolstered by many features of AppSheet and Google services. It also allows the itinerary to be shared amongst invited family and friends, including a handy webpage version.

Planned developments

• Automatically collate photographs of the user and associated travel buddies
• Automatic 'I have arrived safely' messages to be sent by SMS, email or WhatsApp
• Automatic 'order an Uber' once beyond baggage reclaim
• Alerts to say the status of public transport and traffic information en-route
• Combine the itinerary and photographs into the skeleton of a purchasable physical book, such as in Blurb format

Shopping app

Gareth's shopping app combines Google Sheets, Google Calendar and AppSheet with other Google services such as Google Maps etc to create a shopping app.

Combining a list of 'items in the cupboard' with data from favourite recipes and a Google sheet of planned meals, a list of required shopping items is automatically generated. This is handy for copy and pasting into online grocery retailers where a 'search by list' option is present, or makes for a simple physical one for use in-store.

The associated app, when used by more than one person, makes splitting the shopping easy and allows multiple users to 'cross off the list' items they have got before a rendez-vous at the checkout.

The app generates a calendar of intended meals, including the recipe (scaled to the number of guests), with reminders.

Planned developments

• Notification when nearby shops within preselected time period