Profile

Cover photo
Jan Almeroth (Privat)
Works at Wabion GmbH
Lived in Hamburg
332 followers|116,067 views
AboutPosts

Stream

Jan Almeroth (Privat)

Shared publicly  - 
 
Mein neues Spielzeug ist da. 🤓
 ·  Translate
4
Andrea König's profile photoJan Almeroth (Privat)'s profile photoMoritz Philip Recke's profile photo
3 comments
 
ok... schade eigentlich. vielleicht v2.0 aber sonst klingt das ja ganz dufte

 ·  Translate
Add a comment...

Jan Almeroth (Privat)

Shared publicly  - 
 
Das Jahresende kann kommen. Mein Ziel "Alsterrunde" ist erledigt!
 ·  Translate
1
Add a comment...

Jan Almeroth (Privat)

Shared publicly  - 
 
Thanks for sharing this great multimap function, +Eric Koleda!

Now, my own makeid function works even better with thousands of entries: <https://github.com/jalmeroth/Google-Apps-Scripts/blob/master/makeid/Code.gs>. :)
 
Easily handle range input in custom functions

Yesterday I pushed out an update to the Date Add and Subtract sample add-on that added support for operating on ranges of values instead of just single values. We mention this as a best practice in our documentation (https://goo.gl/iRhI2m) and even include a simple pattern you can use to quickly add support to your custom functions:

function DOUBLE(input) {
  if (input.map) { // Test whether input is an array.
    return input.map(DOUBLE); // Recurse over array.
  } else {
    return input * 2;
  }
}

This works great for custom function that take a single parameter, but can't easily be applied to functions that take multiple parameters. And what if some parameters are ranges and others aren't?

Enter multimap

multimap is a utility function I created that takes all the hard work out of working with ranges, allowing you to just function on your core logic. For example, here's a custom function called REPEAT that repeats an input string some number of times, before adding multimap support:

function REPEAT(str, times) {
  var result = '';
  for (var i = 0; i < times; i++) {
    result += str;
  }
  return result;
}

And here's what it looks like after adding multimap:

function REPEAT(str, times) {
  return multimap([str, times], function(str, times) {
    var result = '';
    for (var i = 0; i < times; i++) {
      result += str;
    }
    return result;
  });
}

The logic inside your callback is identical to when it was just operating on single values, and multimap takes care of the rest.

I've put together a demo spreadsheet that illustrates some of the cool things you can do with a custom function that uses multimap:

https://docs.google.com/spreadsheets/d/1hwa_JATdvfSkB189jOrULrQ8DROFgYYPYx5t33omMxI/edit#gid=0

You can check out the source code of the multimap function on GitHub:

https://github.com/google/google-apps-script-samples/blob/master/date_add_and_subtract/Code.gs#L129
5 comments on original post
2
Add a comment...

Jan Almeroth (Privat)

Shared publicly  - 
 
 
Check out the new Google Photos app — which comes with unlimited storage for photos up to 16MP and videos up to 1080p HD resolution. Just choose ‘high quality’ when you upload them through the new Photos app or Photos desktop uploader if you’d like them stored for free.

Just like before, the images and videos you keep in Google Photos will appear in Google Drive automatically and any you upload or sync using Drive will always be the uncompressed, originals and will use your available storage.

Learn more at http://goo.gl/o5fL6G 
126 comments on original post
1
Add a comment...

Jan Almeroth (Privat)

Shared publicly  - 
 
 
Thanks to you, Inbox by Gmail is now open to everyone: goo.gl/blQkyo  
66 comments on original post
1
Martin Thielecke (mthie)'s profile photoJan Almeroth (Privat)'s profile photoKristoffer Holmén's profile photo
3 comments
 
Seems to be some review that needs to be done *waiting impatiently*
Add a comment...

Jan Almeroth (Privat)

Shared publicly  - 
 
Traurig aber wahr.
 ·  Translate
 
Erinnern Sie sich noch an das Jahr 2010? Manches aus diesem Jahr erinnert uns an das, was fünf Jahre später in Deutschland so los ist. So stellte die EU den griechischen Staatshaushalt unter ihre Kontrolle und spannt später den Rettungsschirm auf, die Demokraten verlieren in den USA die Mehrheit ...
2 comments on original post
4
3
Joao Goncalves's profile photoChristian Fizia's profile photo
Add a comment...
Have him in circles
332 people
Philip Hirschfeld's profile photo
Jannik Büchler's profile photo
Claudia Thiede's profile photo
Thomas Dirfard's profile photo
GMBox's profile photo
Andreas Hermann's profile photo
Vishnu CompetentHands's profile photo
Peter Siegmund (mars3142)'s profile photo
Judith Winkelmann's profile photo

Jan Almeroth (Privat)

Shared publicly  - 
 
Are you interested in the current state of email security, especially focused on Gmail? You will like this great talk from Zakir Durumeric at #32C3 then.
1
Add a comment...

Jan Almeroth (Privat)

Shared publicly  - 
 
 
Wir haben ein bewegtes Jahr hinter uns. Ein Thema hat uns mit Sicherheit in diesem Jahr besonders bewegt, hunderttausende von Menschen suchen Schutz bei uns und fliehen aus Ihrer Heimat vor Terror und Hunger. Bilder von verzweifelten Menschen mit Ihren Kindern die Schutz bei uns suchen lassen niemanden unberührt.

Unser diesjährige Weihnachtsspende geht an den Flüchtlingsrat Baden-Württemberg e.V.

http://www.wabion.com/de/weihnachtsspende-2015.html
 ·  Translate
1 comment on original post
1
Add a comment...

Jan Almeroth (Privat)

Shared publicly  - 
 
Focus-Spezial: Wabion zählt zu den Wachstumschampions 2016 :)
 ·  Translate
 
