vrijdag 27 december 2019

Inserting an emoji into a Google Spreadsheets sheet with a GAS made custom function

I came across (?) a tweet of @TheSheetsGuy on how to insert an emoji into a Google Spreadsheets sheet using Windows 10.

I don't use Windows so how to insert an emoji into a Google Spreadsheets sheet using Chrome OS?

With a GAS made custom function.


function EMO(number){
var emojies = [[1,"9993"],[2,"9994"],[3,"9995"],[4,"9996"],[5,"9889"]];
  for(var e=0;e<emojies.length;e++){ 
    if(emojies[e][0] == number){
      return String.fromCharCode(emojies[e][1]);
    }
  }
}

Sources:

Geen opmerkingen:

Een reactie posten