10
A solution I've found is to bookmark 2 links:
One to open Google Tasks:
https://tasks.google.com/embed/?origin=https://calendar.google.com&fullWidth=1
However, everything turns white, so the following bookmarklet can be added to the bookmarks bar to fix it. (Create a new bookmark and use the following as URL, then click it just after Google Tasks ...
8
UPDATE: Since Feb-2017(?) it seems this method no longer appears to work unfortunately.
You seem to be able to do this in jsFiddle by first getting the "Share full screen result" URL (from the Share menu) and then view the source of the full screen result to get the URL of the iframe used to display the result.
For example, the "full screen result" URL, ...
5
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() {
var ss = SpreadsheetApp.getActive();
var allsheets = ss.getSheets();
for(var s in allsheets){
var sheet = allsheets[s];
// Stop iteration ...
4
Questions about LibraryThing in general, feature requests and bug reports.
Tim. Founder and Developer. (timspalding; tim{at}librarything.com)
Chris H. Developer. (conceptDawg; christopher{at}librarything.com)
Mike. Developer. (miketopper; mike{at}librarything.com)
From their contact page.
4
Firebug or Chrome Developer Tools is probably your best bet.
Chrome Developer Tools has a "pretty print" feature that allows you to deobfuscate JavaScript code, making it easier to read. You can get the same feature in Firebug by installing the JavaScript Deminifier extension, or you can just use JSBeautifier if you want to deobfuscate an individual ...
4
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 reverse way you can use
+myString
Just using as a prefix an unary + operator, this will coerce the string to a number.
Find more about js coercion with a super ...
3
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.
3
You now have a web interface for Google Tasks on https://tasksboard.app/
3
I'm the sysadmin for LibraryThing and we had a problem with one of our rules in our SSL vhost.
Hopefully this should be fixed for you now. I'm very sorry this caused so much trouble.
2
It turns out that all I had was a capitalisation error.
It appears to be fine to send function values to the spreadsheet.
In this case the values are numeric, but it appears that the Google Spreadsheet API handles the flattening of int values to strings, so my code now just reads:-
sheet.getRange("B2").setValue(A)
And I am a wally.
2
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 be hex code...
Looking at the full code I would suggest that context will be key in this case, as it would seem unusual for a blog to need to be throwing about ...
2
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
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 "Comment" hyperlink beneath a status or image posting to tag a Facebook user in the post's comments sections. To tag a group to your status, click inside of your ...
2
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 object.
Explanation
Doing arithmetic operations
When we are doing arithmetic operations on dates/times/duration, we should bear in mind the following:
Google ...
2
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 for working with durations. A datetime is a lot more complex than it seems at first.
So when you ask
Where did the "days" part of the duration go?
... ...
1
Your code is using an arrow function. This feature is part of ECMAScript 6 but it's not supported by default by Google Apps Script (it supports some ECMAScript 5 features but not all). Replace the arrow function by an anonymous function, add the arrow function polyfill use CLASP a desktop IDE and Babel or something similar.
References
Basic JavaScript ...
1
You could use the chrome extension Full Screen for Google Tasks
1
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 the date that Google will get rid of multiple levels of subtasks in the API itself (as opposed to just their interfaces), so third party apps won't be able to ...
1
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==
// @name google tasks
// @version 1
// @grant none
// ==/UserScript==
// @match https://tasks.google.com/embed/list/~default?fullWidth=1
// @match https://...
1
Well, It took me forever to find out what was the problem. After putting a lot of loggers to see the size of the array, I found out that once I put the array inside the for loop it changed the size. When I looped though it using the same method it just showed the correct values in the log, but using appendrow wrote the whole vector inside the spreadsheet..
...
1
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 it gets the job done. Hopefully Google will have separate permission layers for notes and cells. (also notes should have formatting!)
1
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 involves using formulas in 2 different cells, as well as a script.
Formula #1 (in cell A1 in this case) finds the closest date on or after today from the list of ...
1
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.
For Apps Script, which is based on JavaScript, the "date" unit is 1 millisecond. The base date is 1970-1-1 00:00:00 UTC.
Below is an example script that if the ...
1
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 column 3
F is column 6
I is column 9
For this you could use the remainder (%) operator. Something like this:
(r.getColumn() % 3 === 0)
The above will return ...
1
When I try to apply this formula to any row after the first row (excluding headers) I get a #NAME? error
The#NAME? error occurs on custom functions when the custom functions use a service, in this case SpreadsheetApp, that requires authorization to run and it is not authorized yet.
To authorize your script,
Go to the script editor by clicking on Tools > ...
1
I'm not the developer of that script (Really! Honestly! Truuuust me!), but looking it over, it does not appear to be malware. For instance you see no XHR or GM_xmlhttpRequest requests to third-party servers. It has no obvious attempts at hackery.
As for doing what it says it will, It looks like it should, and with a nice mechanism to select and confirm ...
1
I tried Method 2, using my Blogger account. I have a fairly complicated template, so I added the scripts just below the title tags in the HTML header.
It worked without any problems for me.
Perhaps you have a setting in your browser that prevents JavaScript from running? I viewed my Blogger post in FireFox.
Keep in mind that each time you load your ...
1
FWIW, we prefer to put issues on the Bug Collectors group: http://www.librarything.com/groups/bugcollectors
We welcome emails, but we'd probably post to there anyway, since it helps us track issues.
Only top voted, non community-wiki answers of a minimum length are eligible
