7,534 reputation
51665
bio website jacobjantuinstra.nl
location Netherlands
age 40
visits member for 1 year, 8 months
seen 3 hours ago

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 Google Apps Script as possible. See my website for snippets I've made available. See my Google+ profile for more info.

Achievements

First to earn the bronze tag badge
First to earn the gold badge for first posts

Stack Exchange

profile for Jacob Jan Tuinstra on Stack Exchange, a network of free, community-driven Q&A sites


Jul
18
comment Break line in Google spreadsheet automatically
But leaving D12 will result in the cursor moving to D13. Why don't you share the doc with us and show us exactly the behavior you desire.
Jul
18
comment Break line in Google spreadsheet automatically
But it always goes to the next row....
Jul
18
comment Break line in Google spreadsheet automatically
Do you mean that the cursor is to move to the right and not below?
Jul
15
comment Sum the product of two columns in Google Spreadsheets
Hi Jim, can't reproduce your figures. Shouldn't you be using SUMPRODUCT for COST and CUST1 to have the total per customer?
Jul
14
comment How to parse a date and time in the format 2012-12-12T00:00:00+00:00?
The quoted date notation has this format: YYYY-MM-DDThh:mm:ssTZD, yet your last example has YYYY-MM-DDThh:mm:ss. Which should we use?
Jul
9
comment Send an email with attachment using Google Apps Script
Did you find my post useful?
Jul
9
comment How to interpolate data in a range in Google Sheets
@EboMike I looked at my code and noticed an error. I revised the code and came up with a formula, so that you can use it on your mobile app.
Jul
7
comment How to interpolate data in a range in Google Sheets
+1; nice formula !! Choosing x=20 will result in #DIV/0.
Jul
5
comment Sum every 9th row starting from the 4th row in Google spreadsheet
That depends on your locale setting.
Jun
29
comment Google Spreadsheets: Get column number by referencing column title
You're alive !! Wow, thanks Dennis, I've learned something today.
Jun
29
comment Google Spreadsheets: Get column number by referencing column title
I just checked that and it doesn't work !! Perhaps you can explain how this solution works?
Jun
29
comment Is there any way to script a Google Docs spreadsheet?
Bernie, most of your links are broken !!
Jun
29
comment Is there any way to script a Google Docs spreadsheet?
Craig, the url you posted gives an 404 error....
Jun
28
comment What are the refresh characteristics of the Google Spreadsheet Import functions?
Did you try the hack Chris?
Jun
27
comment What's wrong with this Google Apps Script code?
@rautamiekka Added some useful references, for those new to JavaScript.
Jun
27
comment What's wrong with this Google Apps Script code?
@rautamiekka See sheets.length + 1
Jun
26
comment Insert column across multiple sheets
Did this answer help you? If yes, then please mark as such, else give us some feedback on how to improve our answers.
Jun
25
comment How do I reference a cell from a spreadsheet in a document (Google Docs)
That's not possible. The only way to do that, is to use Google Apps Script.
Jun
24
comment Auto-Import Master Spreadsheet
Or have a look at this answer, here on Web Applications: webapps.stackexchange.com/a/913/29140
Jun
6
comment How can I select a sheet with a variable-supplied suffix in a script?
@SonOfEntropy No, that's not possible. Just wanted to post a different technique. You can upvote or leave it as it is.