Edits made in submissions are not sync with Google Spreadsheet

  • brendaishungry
    Asked on January 9, 2018 at 5: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

  • Welvin Support Team Lead
    Replied on January 9, 2018 at 7: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. 

  • brendaishungry
    Replied on January 9, 2018 at 11:05 PM

    Nope, I can't get the edits on the spreadsheet.

    Here's the link

    https://docs.google.com/spreadsheets/d/1GdWhZYLEluHWzooYhfNV0Rw3XeK5F0gbQ1DKaMsQe2o/edit?usp=sharing

    Basically all the details are filled first without approval from Line manager and Compliance,

    even after entering the form to input those on edit, it doesn't show up on the spreadsheet ):

  • Nik_C
    Replied on January 10, 2018 at 4: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 Screenshot 10

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

    We'll wait for your response.

    Thank you!