Send a form out daily track responses on separate row...

We have a form we would like to send to employees every morning, then be able to track each response separately. Tried automating the sending out of the form but when employees respond it overwrites the previous response because it was a "request for update". We need to track each response separately.

On the same sheet when we send out the form it is sending a preview of the sheet. We don't want this to happen. What are we doing wrong?

Answers