Category: Excel, Power BI & Google Sheets

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

The last post I tried to use AirTable to create a Colour Schedule from a Revit export. Thinking I could use the Database to cross reference items in the room such as doors/windows etc to be able to pull those in to make the colour scheme planning more comprehensive. It didn’t work. Along the way

Background I have written a post on showing internal building fabric condition over time in this article Revit Internal Condition over Time. I was not, at the time, happy with the presentation of the information as it was a series of screenshots that I then put in as slides to step through the process. Two