In various answers on this site I have read conflicting statements about whether everything in JavaScript is an object or not.

What is the truth?

The idea is that the answers are based on reliable sources, preferably in the ECMAScript 2016 (version 7) but it may well be the one in which a specification element has been introduced in this regard.

Here are a couple of examples of each case

everything is an object

• Response to Swapping two objects by changing the result in JavaScript
• Answer to How does the prototype of an object work? ¹

not everything is an object

• Answer to Why does instanceof of a literal number return false?
• Response to Arguments in functions (Javascript - ES5)

Ambiguous

• Answer to Inheritance of properties and methods according to data types
  • The answer mentions that primitives can use methods "of their data type".

General note:

Although this question has an answer from me, the idea is to have the best explanation on this for the benefit of the community.

Specific Notes:

¹ : This question has been marked as a duplicate because it was believed that the answer to this question is in the referenced answer, however, it is precisely pointing out the controversy that exists considering the answers to other questions. On the other hand, this answer does not base its arguments on external sources.

In You may not need jQuery (Maybe you don't need jQuery) two cases are distinguished, the use in the application itself and the one of including jQuery as a library requirement. I leave the case of using jQuery as a library requirement out of the scope of this question because otherwise it would be too broad. This question is focused on the use of jQuery in the application itself.

The reference suggests using jQuery whenever possible, however there are questions on Stack Overflow that ask for answers using pure JavaScript.

Today here on Stack Overflow in Spanish there is a question that currently has two answers, one with jQuery and the other with pure JavaScript. This question is not about saying which of the two answers is better, but about better understanding the implications of using jQuery in a web application.

I mentioned above that the case of using jQuery as a library requirement is left out of this question so it's not too broad. I also ask to leave out comparing jQuery with other similar libraries.

In order for responses to qualify as objective and non-opinion based, they must include substantiated methodological/technical arguments focused on the implication of using or not using jQuery.

jQuery and its cousins ​​are great and should of course be used if they make it easier to develop your application.

However, if you are developing a library, please take a moment to consider whether you really need jQuery as a dependency. Maybe you can include a few lines of useful code and waive the requirement. If you're just targeting your library to newer browsers, you won't need anything more than what the browser already comes with.

At the very least, make sure you know what jQuery is doing for you , and what it isn't. Some developers think jQuery protects us from a big browser incompatibility demon when, in truth, post-IE8 browsers are pretty easy to handle on their own.

The issue appears to be due to Chrome blocking unsafe user location queries, so I've posted a question on Meta SE.

In stack snippet I am testing the code from https://developer.mozilla.org/es/docs/Web/API/Geolocation/getCurrentPosition

When I run it, the stack snippet console shows me

Warning: ERROR(1): User denied Geolocation

In my browser settings I have given permission to show my location to es.stackoverflow.com. What else am I missing?

var options = {
  enableHighAccuracy: true,
  timeout: 5000,
  maximumAge: 0
};

function success(pos) {
  var crd = pos.coords;

  console.log('Your current position is:');
  console.log('Latitude : ' + crd.latitude);
  console.log('Longitude: ' + crd.longitude);
  console.log('More or less ' + crd.accuracy + ' meters.');
};

function error(err) {
  console.warn('ERROR(' + err.code + '): ' + err.message);
};

navigator.geolocation.getCurrentPosition(success, error, options);

GmailApp is a Google Apps Script service through which the mailbox of the user executing the script can be accessed. The GMailApp reference page includes the getDraftMessages() method, but there is no similar method for draft messages. How can I get the messages in the sent folder?

I have been told that Google Drive works differently than common file managers and that it is not possible to change the owner either through the user interface, or using the Drive Google Apps Script service or the Google Drive API

Is this correct?

The array handling feature of Google Spreadsheets is convenient and combined with functions that handle regular expressions like REGEXMATCH and REGEXEXTRACT among others, makes it especially useful.

I have a case where I don't know why it doesn't give the expected result. Here's what I'm trying to do:

Spreadsheet
Settings Regional Settings: Mexico (use . as decimal separator)

Input
A1:abcde

Formula
B1:=ArrayFormula(REGEXEXTRACT(A1,{".{1}",".{2}"}))

Expected result
B1: a
B2:ab

Result obtained
B1: a
B2:

Known workaround
=ArrayFormula(TRANSPOSE(REGEXEXTRACT(A1,{".{1}";".{2}"})))

This question has also been posted on the English site -> https://stackoverflow.com/q/42826011/1595451

Inspired question on How to format a JavaScript date

I have a date object in JavaScript and I want to print to the console in the following format: "14-Feb-2017". How can I do it?

This is the code I have:

var fecha = new Date();
console.log(fecha);

At https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide/Regular_Expressions the following example is published:

function escapeRegExp(string) {
  return string.replace(/[.*+?^${}()|[\]\\]/g, '\\$&'); 
}

Is this the safe way to escape an end user supplied string, for example via a dialog?

Example:

/**
 * Ejemplo. Eliminar todas las instancias de una subcadena en una cadena.
 * 
 * Require dos entradas al usuario, cadena y subcadena.
 * Debemos asegurarnos que la subcadena es segura para ser procesada
 * como parte de una expresión regular.
 */

/** 
  * Tomado de 
  * https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide/Regular_Expressions
  * ¿Es esto seguro?
  */
function escapeRegExp(string) {
  return string.replace(/[.*+?^${}()|[\]\\]/g, '\\$&'); 
}

// Cadena a procesar
var cadena = "Test abc test test abc test test test abc test test abc";
var entradaUsuario1 = prompt("Escribe la cadena a procesar",cadena);

// Subcadena a eliminar
var subcadena = "abc";
var entradaUsuario2 = prompt("Escribe la subcadena a eliminar",subcadena);

// Aplicar la función para escapar la entrada de usuario
var re = new RegExp(escapeRegExp(entradaUsuario2),'g');

// Aplicar reemplazo
var resultado = entradaUsuario1.replace(re, '');

// Imprimir en la consola el resultado
console.log(resultado);

I want to determine if a variable is undefined or has the value null.

In the following example, I want the clause corresponding to the true condition to be executed, that is, the message "EmpName is not defined" is printed on the console, however, the clause in "else" is already executed. which prints "EmpName is defined"

var EmpName = $("div#esd-names div#name").attr('class');
if(EmpName == 'undefined'){
  console.log("EmpName no está definido");
} else {
  console.log("EmpName está definido");
}

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.0/jquery.min.js"></script>
<div id="esd-names">
  <div id="name"></div>
</div>

var miVariable; //miVariable está definida pero tiene valor nulo.
console.log(miVariable)

What is the right way?

I would like to round to two decimal places, only when necessary . Here are examples of inputs and outputs

Entry:

10
1.7777777
9.1

Departure:

10
1.78
9.1

How can I do this in JavaScript?

Fragment

var valor = [
  10,
  1.77777777,
  9.1
];
var resultado = valor.map(Math.round);
console.log(resultado);

Question inspired by Round to at most 2 decimal places

At the end of last year Google launched the new Google Sites to the public. In Google Sites Classic it is possible to insert scripts. I've already checked the help center and the official Google blogs in English and Spanish and I can't find how to do the same.

Sources consulted:

• Google Sites Help Center
• A totally rebuilt Sites, customer-tested and open for business (Article on the launch of the new Google Sites for G Suite users and administrators)
• This is Google - Official Google Blog in Spanish

I want to get the code between the form tags of a web page using Google Apps Script, for which I am using matchthe regular expression/<form(.*?)<\/form>/g

function test() {
  var html = UrlFetchApp.fetch('https://docs.google.com/forms/d/1awKpg_diniayS6360kNXrcgihk36azQ3DJEaZqXDY7A/viewform?embedded=true').getContentText();
  var form = html.match(/<form(.*?)<\/form>/g);
  Logger.log(form);
}

I've tried replacing the modifier gwith other modifiers like mand sbut the Google Apps Script editor doesn't accept them.

Is it possible to use these modifiers? How?

I have a tabular report, also called a matrix or "crosstab". For example, the name of the customer is indicated in the column headers, the name of the product in the row headers and the number of products sold to each customer in the intersection.

+---+------------+-----------+-----------+-------- ---+
| | To | B | C | D |
+---+------------+-----------+-----------+-------- ---+
| 1 | | Client 1 | Client 2 | Client 3 |
| 2 | Product 1 | 4 | 2 | 6 |
| 3 | Product 2 | 7 | 8 | 6 |
| 4 | Product 3 | 6 | 3 | 5 |
| 5 | Product 4 | 3 | 3 | 8 |
+---+------------+-----------+-----------+-------- ---+

I require to pass the data to plain table format, i.e. one column for row headers, one column for column headers and one column for values, as shown below:

+----+---------------------+---------------------- --+-----+
| | To | B | C |
+----+---------------------+---------------------- --+-----+
| 1 | Row Headers | Column headers | Values ​​|
| 2 | Product 1 | Client 1 | 4 |
| 3 | Product 2 | Client 2 | 8 |
| 4 | Product 3 | Client 3 | 5 |
| 5 | Product 4 | Client 1 | 3 |
| 6 | Product 1 | Client 2 | 2 |
| 7 | Product 2 | Client 3 | 6 |
| 8 | Product 3 | Client 1 | 6 |
| 9 | Product 4 | Client 2 | 3 |
| 10 | Product 1 | Client 3 | 6 |
| 11 | Product 2 | Client 1 | 7 |
| 12 | Product 3 | Client 2 | 3 |
| 13 | Product 4 | Client 3 | 8 |
+----+---------------------+---------------------- --+-----+

How can I achieve this using google spreadsheet functions?

Clarifications

Question inspired by How do you create a “reverse pivot” in Google Sheets? - Stack Overflow and personal experience.

I have data in a column of a google spreadsheet with blank cells in between. I want those blanks to be filled in automatically.

In the following table, column A shows the input data and column B the expected result.

+----+---+---+
| | To | B |
+----+---+---+
| 1 | to | to |
| 2 | | to |
| 3 | | to |
| 4 | b | b |
| 5 | | b |
| 6 | c | c |
| 7 | | c |
| 8 | d | d |
| 9 | | d |
| 10 | | d |
+----+---+---+

In Excel I used in the first blank cell, in this case A2, I placed a formula like the following =A1. Then I copied it, selected the range, and the command select empty cells and paste. Google spreadsheet does not have this command included "out of the box".

I have the following array formula but it involves adjusting the references for each case.

=ArrayFormula(vlookup(ROW(1:10),{IF(LEN(A1:A10)>0,ROW(1:10),""),A1:A10},2))

Is there an array formula with a minimum of parameters that have to be adjusted in each case?

Attribution
The formula was previously posted by me as a response to An arrayformula to find the previous non-empty cell in another column .

This was later referenced in An arrayformula to find the previous non-empty cell in another column and find the last row to work with by EumirAMC which, along with my personal experience, inspired this question.

Soon

I plan to use a onEdit(e)Google Sheets and Google Apps Script (1) event to record the timestamp of the update of cells 1,1 and 180,8 of a 180x8 array of formulas on the understanding that the Google spreadsheet updates from top to bottom and from left to right.

Is this approach adequate?

Considerations

recalculation

Google Spreadsheets has a parameter to determine when to recalculate functions like NOW(), TODAY(), RANDOM, and RANDOM.BETWEEN().

The options are:

• in changes
• In changes and every minute
• In changes and every hour

of (4)

Note: External data functions are recalculated at the following intervals:

• ImportRange: 30 minutes
• ImportHtml, ImportFeed, ImportData, ImportXml: 1 hour
• Google Finance: 2 minutes

To Do: Determine if this can be leveraged in any way

Google Apps Script

onEdit(e)it is a simple event. It, its installable version as well as other events in Google spreadsheets respond to user actions, so it can be used to call functions for example when editing a cell.

"Change" is a settable event that can be used for changes of the following types: EDIT, INSERT_ROW, INSERT_COLUMN, REMOVE_ROW, REMOVE_COLUMN, INSERT_GRID, REMOVE_GRID, FORMAT, or OTHER.

To do: identify what types of changes OTHER encompasses.

It is clear to me from the above that it could be used to identify the start of the recalculation.

To Do: Identify how to determine via Google Apps Script that the recalculation is complete.

Additional Information:

Context

It is required to improve the performance of a Google spreadsheet for which it is being considered to replace the formulas with code. To determine the degree of success, it is desired to have metrics of the execution time of both solutions. In the case of code, for example, you can register the timestamp at the beginning and end and then subtract the first from the last one.

The spreadsheet has a 180 x 8 array of formulas. The formulas take data from the row and header and return a 1x2 array. In other words, formulas are used to nest 1x2 arrays in each element of a 180x8 array.

There is enough space to accommodate the result matrix. In a minimal, complete, and verifiable example of the matrix, headers would be placed every other column. In the actual use case an additional column is included for recording notes.

Spreadsheet performance

Regarding the "understanding" of the order in which the calculations are performed, this is based on the recommendation given in various sources to use the same convention in spreadsheets that is used to read in Western languages ​​(English, Spanish, Portuguese, among others), on the one hand because that is how the search functions work and on the other hand because spreadsheets are recalculated faster this way. Included in references is no. 2 as an example of the various sources. Curiously, in the official documentation, Google Sheets help (see 3), there is no mention of this.

References

1. Events - Guides- Google Apps Script
2. 2. Make your spreadsheet read from left to right and top to bottom
3. File sizes - Google Editors Help
4. Change the locale, time zone, calculation frequency, and language for a spreadsheet - Google Editors Help

Questions on Stack Exchange about reducing recalculation time

• Which factor will give most speedup to every update to a large Google Spreadsheet?
• How can I speed up Google Sheets?

Ask

Is there a way to modify the element layout of the new google forms using "userstyles" ( user styles)?

Context

The new Google forms show the title, the suggestion text and the answer field on separate lines, which causes the form to take up a lot of space.

Example: An example of a form is presented including an example of each of the elements of a Google form.

• Demo Question Types for SOes

Previous investigation

The use of "user styles" is a technique for customizing the way information is presented on web pages developed by someone else.

It is possible to apply estilos de usuariousing the developer tools of browsers such as Chrome. This is facilitated by extensions for browsers such as Chrome and Firefox. This technique makes use of "style cascade sheets" ( cascading style sheets/ CSS).

An internet search was performed but no page was found that specifically explained the use of CSSto modify the display of Google forms.

Try

Parsed the Google Form source code above. It was observed that the elements are marked with DIVnested labels and class attributes.

An attempt was made to convert to a table using the table, table-row table-cell. It worked for question type elements not for títuloy type elements secciónsince these span the width of the form but CSSthere is no property to merge cells.

Q&A and articles were found suggesting the use of properties like as a solution table-caption, table-headerbut these were discarded because it is difficult to place the titles and section headers in the correct position. Also found a Q&A suggesting the use of the tag spanbut this implies the use of a script.

Due to the above, it was concluded, in addition to several Q&A, that it is not entirely convenient to use the properties of tables in particular because CSSit does not include a direct way to combine cells of a table.

References

• Getting your DIVs to behave like TABLEs - Snook.ca

Ask

How to reduce received images in the body of a Gmail message using a bookmarklet ?

Context

frameThe Gmail web interface does not automatically shrink images embedded in the message body when they exceed the width of the message reading frame ( ). This makes it difficult to read, as the text stretches across the width of the image, requiring you to use the scrollbarhorizontal scroll bar ( ) to read each line.

In some cases opening the message in a new window fixes the problem, in others it doesn't.

Panorama

The cell A1has the value 01:00(one hour). By using a function like the following:

function prueba() {
  var libro = SpreadsheetApp.getActiveSpreadsheet();
  var hoja = libro.getSheetByName("Hoja 1");
  var datos = hoja.getDataRange().getValues();
  var valor = datos[0][0];
  Logger.log(valor.getHours());
  Logger.log(valor.getMinutes());
}

Values ​​are recorded

1.0  
36.0

The expected is that the recorded values ​​would be:

1.0  
0.0

How can I make my code read the expected values?

Comments

This is a "real question" for which I found the answer on stackoverflow.com . See reference.

The question wasn't translated, but you could tell it's based on the reference.

References

• How to read the correct time values ​​from Google Spreadsheet

Google Apps Script supports triggers ( Triggers ), also called activators, which pass events ( Events ) to trigger functions to fire/activate functions. Unfortunately, the development environment does not allow functions to be tested without passing parameters, so it is not possible to simulate an event in this way. When attempted, it results in an error like:

ReferenceError: 'e' is not defined.

One can treat the event as an optional parameter and insert a default value into the trigger function using the techniques of "Is there a better way to do optional function parameters in Javascript?" . But this introduces the risk that a lazy programmer (Who said me?) could leave that code behind with unintended side effects.

Surely there are better ways.

References
Based on How can I test a trigger function in GAS? by Mogsdad 2014-11-14 19:40:55Z edit

I've created a project bounded to a spreadsheet in Google Apps Script and I'm thinking of creating more in other applications.

I don't want contributors to my spreadsheets or other app script containers to be able to view my project code. I just want them to be able to execute them.

As I understand from the following, posting the code as a library doesn't help as read access is required for it to be added to the project and run.

From Collaborating with Other Developers :

Sharing and libraries

Libraries included in your project are shared with project collaborators. Though, if they do not have at least read-level access to an included library they are unable to use those libraries and will encounter an error if they attempt to do so. For more information about libraries, see Managing Libraries .

How can I block view access to the code?

I have consulted the documentation indicated in references but I cannot find how to block the display of the code to the collaborators of the containers (spreadsheets, documents, forms).

References

• ¹ : https://developers.google.com/apps-script/
• ² : https://developers.google.com/apps-script/guide_libraries