Dear visitor, This post is to acknowledge that I’ve now written 200 of them. A milestone. It has taken me 8 months to write them. I hope you have enjoyed some of the posts and have received some useful insights/help that have assisted you in your work or interest. I have enjoyed writing most of
I wanted to link a couple of things I’ve been learning and doing and highlight them in videos. In some demonstrations seeing is better than listing Vid 1. Screen Capture & Optical Character Recognition (OCR) In this video I wanted to show how to use screen capture process to get code from YouTube and other
I was reading an article about integrating Google Apps with WordPress and one was a plugin for Google Forms and decided to investigate it. When I went to install the plugin I came across Calculated Fields Form plugin for WordPress and decided to install that too. I’m glad I did, this is a great plugin.
I need to get my head around this to see if it can supplement the sheet filtering info I was exploring in the last post. Formatting Macro tutorial I will be following the tutorial in the video below, it is one of the videos from the Learn Google Spreadsheets that I think is an exceptional
I wrote a post on using Excel filterable Heatmaps for Asset Condition over time online. This was an excel file on my OneDrive that I then embedded in a web page. I had filtered the columns so that you could filter columns to do forecasting for building items that would need work to be done
YouTube screen capture convert text I watch tutorial videos to learn how to do certain things in coding. Sometimes, in the video, they leave a copy of the code so that you can download it, other times this is not the case. So you have to write the code out longhand for yourself, which can
There seems to be a few plugins that will take your article in Google docs and post on a WordPress site. The first one I came across was an addon in Google Docs called WordPress.com for Google Docs. This requires you to have the Jetpack plugin on your WordPress site. I’m not keen on that
I was excited about this feature. Being able to upload files in a form. This could really help the automation process for the services I’m offering. Summary On setting up the form I found out that people are only allowed to upload files if they have a gmail account and are logged in. Also there
Further to my previous post Google Sheets “GOOGLEFINANCE()” for free Stock data that started with referencing 5 things that Excel couldn’t do but Google Sheets can, I wanted to explore a few of the features mentioned in that video. It mentioned the following Google Sheet Functions: ImportFEED(), Import HTML() &ImportXML() 1. ImportFeed() Well, I followed
After the success of my previous automated quoting service Creating free embedded automated quote for service with Google Docs I found a couple of things that I wanted to try to extend this process. The first is multi sections in forms and the second is, instead of using the Google Sheets Document Studio Addon I
