Category: Google Docs

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

I came across this YouTube video that I thought was quite enlightening “5 Things You Can do in Sheets That You Can’t Do in Excel”: I was rather intrigued by it and decided to look into some of the functions more deeply. So far I have only played with the GOOGLEFINANCE() function and SPARKLINE() My

After writing a post on following a tutorial for automated invoice for a cake shop order, Free Google Docs online ordering automated I decided that, after migrating my Services to my Blog Site I’d try setting up an Automated Quote process for one of the services I offer, namely a Browser viewer for Panoramas linked

I saw this video on automating process for ordering online in Google Docs. I decided to see if I could replicate the process (to a point, not the PayPal integration). The video above has a ‘cake Shop” with an online form  that can take orders for cakes asking for name, location, email and preferred cake