Profile cover photo
Profile photo
Jacob Jan Tuinstra
386 followers -
Hi and welcome to my profile. I'm Jacob Jan Tuinstra, born in the northern part of the Netherlands. In my free time, I try to do as much coding in GAS as possible. See my website for the snippets I've made available: www.jacobjantuinstra.nl
Hi and welcome to my profile. I'm Jacob Jan Tuinstra, born in the northern part of the Netherlands. In my free time, I try to do as much coding in GAS as possible. See my website for the snippets I've made available: www.jacobjantuinstra.nl

386 followers
About
Jacob Jan's interests
View all
Jacob Jan's posts

Hey Y'all,

I have a custom formula that accepts an optional argument, like below:

=formula(range, , , {1, FALSE, 2, TRUE})

The object notation mimics the input you'd expect to see in the native sort formula Google Spreadsheet uses.

How can I sort the range, per column ascendingly / descendingly, by using the object? This is what I came up with:

Object.keys(opt_sort[0]).map( function (key) {
range.sort(function(a, b) {
if(key !== false || key !== true) {
})
});

Regards Jacob Jan

Post has attachment
One happy little race.

Post has attachment
Photo

Post has shared content
A bit pricey I'd say.

+Jonathan Erkelens
Philips has announced that it is extending its range of Hue bulbs, adding an E14/B39 ‘candle’ bulb to fit smaller lamps. This will be added to the E26/A19, bayonet and GU10 fittings. The new bulbs will be available in both white and color versions, as…

Post has attachment
Live badminton !

#allengland2017

Post has shared content

Post has attachment
Live badminton from the German Open 2017 !

#GermanOpen2017

Post has attachment
Photo

Post has attachment
Photo

Post has attachment
As of now our Google+ Badminton Community has over 100000 members !!

ht to +Jae Bok Lee

Btw, are you watching the German Open 2017? Which game did you see? Did you attend (pictures?)?


Photo
Wait while more posts are being loaded