Google Integration Question: Updates delete field information.

  • Goldin_J
    Asked on July 9, 2020 at 1:01 PM

    I'm using conditional logic and get for URL to create a way for work orders to be updated by technicians. It works great! 

    Two issues I'm running into are:

    When the form is updated by the technician most of the original fields are deleted in the google sheets integration. I need that data for analytics. The yellow fields in the screen shot were filled out by the person creating the work order but then deleted when the work order was updated.

    The subject of the update email doesn't match the original subject. That means it's making a new thread every time instead of updating the conversation. Not a dealbreaker but inelegant. 
    Jotform Thread 2439601 Screenshot
    Page URL: https://form.jotform.com/201885216836158
  • Carlos_C
    Replied on July 9, 2020 at 3:34 PM

    Hello,

    Thank you for your message.

    Could you please try to remove the integration and create a new integration with Google Sheets.

    If you don't want to lose the format, formulas, etc. that you already have in the original (first) integration, you can sync the data from the new Google Sheet (Re-integration) to the existing file, here you can find a way do it: how-sync-one-spreadsheet-another-google-sheets.

    With the process above you can have a "Master" file that will be synced by any spreadsheet integrated with Jotform, in case of an issue with the integration you can just create a new one.

    Complete guide: How-to-Integrate-Forms-with-Google-Sheets.

    If you need any further assistance, please let us know. We will be happy to help.

  • Goldin_J
    Replied on July 9, 2020 at 5:10 PM

    I think my question wasn't clear. Sorry. The integration works.

    When I make an entry all of the fields with data show up on the sheet as expected. But, when I update the for with new information all of the data from the old fields is deleted.

    The first submission is my employee making a work order. The update to the form is the technician making notes and status. The initial fields are hidden when the technician is making their update so they can't be changed. 

    The data from the update seems to be overwriting the initial submission. 

  • Goldin_J
    Replied on July 9, 2020 at 5:31 PM

    I've tried hiding the fields and disabling the fields. They are still overwritten.

  • Vanessa_T
    Replied on July 9, 2020 at 10:05 PM

    Since the fields were conditionally hidden and the setting Clear Hidden Field Values is set to Clear on Submit, hence the reason those data are actually deleted before submission, and so an empty data is synced to Google Sheets.

    Google Integration Question: Updates delete field information. Image 10

    Kindly change this setting to Don't Clear.

    As for your email concern, I have moved it to a separate ticket and will answer you in the ticket link below:

    https://www.jotform.com/answers/2440527