Search code examples
google-apps-scriptgoogle-sheetsgoogle-forms

How is it possible to find the current row index when a google form is submitted/re-submitted? Google apps script

Is it possible to find out the current row index when a google form is submitted (or re-submitted using the Edit Response URL)?

I have been finding the last row number and then based on that an email is sent to the person who submitted the google form. This causes a problem when the same person edits his response at a later date and submits again, this leads to only the last row details being sent to the submitter - not his row.

I am aware of using the below functions: 

e.values or e.range

I am just wondering if using them in google apps script, if its possible to find the current row?

Any help will be appreciated.

Solution

  • Have you tried:

    e.range.getRow()