1

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?

1 Answer 1

1

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

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.