JavaScriptCategory

In this tutorial, I will show you the differences between getValue and getDisplayValue in Google Apps Script. I used a default project with a default spreadsheet document with my birthday 1976-03-07 into A1 cell and format text as year-month-day. I add Apps Script API to my project. On the spreadsheet,… Continue Reading Google Apps Script – getValue or getDisplayValue – part 032.

The tutorial for today is about toast message into a spreadsheet. Use script editor, run the next code source it with authorization:

JavaScript
1
2
3
4
5
function myFunction() {
  var ss = SpreadsheetApp.getActive();
  ws = ss.getSheetByName("Sheet1");
  ss.toast("This is a toast message!");
}

You will see a message toast in the bottom right area of the spreadsheet with this text: This is a toast message!

Today I will present briefly Class GmailThread. It can be used to retrieve data from incoming electronic mail received by Gmail. Let’s see a simple example. First, open a spreadsheet, and from Tools open the Script editor to run this source code:

1
2
3
4
5
6
7
function getGmailData() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var threads = GmailApp.search("is:unread in:inbox", 0, 7);
  for (var t=0; t<threads.length; t++) {
    sheet.appendRow([threads[t], threads[t].getId(), threads[t].getLabels(),threads[t].getFirstMessageSubject()])
  }
}

. Add and run with authorization for Gmail… Continue Reading Google Apps Script – about Class GmailThread – part 030.

This is simple to do. Open a GAS script in google editor. You can use the google drive menu New – Google Apps Script or create a new document and use from menu: Tools – Script editor to open a new google apps script editor. Select Gmail A.P.I. from the… Continue Reading Google Apps Script – delete a email – part 029.

Today I start programming a firefox extension. After some research and tests, I saw this is not a simple issue and I create this first tutorial about Programming extension with Firefox. I created a folder named myx and I add with two files: manifest.json and myx.js. The first file named… Continue Reading Web – Programming extension with Firefox – part 001 .

This is an update the last tutorial about Google Apps Script and shows you how to use App First, you need to update your Advanced Google services. Open an empty google document text or spreadsheet and using the main menu to open the Script editor from the menu Tools. You… Continue Reading Google Apps Script – get activities – part 028.

The intro of this website tool is very simple; Everyone loves the Google CDN right? Even Microsoft runs a public CDN. The problem is, they only host the most popular libraries. We host all the popular libraries – JavaScript, CSS, SWF, images, etc! Basically, you can search and use one… Continue Reading Web – Online tool with all CDN libraries.

This is a great component for creating editors and parse the content by programming languages and not only that. The last version can be found at the GitHub project. Another step in using this tool is the next generation of the CodeMirror in-browser editor, see the codemirror.next. If you want… Continue Reading Web – About CodeMirror editor.