Category: Automation

Mirrors of confusion – Check Out/In app fail so far

        I saw this great YouTube video about QR Attendance Using Google Drive with QR Codes Generator Add-ons: I thought it was a great workflow and also an elegant solution. The autoresponse from scanning the QR code to fill out the form. How easy is that? Then I got to thinking how I’d use it. I

Google Sheets Google Analytics add-in to create dashboards

         I was looking at the GlideApps showcase and the Bogdan Popa created a News App. In it he uses IMPORTXML in Google Sheets to pull in web data that he filters to different tables. A nice app. I started thinking about what other import formulas does Google Sheets have, I know it has GOOGLEFINANCE

Free GlideApp for Project Defect list moving COMPLETED ITEMS to another sheet

        Following on from the 2 previous videos relating to this app, after a task has been completed, an email can be sent to the project manager, and others via the app to advise of its completion. So we need to take this item off the TO DO list and move it to another list, and

Free Glide App- make mobile app from Google Sheets

        Click this link to go to developed app. Glide is a bit like Coda, but different. Its intentions is to build an app without needing to code. Allowing you to focus on content rather than process. It has a free tier and you need to sign up/sign in. You need a google account so that

Multipurpose function hall and variable seating prices

        Going to get a seat to an Opera or Ballet performance in Wellington I usually trundle down to the ticketek office to book and get the tickets. When looking for seating they usually have a plastic folder with photocopies in and point to seats in the price range you are looking at (usually the cheap