google sheetsgoogle-apps-scriptgoogle-formsgoogle-sheets-timestamp
I created a Google form that allows users to clock in/out. The form asks two questions: their pin number and whether they want to check in or out. When the user clicks on "check in" and submits, the form or the spreadsheet should input the timestamp in the "check in" column and so on for "check out" option.
How would I do this through Google script?
You seem to be asking another question since the answer to your question is to simply look at the row number and subtract 1: that is, use the formula
=ROW()-1
Google doesn't currently support this feature - there is no way to save a form and have a user return to it later without submitting it.
That does raise an interesting point, though. You can have the user submit the survey and edit their responses later. Instead of forcing the user to page through the rest of the survey to get to the submit button, just add a multiple choice question at the bottom of each survey page (see example below):
By using question logic, we can send survey-takers to the "Submit form" page which then gives them an "Edit this form" link that they'll need to save. Of course, when they come back, they will be starting from the beginning of the survey, but their previous answers will remain filled in.
If this all seems complicated (it is), you may want to try one of the paid survey services (I found SurveyMonkey to be a good value for the money, at least a few years ago), which make implementing this much easier (see SurveyMonkey info here).
Best Answer
You can do this using the copyDown add-on by filling in the right formula in line 2. You can find the copyDown add-on here: https://chrome.google.com/webstore/detail/copydown/lipbbdpmkcbplmfnbholpabinnnkbbda