58
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, ...
11
votes
How to use Google Tasks on the web standalone?
You now have a web interface for Google Tasks on https://tasksboard.app/
6
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() {...
4
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
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.
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.
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 ...
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 ...
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 ...
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 ...
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....
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 ...
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 ...
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 ...
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 ...
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");
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.
...
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 ...
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
Related Tags
javascript × 92google-sheets × 44
google-apps-script × 44
html × 10
gmail × 8
google-sheets-custom-function × 7
google-forms × 4
google-apps-script-triggers × 4
facebook × 3
twitter × 3
google-apps × 3
google-chrome × 3
keyboard-shortcuts × 3
website × 3
userscripts × 3
youtube × 2
webapp-rec × 2
blogger × 2
google-analytics × 2
google-sheets-timestamp × 2
google-sites × 2
google-chrome-extensions × 2
time-zone × 2
css × 2
jsfiddle × 2