Google spreadsheet integration: Modifications

  • Profile Image
    TKR
    Asked on March 21, 2018 at 11:37 AM

    I have a form integrated with google drive and google spreadsheets.

    After using for a few months, I had to include a new field in the form, and the google spreadsheet that was sharing the information, stopped receiving the data.

    1. How to include new fields and update google worksheet automatically?


    2 How to change the field type?

    Example:

    Text box for drop-down menu

  • Profile Image
    aubreybourke
    Answered on March 21, 2018 at 01:00 PM

    When you make a change to your form or to your spreadsheet it will break. The smallest change can break the integration.

    Have you tried removing your current integration and integrating again? It should update properly.

    Finally, I don't believe its possible to change the field type and keep your existing data. When you delete a field then all data associated with that field is gone. Best you can do is keep your old field and hide it on your form.

    How-to-Hide-Form-Fields

    Then add a new field for the new data (that is visible).