8,034 reputation
61968
bio website jacobjantuinstra.nl
location Netherlands
age 40
visits member for 1 year, 11 months
seen 55 secs 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 enter image description here badge for the tag
First to earn the enter image description here badge for the tag
First to earn the enter image description here badge for the tag
First to earn the enter image description here badge for first posts
First to earn the enter image description here badge for close votes

Stack Exchange

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


2d
comment Which formula extracts the domain name from an email address (bob@example.com -> example.com)?
@BrianMarshall As I said, I'm not an expert at regex.
Oct
21
comment Which formula extracts the domain name from an email address (bob@example.com -> example.com)?
@Trengot See stackoverflow.com/a/7111947/1536038
Oct
21
comment Which formula extracts the domain name from an email address (bob@example.com -> example.com)?
@Trengot I was thinking of something in line of "@([A-Za-z0-9-.]+)")
Oct
21
comment Which formula extracts the domain name from an email address (bob@example.com -> example.com)?
I'm not an expert on REGEX (@Vidar is....), but the (.*) is too generic. Btw, if no match is found, it will throw an error.
Oct
15
comment What is the best way to merge friend lists on Facebook?
Do you have a small sample script?
Oct
13
comment counting multiple entries to equal 1 item in pivot table
We'll migrate this question to Super User as that's the place for native programs (on a computer). Web Applications is for web based programs only. Drop by if you have another question !!
Oct
13
comment counting multiple entries to equal 1 item in pivot table
Hi, You've tagged the question with microsoft-excel. Are you using the web based Office-365 that Microsoft is offering?
Oct
13
comment Automatically adjust corresponding cells when using “=query”
Hi Isabel, why don't you share a doc with us. This way we can see directly what you are doing. The QUERY formula rocks, doesn't. Welcome on Web Applications !!
Oct
13
comment How to get more than 1 question to populate the same field/column in the Spreadsheet?
Hi Jonathan, stick around as it might take a while for an answer. Welcome on Web Applications !!
Oct
12
comment Where can we see the list of all shared albums on Google Plus?
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes.
Oct
12
comment Easy online database builder?
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes.
Oct
12
comment How to Customise Week Number for Google Calendar?
I have that Calendar as well. I don't think, having seen the settings, it is possible. I hope I'm wrong.....Welcome back on Web Applications !!
Oct
12
comment How are Facebook-shared YouTube video stats recorded?
Where's that to be found?
Oct
11
comment How to make Google Spreadsheet editable only at certain times
You can use a script to add and remove them.
Oct
9
comment Google App Script Admin Directory SDK Authorization
Have you gone through all the necessary steps, in order to make use of this API? See link: developers.google.com/apps-script/advanced/admin-sdk-directory
Oct
7
comment Google Script “Range Not Found” while Sum Color background
Why don't you have a go with this excellent answer Tom Horwood gave: webapps.stackexchange.com/a/50568/29140
Oct
6
comment Error: Circular dependency detected
Was this answer of use: webapps.stackexchange.com/a/59478/29140
Oct
6
comment Error: Circular dependency detected
Was this answer of use: webapps.stackexchange.com/a/60377/29140
Oct
2
comment Lookup using a key from a dropdown cell
If R3 = 'Master' then this would be the correct answer....
Oct
2
comment Lookup using a key from a dropdown cell
The VLOOKUP accepts a third and fourth argument as well. Try setting that to 2 and 0.