Archivio Blog

Create custom forms with GUI Builder and Google Apps Script

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

Taggato con: , , ,
Pubblicato 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

Taggato con: ,
Pubblicato in Google Apps Script, Spreadsheet

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

Taggato con: ,
Pubblicato in Google Apps Script, Spreadsheet

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

Taggato con: , ,
Pubblicato 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,

Taggato con: , ,
Pubblicato 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

Taggato con: , , , ,
Pubblicato 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

Taggato con: , ,
Pubblicato in Google Apps Script, Spreadsheet