Edits made in submissions are not sync with Google Spreadsheet

  • Profile Image
    brendaishungry
    Asked on January 09, 2018 at 05:13 AM

    Hi!


    I have a form with a 2 layer approval process (Once through the line manager, second through compliance department).

    I did it by following your tutorials using the means of the conditional rule (the "get.url contains edit" method)

    I have also integrated the form with the google excel, the first-time form submission works fine, whereby the details are synced accurately into the google excel sheet.

    However, the subsequent 2 "edits" where the line manager and compliance inputs their approval in the fields etc, are not captured in the google excel sheet.

    Is there a way or how do i get subsequent edits from the form to be synced into the same google excel sheet?

    Thank You.

    Regards,

    Brenda

  • Profile Image
    Welvin
    Answered on January 09, 2018 at 07:43 AM

    The Google Spreadsheet integration should sync the edits you've made in a submission. I tried this in my form, and this works without any issues.

    Here's the link to my spreadsheet: https://docs.google.com/spreadsheets/d/1a3KsoWOf2ZV-Ie2RLI1XcBbuwgYQeTB1E4mPYolkY-0/edit?usp=sharing.

    Here's the edit link for my test submission: https://jotformpro.com/edit/3913101724554780741. Please feel free to edit the submission. 

    If you still cannot get the edits on the spreadsheet, please share the link with us so with the edit link to your submission, we'll try it to our end. Or, try to re-integrate your form with Google Spreadsheet. That may work for you. 

  • Profile Image
    Nik_C
    Answered on January 10, 2018 at 04:37 AM

    I tested your form and the edited data wasn't showing indeed.

    Then I cloned your form and did a test submission, then the data was showed properly:

    1515576970Screen Shot 2018-01-10 at 10.3

    So could you please try re-integrating your Spreadsheet integration and see if that worked.

    We'll wait for your response.

    Thank you!