Category: Automation

IoT part 2 with Button

        Further to my earlier article ” Physical Ms Flow button -IoT part 1” I have been tinkering around with Arduino code & Flow buttons a bit more. Some successes and some failures. The failures I cannot seem to connect to the device any more. So updating the code in Arduino desktop does not re-install on

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- 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