Google Spreadsheets Integration: Edit existing submissions

  • Profile Image
    kjreif
    Asked on April 15, 2018 at 07: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!

  • Profile Image
    gizem
    Answered on April 16, 2018 at 04: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.5

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