I've looked through the previous posts and can only find information where it looks like the responder assumes that the form is completed in one go, so the TimeStamp column is the obvious answer to the question.
I have a form that will be updated multiple times, and have noticed during testing that the TimeStamp is updated every time the form is submitted. I would like to capture the date that the entry is first created, not when it was last updated (although that will be of value later).
Is there a way - other than asking the first user to select today's date in a separate field - to capture when the form is submitted the first time? I'm thinking either scripting on the spreadsheet (copying the TimeStamp over into a separate column if the field is blank) or some form of script on the first submit (although I struggle to see how it can 'see' that it is the first submit).