Problem with Google Sheets Updating

OK, I am with you now :slight_smile:

It is not possible to do it the way you propose.

@Taifun demonstrates a way to update an existing record using google forms and google apps script. See here:

You could also consider other methods:

  1. Use the native Spreadsheet component for Google Sheets
  2. Create a Google Apps Script Web App to handle your data (CRUD)