How does the Google Spreadsheet Integration work

  • Profile Image
    kmankuan
    Asked on January 06, 2018 at 02:49 AM

    Hello, once I completed the Google Spreadsheet integration, in the google spreadsheet side will update data if have continue submits?

    And in this spreadsheet doc if I make change of data, this change will be update in the Jotform "View submission" data?

  • Profile Image
    Jim_R
    Answered on January 06, 2018 at 03:00 AM

    Hello, once I completed the Google Spreadsheet integration, in the google spreadsheet side will update data if have continue submits?

    That's correct - Every submission done on your form will be added as a row to the integrated Google Sheet.

    And in this spreadsheet doc if I make change of data, this change will be update in the Jotform "View submission" data?

    No it doesn't work the other way around. Your SUBMISSION DATA will never change if you update the sheet. In fact, we discourage users from editing the sheet to avoid breaking the integration.

    You can only change your SUBMISSION DATA by editing submissions.