-
brendaishungryAsked 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
Page URL: https://form.jotform.me/73412644630451 -
Welvin Support Team LeadReplied 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.
-
brendaishungryReplied 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_CReplied 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:
So could you please try re-integrating your Spreadsheet integration and see if that worked.
We'll wait for your response.
Thank you!