Tag Archives: 2020

Web – The downdetector online tool and android application.

This website is a good tool for reporting and detects when technology fails. This online tool is available in many countries and has an android application on Google Play. Downdetector collects status reports from a series of sources, including Twitter and reports submitted on our websites and mobile apps. Our system validates and analyzes these… Read More »

Google Apps Script – getValue or getDisplayValue – part 032.

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, I used Tools – Script… Read More »

C# – First steps with C# and .NET – part 020 .

The tutorial for today is about a math problem named happy number. I used my repl.it account to test it. The algorithm of this program is simple: To find out if a number is happy, replace the number by the sum of the squares of its digits. Repeat the process until either the number equals… Read More »

Google Apps Script – shows a popup window – part 031.

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

function myFunction() {
  var ss = SpreadsheetApp.getActive();
  ws = ss.getSheetByName("Sheet1");
  ss.toast("This is a toast message!");
}

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!

Google Apps Script – about Class GmailThread – part 030.

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:

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()])
  }
}

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 A.P.I. and you will see… Read More »

Google Apps Script – delete a email – part 029.

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 menu: Resources – Advanced Google… Read More »

Unity 3D – A simple joystick project .

This is the most simple way to have a joystick on your game. The project comes with three images one for the exit application and two images for the joystick. One image is for the background joystick on this I add another image for the joystick. The projects have two C# scripts: one for the… Read More »

Web – Google Developer Profile.

Google is coming up with a new feature called Google Developer Profile. They inform us about this option as follows: Google Developer Profile, is a way to learn about Google technologies and unlock achievements. Your profile captures your achievements with badges and saves your progress as you complete pathways, which include codelabs and videos. Currently,… Read More »