60 votes
Accepted

How to use Google Tasks on the web standalone?

Use this link by Google to open Tasks standalone: https://tasks.google.com/embed/?origin=https://calendar.google.com&fullWidth=1 If you have multiple Google accounts logged in at the same time, ...
  • 1,058
11 votes

How to use Google Tasks on the web standalone?

You now have a web interface for Google Tasks on https://tasksboard.app/
7 votes
Accepted

Loop through all sheets, except for specific sheet names

If you are using for loop you could use continue to terminate the execution of the current iteration. A way to implement the above by using an if statement and || (logical OR) function myFunction() {...
  • 42.3k
5 votes

How to tag all Facebook group members?

Yes, it is possible to tag a Facebook group in a post. Below are instructions: Step 1 Log into your Facebook account and then navigate to the item you'd like to update with a tag. Click on the "...
4 votes

Javascript string() function in Google AdWords

Coercion in js is amazing and in this case you could simply use like this sheet.getRange("B2").setValue(A + "") Simply plus the empty string to your value. And for something in the similar but ...
4 votes

How to use Google Tasks on the web standalone?

You could use Full Screen for Google Tasks
  • 141
3 votes

Working With Durations In Google Apps Script

Working with date, time and specifically duration is a pain in JavaScript, and Google Sheets does not make it much easier. A JavaScript Date object (which is really a datetime object) is not suited ...
3 votes
Accepted

How to get Google Account last activity info with more precision than a simple date?

Google offers a very detailed log for you to review: https://myactivity.google.com/myactivity It has a date filter and shows minute-by minute activity.
  • 145
2 votes

Hex code in blogger template xml file

What you pasted is only a partial section of a declaration, but what the full declaration you pasted seems to do is declare an array variable containing a string containing what could very plausibly ...
2 votes

Shortcut for clearing a column on Tweetdeck

I write a user script for clear Tweetdeck Tweet https://openuserjs.org/scripts/b1nj/TweetDeck_Clear for use this script you must install an extension specific to your browser.
  • 21
2 votes
Accepted

Google Sheets casting cell value from Object to Number

Short answer How can I convert a cell value to a number? On Google Sheets durations are just a display format for date values, so when a custom function takes a duration it's treated as a date ...
  • 42.3k
2 votes

How to make Google Sheets jump to closest date to today when opened?

I was able to piece together a solution thanks to the help of @Rubén who provided the elements. Perhaps there is a more elegant solution (with a single formula?), but this working for me. This ...
2 votes

How to Jump to Column Based off of Cell Value

You want a user to select a column letter from a dropdown list, and then have the spreadsheet "jump" to that column. There may be several ways to solve your question. Consider this answer as ...
  • 4,843
2 votes

Hide/Unhide rows based on values in particular cells

When you have two onEdit(e) functions in the same script project, only one of them will run. The simplest pattern to combine two onEdit(e) functions is to rename the existing functions to ...
  • 7,218
1 vote

How to set all checkboxes to FALSE in a specific column without losing formulas

Your data is in column A. The number of rows is large, but variable. If a cell in Column A contains text, the cell value should be changed to a boolean value of "FALSE". If the cell contains ...
  • 4,843
1 vote

How to Hide/Show Different Rows based on MULTIPLE cell values

The following block "doesn't work" because it's inside of the first if block if(e.range.getA1Notation() === 'B5' && e.range.getSheet().getName()=='Temp1'){ if(e.value=='Base10') { e....
  • 42.3k
1 vote

Friendly Team vs. Enemy attack math and complicated functions in Google Sheets

To create a custom function use Google Apps Script. This is very similar to writing a JavaScript function. /** * If the arguments are numbers, the sum of will be returned * If one of arguments are ...
  • 42.3k
1 vote

Working With Durations In Google Apps Script

I think we can't manipulate duration calculated. We need to convert them to numbers first, and then we can manipulate number values calculated. After that, we convert them back to duration. For ...
1 vote

Working With Durations In Google Apps Script

Google Apps Script / JavaScript doesn't include a "native" way to handle durations but you could use a library like moment.js to add several methods to handle them but this could imply a steeped ...
  • 42.3k
1 vote
Accepted

Google Apps Script Javascript compatibility error

UPDATE: Google Apps Script now offers two JavaScript engines Original: Based in Mozilla's Rhino JavaScript interpreter, which doesn't support several ECMAScript 5 features New: Google V8, used by ...
  • 42.3k
1 vote

Youtube player shortcut or extension to change to next higher or lower video resolution

There might be a workaround for this. I've been using "Hot Keyboard" macro for the past couple of years to deal with such problems. It has a very neat keyboard recorder/editor and you can also set ...
1 vote

How do I make this Google Sheets Script faster

API calls, such as getRange and getValue are expensive, so you should minimize the number of times you get data from your sheet. But there's no apparent cost of getting a lot of data in one call. You ...
1 vote

How to use Google Tasks on the web standalone?

I'm also an old Google Tasks Canvas user, and I built a complete replacement web app for it (with upgrades) called GTaskD that you can use for free: https://tasks.gtaskd.com/ Warning: 2019-08-30 is ...
1 vote

How to use Google Tasks on the web standalone?

I used simplegamer solution with tasks.google.com/embed link but for javascript I prefer greasemonkey, so you save 1 click every time. This is the script I use in greasemonkey: // ==UserScript== // @...
1 vote

The script does not have permission to get the active user's identity

The range the script tried to add notes was within a protected range. That's why it works for app owner but not shared editors. I just unprotected the range for the script and it worked. Not ideal but ...
  • 159
1 vote

How to format the time in this Google Apps Script

you are calling time inside date (formatDate) without actual date format so the sheet is guessing. var formattedDate = Utilities.formatDate(time, "GMT+2", "MM-dd-yyyy HH:mm:ss");
  • 24.8k
1 vote

How to format the time in this Google Apps Script

The way that Sheets and Apps Script handle "dates" are very different. For Sheets the "date" unit is 1 day; The base date is 1899-12-30 0:00:00, getting the timezone from the spreadsheet settings. ...
  • 42.3k
1 vote
Accepted

Adjusted script to look for column header name, not the numeric representative of the column

If the pattern will always be the same (three columns for each customer), rather than searching for a column named status, your script could look to column C and every third column after it. C is ...
  • 42.3k
1 vote

Loop through all sheets, except for specific sheet names

I think it should look like this: for (var s in allsheets) { var sheet = allsheets[s]; // Stop iteration execution if the condition is meet. if (exclude.indexOf(sheet.getName()) == -1) //...

Only top scored, non community-wiki answers of a minimum length are eligible