Category: Excel, Power BI & Google Sheets

Interactive web tables, Jexcel

        I found a post that had an article about an Excel type spreadsheet that you have in your web page with the benefits listed below, so I thought I’d have a play with it. jExcel is a lightweight vanilla javascript plugin to create amazing web-based interactive tables and spreadsheets compatible with Excel or any other

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

Free GlideApp for Defects list for a new building

        Following on from the HopOnHopOff tourist translation app that I developed and discussed in an earlier post, I wanted to extend the features in the app to suit specific needs. I decided to explore a Defects List app for a building site. Defect lists are common, both during and at the end of contracts. Near,