Problem Solved. The problem is with string replace function in some other function. I am using the string replace function with regular expression as input to replace function. The regular expression was incorrect due which i am getting the above error. That’s really weird, at least GAS should give some proper error.
Most people try to use the library with the key ending in 48. That library is pretty dated (it is version 2.9 which is pretty old). Using eval and UrlFetchApp.fetch moment.js or any other external library can be used easily in google app scripts. function testMoment() { eval(UrlFetchApp.fetch(‘https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.18.1/moment.min.js’).getContentText()); var date = moment().format(“MMM Do YY”); Logger.log(date) … Read more
from the documentation : Custom functions return values, but they cannot set values outside the cells they are in. In most circumstances, a custom function in cell A1 cannot modify cell A5. However, if a custom function returns a double array, the results overflow the cell containing the function and fill the cells below and … Read more
The Date object has the valueOf method which returns the number of milliseconds since midnight 1970-01-01. You can use it to compare dates. Something like var date01 = new Date(); var date02 = new Date(2012, 5, 24); if (date01.valueOf() > date02.valueOf()) { …. }
This method worked for me. In markdown (or in StackOverflow), you need to have two line breaks (ie an additional one) to start new line (or paragraph). same method worked for JSDoc /** * Converts the prefixed value to the specified base. * * Requires one of the following prefixes: * * ‘0b’ Base 2: … Read more
If you use GMailApp.sendMail (instead of MailApp.sendEmail) you can specify a from as an optional additional parameter: https://developers.google.com/apps-script/reference/gmail/gmail-app#sendEmail(String,String,String,Object) I believe you can only specify aliases that you have already configured your Gmail account with.
onEdit is invoked by a Simple Trigger when a user changes a value in a spreadsheet. However, simple triggers cannot access services that require authorization, such as UrlFetchApp.fetch. See the Google Apps Script guide What you can do is to simply rename the function onEdit to something else, such as atEdit, so as to remove … Read more
Based on the answer here by Cameron Roberts, you can use the eval() function on the appscript UrlFetchApp function. eval(UrlFetchApp.fetch(‘http://path.to/external/javascript.js’).getContentText());
Now it is possible to add time based events. from: http://code.google.com/googleapps/appsscript/guide_events.html Edit -> Current project’s triggers. You see a panel with the message No triggers set up. Click here to add one now. Click the link. Under Run, select the function you want executed on schedule. Under Events, select Time-driven. On the first drop-down list … Read more
There is no right or wrong answer. There are numerous factors to consider: If this is for/in G-Suite, then your G-Suite admins’ll have (or can get) access to anything. This may or may not be an issue. If you put the data in a sheet, anyone that has read access to the sheet can see … Read more