Using Google Forms, you can create custom data form, but the ability to customize them both in terms of functionality and visual aspect can, in some cases, be limiting. In this post I will explain how you can create a…
Blog Archives
Create custom forms with GUI Builder and Google Apps Script
Tagged with: custom forms, google apps script, google spreadsheet, gui builder
Posted in Google Apps Script, GUI Builder, Spreadsheet
Posted in Google Apps Script, GUI Builder, Spreadsheet
Sales Tracking for Google Spreadsheet using Google Apps Script
Editor’s Note: Guest author Brennan Morrow runs Solar Light, a Solatube Premier Dealer based in Oregon, United States. — Marcello Scacchetti Sales Tracking for Google Spreadsheets is a simple CRM solution developed specifically for small businesses who want to track…
How to remove a Google Apps Script from a Spreadsheet document
If you have read my last blog post titled: “How to install scripts from the Script Gallery of Google Spreadsheet”, you should have a script installed on a Spreadsheet document. Now I’ll try to explain you the process required to…
How to install scripts from the Script Gallery of Google Spreadsheet
In a Spreadsheet document you can access a list of “ready to use” scripts to add functionalities to the Spreadsheet document itself or to be able to interact with other components of the Google Apps suite. Ready to use scripts…
Tagged with: google apps script, google spreadsheet, script gallery
Posted in Google Apps Script, Script Gallery, Spreadsheet
Posted in Google Apps Script, Script Gallery, Spreadsheet
Sync Google Contacts with Google Spreadsheet adding custom fields
Following a discussion happened on the Google+ Google Apps Script community, Rob Aubrey asked the possibility to synchronize Google Contacts to a Google Spreadsheet document and add a custom field managed directly inside Google Spreadsheet that should be synched back to Google Contacts,…
Tagged with: google apps script, google contacts, google spreadsheet
Posted in Google Apps Script, Google Contacts, Spreadsheet
Posted in Google Apps Script, Google Contacts, Spreadsheet
Personal Kanban with Google Spreadsheet and Google Apps Script
Kanban is a method for developing software products and processes with an emphasis on just-in-time delivery while not overloading the software developers. In this approach, the process, from definition of a task to its delivery to the customer, is displayed…
Tagged with: google apps script, google spreadsheet, kanban, personal kanban, spreadsheet
Posted in Google Apps Script, Spreadsheet
Posted in Google Apps Script, Spreadsheet
Trigger updates between master – slave spreadsheets
Based on a discussion happened on the Google Apps Script community on Google+, with this post I want to explain a possible solution to trigger updates between master and slave spreadsheets. The basic idea is that on an onEdit on…
