JavaScriptCategory

The tool website called codepen.io is a very useful tool in which you can test HTML, CSS, and JavaScript source code with the related libraries. In this short tutorial, I show you I translated a simple example from Google Books A.P.I. in the codepen.io web interface. The basic example of… Continue Reading Web – Google Book A.P.I. and codepen.

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.

Translate »