📋Get the Form Edit Response URL in Google Sheets

1. Overview

\[ \begin{array}{l} \textbf{Google Forms does not directly provide the edit response URL in Sheets --} \\ \text{but you can retrieve it programmatically using the response's prefill link pattern.} \\ \textbf{This allows respondents to re-open their submission --} \\ \text{and make changes without submitting a new form.} \end{array} \]

2. Core Steps

\[ \begin{array}{ll} \mathbf{Step\ 1:} & \text{Open your Google Form and get its edit URL for a sample response.} \\ \mathbf{Step\ 2:} & \text{Note the format: } \texttt{https://docs.google.com/forms/d/e/}\\ & \texttt{FORM\_ID/viewform?edit2=RESPONSE\_ID}. \\ \mathbf{Step\ 3:} & \text{Link your Google Form to a Google Sheet (Form responses).} \\ \mathbf{Step\ 4:} & \text{Use Apps Script to append the edit URL for each submission.} \\ \mathbf{Step\ 5:} & \text{Optionally, send the edit URL to the respondent via email.} \end{array} \]

3. Sample Google Apps Script

// Append Edit Response URL for each new form submission
function addEditResponseUrl(e) {
  var form = FormApp.openById('YOUR_FORM_ID'); // Replace with your Form ID
  var response = form.getResponse(e.response.getId());
  var editUrl = response.getEditResponseUrl();
  
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Form Responses 1');
  var lastRow = sheet.getLastRow();
  sheet.getRange(lastRow, sheet.getLastColumn() + 1).setValue(editUrl);
}

4. Important Notes

\[ \begin{array}{l} \text{• The Apps Script must be bound to the Form to access } getEditResponseUrl(). \\ \text{• Use an \textbf{onFormSubmit} trigger to run the script automatically.} \\ \text{• Store the URL in a hidden column to avoid accidental edits.} \\ \text{• Do not share edit links publicly — they grant full editing access to that response.} \end{array} \]

5. Conceptual Flow (in LaTeX)

The process can be described as:

\[ \text{Form Response} \xrightarrow{\text{Apps Script}} \text{Edit Response URL in Sheet} \]

Where: \[ \text{Edit URL} = \text{Base Form URL} + \text{Edit Token from Response} \]