Category: Excel, Power BI & Google Sheets

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

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

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 for

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

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

After the Art Gallery App Free GlideApp for developing Art Gallery translation mobile app I wanted to extend it to a Museum app. As it does not take too much time to mock up an app I thought a specific app targeted at a specific Museum would capture more attention than if you were to

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

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,

After the first test of the Glide app I found there was limited ways to input data. You had to edit a sheet tab of data but no method of automatically tagging that an item had been updated. That is, that I have identified so far. Video clip showing quick demousing Recordit The documentation and

The first process I did Architectural Colour Schedule in Excel used VLookup() to lookup a table on a separate sheet, but it did not show you the choice of selections. This time I want to be able, when looking up a room finish, to see what the selections are, so that I can choose an