Category Archives: JavaScript

Google Apps Script – get tasks – part 027.

Open a new spreadsheet with a Sheet named Sheet3, then a new script. This will require a new project. Also, you can run it with an old project. Use this function to add a blue color on each empty cell selected by your mouse in the Sheet3. You can see the rule I used with… Read More »

Google Apps Script – get tasks – part 026.

This tutorial solves this issue about how to parse a text document open by an Id and put the output into a Spreadsheet. The input text from the text document must have four signed number delimited with a comma like as regular expression variable named r from source code:

function write() {
  var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var doc = DocumentApp.openById('123xyzTimp\oOBb|hH...');
  var text = doc.getBody().getText();
  var result = [];
  var r = /[+-]?\d+,[+-]?\d+,[+-]?\d+,[+-]?\d+/g
  while ((res = r.exec(text)) !== null) {
    //result.push([res[0]].toString());
    result.push([res[0]].toString().split(","));
    Logger.log(result);
    }

  //ss.getRange(row, column, numRows, numColumns)
  ss.getRange(ss.getLastRow() + 1, 1, result.length, 4).setValues(result);
}

function write() {

var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

var doc = DocumentApp.openById('123xyzTimp\oOBb|hH...');

var text = doc.getBody().getText();

var result = [];

var r = /[+-]?\d+,[+-]?\d+,[+-]?\d+,[+-]?\d+/g

while ((res = r.exec(text)) !== null) {

//result.push([res[0]].toString());

result.push([res[0]].toString().split(","));

Logger.log(result);

}

//ss.getRange(row, column, numRows, numColumns)

ss.getRange(ss.getLastRow() + 1, 1, result.length, 4).setValues(result);

}

Blockly – Solve level 10 maze.

This is the solution of level 10 of blockly-games online tool.

while (notDone()) {
  if (isPathLeft()) {
    turnLeft();
  }
  if (isPathForward()) {
    moveForward();
  } else {
    turnRight();
  }
}

while (notDone()) {

if (isPathLeft()) {

turnLeft();

}

if (isPathForward()) {

moveForward();

} else {

turnRight();

}

First step with ionic framework.

Node.js is a platform built on Chrome’s JavaScript runtime for easily building fast, scalable network applications. This tutorial is based on Fedora 30 distro.

[root@desk mythcat]# dnf install nodejs
Last metadata expiration check: 0:58:43 ago on Mon 12 Aug 2019 10:01:29 AM EEST.
Package nodejs-1:10.16.0-3.fc30.x86_64 is already installed.
Dependencies resolved.
Nothing to do.
Complete!

[root@desk mythcat]# dnf install nodejs

Last metadata expiration check: 0:58:43 ago on Mon 12 Aug 2019 10:01:29 AM EEST.

Package nodejs-1:10.16.0-3.fc30.x86_64 is already installed.

Dependencies resolved.

Nothing to do.

Complete!

Let’s see the version for npm and nodejs:

[mythcat@desk ~]$ npm --version
6.9.0
[mythcat@desk ~]$ node --version
v10.16.0

[mythcat@desk ~]$ npm --version

6.9.0

[mythcat@desk ~]$ node --version

v10.16.0

Ionic Framework is the free, open source mobile UI toolkit for developing high-quality cross-platform apps for native iOS, Android, and the… Read More »

Google Apps Script – get tasks – part 025.

This simple example uses Advanced Google Services with Task API version 1. You can enable this API from menu Resurces – Advanced Google Services into your Google Apps Script project. The script is simple, takes title and id of your tasks and put on logs system. You can view the output from the menu: View… Read More »