Category: Google Docs

Covid by region NZ -map representation- Part 1

         I’m thinking of trying to do an NZ map of regions where cases are. I’m using link to Wikipedia 2020 coronavirus pandemic in New Zealand page for data on region data. I have been looking for polylines for these regions and also centroids for region polylines. No luck so far with centroids but I

StdLib API automation test with AirTable, SMS message, GMail & Google Sheets

        Somewhere I came across Standard Library but best searched for under StdLib. I signed up for it and found a couple of videos. It looked like magic and required serious coding, so I put it down at the time. I have been receiving regular “onboarding” emails (Seems pretty common and irritating when you sign up

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 for Honey product sales at market stall, YouTube thumbnails & Glide email notifications

        Developing and exploring the GlideApp into different areas has been fun and interesting. This particular app was for someone i worked with who also sells honey with a group of people, and one location is at an outdoor market stall. I thought it would be handy for people who were not prepared to buy immediately

Free GlideApp for developing Art Gallery translation mobile app

        Further to HopOnHopOff (HOHO) for bus tour I could see that this idea could be extended to other instances like Museums, Art Galleries and events. A way of extending the information about a specific subject by translating it into different languages, thereby allowing people to engage more with the subject at hand. So, my initial