Archivio Blog

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

After the recent post Using the List Box component of the Google Apps Script GUI Builder some people asked this time, how to manage a Check Box component inside the GUI Builder. In this post I’ll try explain how to handle Check Box

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

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

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

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

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

Automatically generate documentation for your Google Apps Script libraries

Not everybody knows that Google Apps Script comes with an handy automated documentation generator for your libraries. Let’s see how it works. First of all you need to create your sample library, so create a Google Apps Script called sampleLib

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