Visual Asset Strategic Tools. Capture Building Information for Building Life Management. Open Source/Low Cost Technology Solutions for you to control your buildings
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
Note – See comment at bottom regarding Images I have been trying to redirect people from my Blog site to my services site. This has not been going too well. Early days possibly but the count is not rising. So I thought I’d add my services to my Blog site under a header on the
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
Simple time sheet After going through, testing a variety of time sheet options, from Toggl (rubbish) & TSheets, through to a Google Sheets add on with a calendar, through to exporting from Google Calendar, processing and importing to Google sheets, then trying add ins for Google Sheets and Calendar for a process between the two
I have been looking at an expenses tool to monitor my spending. I was looking at Google Apps Script video library and they had a video on building an app called Expense it!, it was meant to be on GSuit addons to Gmail but I couldn’t find it. Then I came across this article and
From the last post More free tools for productivity where the first item looks at an alternative to using the Google Sheets Timesheet free Plugin which summed project times and did not show daily times per projects I found a convoluted process where I exported the Google Calendar to a zipped .ical file and then