title: Record Time taken to complete a google form
body: <p>I am trying to record the total time taken to complete and submit a Google form.
  My logic is simple that the following code would record and put the timestamp as a multiple choice option.
  Then upon submitting the form, we get a time stamp anyway but along with that, we would get the initially recorded timestamp as an answer to that question.</p>
  
  <p>This is my cute little code:</p>
  
  <pre><code>function initial() {
    var form = FormApp.getActiveForm();
    form.getItemById(1589920082).asMultipleChoiceItem().setChoiceValues([new Date()]);
  }
  </code></pre>
  
  <p>I have set the trigger as OnOpen but surprisingly, it does not renew the timestamp every time I open the form. Theoretically, it should record the time when the form was open but I think I am missing something here.</p>
  
  <p>On the other hand, if I change the trigger to OnSubmit, it starts recording fresh timestamps every time I submit the form. But I don't want that as we get submission timestamps anyway. What I am trying to record is the time the form was open.</p>