I have created a Google Form for which collects data from a user. Once the use submits the form I have scripts that copy the data to several other Google sheets and then send an email to the appropriate people with the data. This works well. However, when the user edits the form it updates the data in the Form Responses 1 tab correctly but a new row is added to the other sheets. I want to be able to just update the appropriate row/cells in the other sheets, not create a new row because I have two rows addressing the same info.
I have tried saving the URL of the form, i.e., the edit URL, to each of the target sheets so I can match on it later but,
- There seems to be a significant delay for the edit URL to be populated in the Form Response 1 tab so the copy fails because at the time of the copy the URL is not there.
- how can I determine if the response is from an edited form not a new response?
I am rather new to this so any guidance is appreciated.