Eine weitere Auszeichnung im Jahr 2015 über die wir uns ebenfalls sehr freuen. Wabion gehört zu den Wachstumschampions 2016 und landete im Bereich “IT, Internet, Software und Services” auf dem 7. Platz von allen Teilnehmern. Die Auszeichnung ist auch eine Auszeichnung für Google for Work, da wir ohne die tollen Produkte nie so weit gekommen wären.

http://www.wabion.com/de/presse-news.html
 ·  Translate
Google Premier Partner für Search for Work (GSA) und Google Maps for Work / Business. Authorized Partner für Google Apps for Work / Business, Google Drive und Google Cloud Platform. Als unabhängiger Anbieter von Dienstleistungen und Softwareanwendungen besitzt Wabion langjährige Erfahrung bei Fragen zu Unternehmenssuche, Google Maps, E-Mail und Groupware, Migrationen und Cloud Services.
1 comment on original post
1
Add a comment...

Jan Almeroth (Privat)

Shared publicly  - 
 
Backward compatibility at its best:
OLE Packager is a feature introduced in Windows 3.1 […]
2
1
Simon Parker's profile photo
Add a comment...

Jan Almeroth (Privat)

Shared publicly  - 
 
 
Gmail now has over 900M users! Thanks for helping us get here.
400 comments on original post
1
Add a comment...

Jan Almeroth (Privat)

Shared publicly  - 
 
Der Frühling lässt dem Biker keine Ruh'. Deshalb habe ich heute eine Probefahrt mit der Triumph Tiger Explorer absolviert. Die steht mir doch ganz gut, oder? ;)
 ·  Translate
1
Add a comment...
People
Have him in circles
332 people
Philip Hirschfeld's profile photo
Jannik Büchler's profile photo
Claudia Thiede's profile photo
Thomas Dirfard's profile photo
GMBox's profile photo
Andreas Hermann's profile photo
Vishnu CompetentHands's profile photo
Peter Siegmund (mars3142)'s profile photo
Judith Winkelmann's profile photo
Work
Skills
Google Apps Certified Deployment Specialist
Employment
  • Wabion GmbH
    Consultant, 2015 - present
  • Intosite GmbH
    IT Project Manager, 2012 - 2014
  • Jemix GmbH
    Cloud Services & Consulting, 2012 - 2012
  • Scholz & Friends Hamburg GmbH
    IT-Supporter / Mobile Manager, 2009 - 2012
  • Scholz & Friends Hamburg GmbH
    Technischer Projektmanager Digital, 2011 - 2012
  • EINSATZ Creative Production GmbH & Co. KG
    Informatikkaufmann, 2003 - 2009
  • EINSATZ Creative Production GmbH & Co. KG
    Ausbildung zum Informatikkaufmann, 2003 - 2006
Basic Information
Gender
Male
Story
Tagline
To infinity and beyond!
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Previously
Hamburg
Links