Submission date stopped being transferred to Google sheets

  • zabor
    Asked on April 2, 2015 at 10:56 AM

    Everything seemed to be working well until 3/26/2015 when the submission date stop being transferred to Google sheets that is linked to my Jott form. Can you offer any suggestions to make sure that these dates are being transferred over? 

     

    I created the job form and then integrated it with Google sheets.  I have added a couple of columns to Google sheets so that I can capture my notes on the entry. The data does transfer over to Google sheets but the submission date does not. I would like the submission date to be transferred as well.

    The attached file just shows that a submission date was entered earlier but not entered in google sheets now. 

     

    Rick Zabor

    Jotform Thread 545393 Screenshot
  • David JotForm Support Manager
    Replied on April 2, 2015 at 12:43 PM

    I would recommend you not to edit the Spreadsheet, otherwise it might not work properly, my recommendation would be:

    1) Remove the current integration.

    Submission date stopped being transferred to Google sheets Image 1 Screenshot 30

    2. Save Form.

    3. Add a hidden field to your form, which will be the column you are trying to add in your Spreadsheet.

    Submission date stopped being transferred to Google sheets Image 2 Screenshot 41

    4. Go back to the same form and re-integrate with Google Spreadsheet.
    5. Save the Form
    6. Make a test submission (fill the jotform out and submit it)

    If you need anything else, please open a new thread, we will be glad to assist you.

  • David JotForm Support Manager
    Replied on April 2, 2015 at 1:22 PM

    After further testing, I see there is a glitch with the Integration:

    Submission date stopped being transferred to Google sheets Image 1 Screenshot 20

    I am reporting this to our development team, you will be notified here about any updates.

  • David JotForm Support Manager
    Replied on April 2, 2015 at 1:41 PM

    @zabor, after removing the integration and before integrating back again, please try clearing your forms cache, and let us know how it goes.

  • alp_deniz
    Replied on April 10, 2015 at 4:03 PM

    Hello,

    Please accept our apologies on this regard. This week was a special week for our integrations and some problems arose. We will be very happy to assist you with all issues.

    Kind regards