9,394 reputation
72474
bio website jacobjantuinstra.nl
location Netherlands
age 41
visits member for 2 years, 4 months
seen 12 mins 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
Second to earn the enter image description here badge for suggested edits

Stack Exchange

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


2d
comment How can I make Google Spreadsheet recognize dd/mm/yyyy format as a date?
Have you tried formatting it to a date value, via the menu option Format > Number > Date?
Mar
28
comment Google spreadsheet: divide the total of selected cells by the amount of selected cells
1) You can use the AVERAGE formula to do that. 2) See the first point.
Mar
24
comment Cognito Forms: I want a field to copy (duplidate) the data from another field
Which data, what other field? Please improve your question. Perhaps reading up in our help center will give you some insights on how to do that or take the tour. Welcome on Web Applications !!
Mar
24
comment Share individual copies of a Google spreadsheet
Have you tried it Jason? If yes, why don't you add some references or howtos?
Mar
24
comment best technologies to build a website similar to zomato.com?
Hi jjagadish, recommendations are off-topic. Please take the tour or read our help center. Welcome on Web Applications !!
Mar
24
comment Google Spreadsheet Query for unique and “most recent”
I'm glad you are around JPV !!
Mar
24
comment How do I use a dropdown menu in a cell to populate other cells with information?
Thanks for the post Jean-Rene. OP has zero idea, so explaining how to build a drop-down would be helpful as well.
Mar
23
comment How do I use a dropdown menu in a cell to populate other cells with information?
Why don't you take the tour and get yourself familiar and earn that badge. Welcome on Web Applications !!
Mar
19
comment How to add a line break in a custom date format in Google Spreadsheets?
Ok, fair enough (I've done some research but not yet finished)
Mar
18
comment How to add a line break in a custom date format in Google Spreadsheets?
May I also have a shot at creating that script?
Mar
18
comment How to add a line break in a custom date format in Google Spreadsheets?
Is it Ok to provide a script solution already?
Mar
18
comment Creating multiple time stamps on google sheets to make dependent drop-down boxes work
Common practice is to marked the answer as best answered. Read our help center or take the tour to know more about that. Welcome to Web Applications !!
Mar
18
comment ImportRange with preserved formatting in Google Sheets
That's not an easy task. Have you looked for an Add-on?
Mar
16
comment With Google Docs/ImportHTML(), how do I then modify the data?
Do you want to filter the data or perform a query or just keep track of a few values?
Mar
16
comment Apply complicated formula to whole column
You can create a custom formula to perform the same action...but with less text to type in.
Mar
15
comment Calculate total based on drop down criteria
Hi Tee, common practice is to mark an answer as best answered. Check our help center or take the tour. Welcome to Web Applications !!
Mar
14
comment Why does zoom in google docs mess with my document
Perhaps this question is better asked at our fiends on Super User?
Mar
14
comment Why does zoom in google docs mess with my document
What kind of browser do you use?
Mar
14
comment Calling IMPORTRANGE inside of REGEXMATCH function?
I think my current answer works for you.
Mar
13
comment Apply formula when other is modified
Why don't you share an example file with us and show us exactly the expected outcome. Welcome on Web Applications !!