Google Spreadsheets Integration: Edit existing submissions

  • kjreif
    Asked on April 15, 2018 at 7:45 PM

    I have my form set up with hidden field and then integrated with google sheets.  Is it possible for me to edit the spread sheet and that would update the person's submission on Jotform?  

    Basically, I have my form set up to collect information and people are printing the form and handing it in with their check. When I receive the check, I need to mark them as paid (using the hidden field) and then send an email.  I'd love to be able to just do this in Google Sheets instead of having to edit each entry as there are hundreds of checks coming in for the school.  

    Thanks!

  • gizem
    Replied on April 16, 2018 at 4:02 AM

    Hello kjreif,

    We highly do not recommend our users editing the spreadsheet that integrated with their form. Because it probably breaks the connection of the integration.

    I can suggest you editing your submissions from the form's submissions page. This also updates the spreadsheet integrated with.

    How to View Form Submissions

    1523865486Screen Shot 2018 04 16 at 10 Screenshot 10

    I hope it helps. Feel free to contact us if you have any further questions.