Google spreadsheet integration clarification request & improvement suggestion

  • Profile Image
    dkanotister
    Asked on May 28, 2012 at 03:36 PM

    The way it's currently implemented, while useful, is quite brittle on the google docs side. Please clarify what can be done on the google docs side. I've seen some notes on this in the forum, but it's a bit unclear still to many, I am sure.

    After the integration is initiated and data is submitted,

    - Can columns be added / removed?

    Answer: I saw a post saying this would be ok???

    - Can the submitted data be changed?

    A: I saw a post saying this is NOT ok to do?

    - Can the form be edited?

    A: I have tried this myself, and it causes a new spreadsheet with the same name to be created. 

    The biggest thing (in addition to supporting unicode or at least ISO8859-1 char set) I'd like to see is non-destructiveness. If I add a field to the form, the new columns should be added to the existing sheet, rather than recreating the sheet. If I remove a field, that column should not be removed from the spreadsheet. If I import data from elsewhere to the sheet, it should not be touched. So append-only operation.

    On the other hand, when the integration is initiated, all the existing records should first be copied to the newly created spreadsheet.

    Just my two cents.

  • Profile Image
    Mike_T
    Answered on May 28, 2012 at 04:57 PM

    Thank you for your feedback.

    Can columns be added / removed?

    Yes, you are right. It would be okay.

    Can the submitted data be changed?

    Yes, you can change the submitted data, but these changes will not be reflected on your JotForm account.

    Please note that you should avoid changing Headers in Google Doc Spreadsheet. If you change the Header name, integration for that field will be broken.

    Can the form be edited?

    I have tried this myself, and it causes a new spreadsheet with the same name to be created.

    The biggest thing (in addition to supporting unicode or at least ISO8859-1 char set) I'd like to see is

    non-destructiveness. If I add a field to the form, the new columns should be added to the existing sheet, rather than recreating the sheet. If I remove a field, that column should not be removed from the spreadsheet. If I import data from elsewhere to the sheet, it should not be touched. So append-only operation.

    You are right, you can change the form, and this will bring you to the new spreadsheet.

    I think that our Developers have decided to implement the integration in this way, and this is not something that can be changed.

    I hope that the problem with the charset will be fixed in the nearest time. We will keep you updated through your other thread.

    On the other hand, when the integration is initiated, all the existing records should first be copied to the newly created spreadsheet.

    Yes, this is currently how it works. All the form data is being copied to the new spreadsheet, so you can see all your records even from updated form.

    Please feel free to contact us if you need any further assistance.

  • Profile Image
    dkanotister
    Answered on June 11, 2012 at 05:57 AM

    Thanks for the clarifications. One more thing I forgot to ask: what about reordering columns? My tentative experience is that reordering (no other changes) causes the data to fall out of sync with the (reordered) spreadsheet column names. It looks like the integration is also fixed on column order?

    It is rather rigid if one must maintain both column names AND their order. One or the other is necessary, obviously, but it would be nice if reordering was possible.

  • Profile Image
    jeanettebmz
    Answered on June 11, 2012 at 12:50 PM

    @dkanotister

    I have done some tests with google integration. And definetely, you can change the column order, but you need to maintain the column names.

    Cheers!

    Jeanette