Archivio Blog

Using the List Box component of the Google Apps Script GUI Builder

After the recent post Create custom forms with GUI Builder and Google Apps Script some people asked how to manage a List Box component inside the GUI Builder. Unfortunately GUI Builder doesn’t allow you to visually add items to a List Box component.

Taggato con: , ,
Pubblicato in Google Apps Script, GUI Builder

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

Merge multiple Google Documents

Sometime you may need to merge Google Documents together, when they are just two the task is pretty easy and involves a single copy and paste operation. In some situation where you have multiple documents to merge in a constant

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

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

Archive Gmail messages to Google Drive folders

By using this script you can archive Gmail messages to Google Drive including message attachments. First of all create a copy of the following spreadsheet document: Archive Gmail messages to Google Drive The spreadsheet document should contain a new menu item

Taggato con: , ,
Pubblicato in Gmail, Google Drive

Monitor Google Drive folders with Google Apps Script

IMG_drive

Google Drive comes with beautiful tools to get notified about changes happening to a shared document. Sometimes you need also to be notified when somebody adds a document to a specific folder. This Google Apps Script allows you to specify

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