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.…
Blog Archives
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…
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…
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…
Tagged with: google apps, google apps script, google documents, merge google documents
Posted in Google Apps, Google Apps Script, Google Documents
Posted 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…
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
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…
Monitor Google Drive folders with Google Apps Script
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…
Tagged with: google apps script, google drive, monitor drive folders
Posted in Google Apps Script, Google Drive
Posted in Google Apps Script, Google Drive
