Google Apps Script – Web App to Google Spreadsheet Using V8

google-apps-script

I tried this tutorial, but it was not written for v8– and the logger and javascript parameter passing between html and the script doesn't work. https://www.youtube.com/watch?v=RRQvySxaCW0
Is there any way to make this code work in v8, too?

Is there any way to make the logger work so I can see the parameters being passed in the URL to the script? I use this at the end of the web app URL
?name=Joe&age=23 and I see nothing in Logger.log's transcript.

Best Answer

First you should know that the use of V8 in Google Apps Script is optional. If you aren't ready to use it, on the menu bar, click Run then Disable new Apps Script runtime powered by Chrome V8

If by Logger you mean an statement like Logger.log(JSON.stringify(e.paremeters)), if you disable V8, after running a function you could see the logs logged by Logger by clicking View on the menu toolbar then Logs

Code

var curDate = Utilities.formatDate(new Date(), "GMT+1", "MM/dd/yyyy")

References

Google-sheets – Google Spreadsheet generate random numbers with Math.random()

Short answer

Instead of using a custom function use a built-in function when possible or use a function triggered by an event.

Explanation

As the OP mentioned, Google Sheets has a built-in function to return a random numbers between 0 and 1: RAND.

In cases where it's required to do some complex calculations that are not possible or efficient with built-in functions, one alternative is to use Google Apps Script. It's worth to bear in mind that custom functions are recalculated only when one of their arguments changes, by the other side their arguments should be deterministic, so using functions like NOW(), TODAY(), RAND() and RANDBETWEEN() will return an error even if they are nested in other functions spreadsheet functions or included indirectly through references.

Google Apps Scripts has two kind of events, simple and installable. See https://developers.google.com/apps-script/guides/triggers/ for details.

Example

The following code will update the specified single cell reference every time time that an user edits the spreadsheet with a random number generated by a the Math.random().

var reference = 'A1';

function onEdit(e) {
  SpreadsheetApp
    .getActiveSheet()
    .getRange(reference)
    .setValue(Math.random());
}

Best Answer

Related Solutions

Google-sheets – How to format the date in this Google Apps Script

Code

References

Google-sheets – Google Spreadsheet generate random numbers with Math.random()

Short answer

Explanation

Example

References

Related Topic