Google Spreadsheet Integration, we would like the ability to change the order of columns in the spreadsheet

  • Profile Image
    melkris
    Asked on March 27, 2017 at 09:47 AM

    I normally use Google spreadsheet integration. However, I noticed that it is doing something it never used to.  Whenever I rearrange the columns now, the new incoming data keeps putting it in the original format.  It never used to do that.

     

    I need to arrange the data differently, and I'd like it to match the new arranged column headers, but the new incoming responses don't match.

     

    Help!

  • Profile Image
    seth
    Answered on March 27, 2017 at 12:24 PM

    Hello,

    We have updated Google Spreadsheet integration and in this new version it is not possible to change the columns. You can only add columns to the end of the sheet, otherwise the integration breaks.

    If you want to re-arrange the fields, you need to do it on your forms, in this way, it will be reflected to the sheet you created.

    I hope this answer helps. Please don't hesitate to contact us for your further queries.

     

    All the best!

  • Profile Image
    melkris
    Answered on March 27, 2017 at 01:02 PM

    The problem with what you are saying is that I have to duplicate sheet 1, but the problem is, as new people fill out the form, then I have to go through the process all over again.  Why did you do this? I though when you make a new version things get better not harder?

  • Profile Image
    melkris
    Answered on March 27, 2017 at 01:03 PM

    Can the programmers please fix this?

  • Profile Image
    david
    Answered on March 27, 2017 at 03:49 PM

    The integration was never meant to allow for making changes to the integrated sheet.  Editing columns and such has previously caused the integration to break quite often.  The recommended solution if you need to edit the sheet would be to create a second sheet and use import range to import the data from the first:

    https://support.google.com/docs/answer/3093340?hl=en

  • Profile Image
    melkris
    Answered on March 27, 2017 at 07:04 PM

    Hi David,  You can see how long I have been a user.  The old way worked perfectly when I need to change the order of the columns on sheet 1.  When new respondents filled out the form, the responses followed the new order of columns that I had arranged.  Your suggestion doesn't work because when new respondents fill out the form they will not appear on sheet 2!  That means I have to keep reordering columns and creating duplicate sheets.

     

    Can you ask the programmer to do it the old way, which never gave me any problems whatsover?

  • Profile Image
    melkris
    Answered on March 27, 2017 at 07:46 PM

    I need to be more clear.  It isn't editing of columns I need. It is the ability to rearrange the order only.  I never had any problems doing this before.  I need to do this on sheet 1, so that I get all respondents who apply in the newly arranged order of columns.

    P.S.  If the programmers cannot go back to the old way. What do you mean "import range"?

     

     

    Thanks

  • Profile Image
    Mike_G
    Answered on March 28, 2017 at 12:19 AM

    Thank you for clarifying what you're trying to achieve with the Google Spreadsheet integrated with your form. 

    The IMPORTRANGE my colleague, David, is referring to is explained in this support document from Google: https://support.google.com/docs/answer/3093340?hl=en

    The spreadsheet key described in the document refers to the key attached to the link to your Google Spreadsheet.

     

    Just to show you how it works, please see the screenshots below.

    Screenshot 1: Sheet1 of the Google Spreadsheet integrated with your form.

    Screenshot 2: Sheet2 of the Google Spreadsheet where the IMPORTRANGE is used.

    Notice that in Sheet 2, in column B row 1 (B1) I have placed the IMPORTRANGE with range string referring to the 4th column in Sheet 1 (email field).

    Please note that when there is a submission, Sheet 2 is also automatically updated. Please give it a try and if you have any questions regarding this, please feel free to contact us again anytime and we will be glad to help you.

    Thank you.

  • Profile Image
    bcgi
    Answered on March 28, 2017 at 12:21 AM

    Sorry to be all over the place but can you look into:

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

     

  • Profile Image
    Mike_G
    Answered on March 28, 2017 at 01:59 AM

    @bcgi

    I have checked the thread and I see that one of my colleagues already responded to your most recent post there.

    Please refer to that thread to avoid confusion.

    Thank you.

  • Profile Image
    melkris
    Answered on March 28, 2017 at 11:30 AM

    Dear Programmers,

    I got your message about importrange.  I am not that technical.  The old integration worked fine.  My question is can you please ask your programmers to make it so that I can reconfigure my columns differently, so that new incoming forms are automatically put in the proper column headings according to how I have changed them.  I won't be deleting or editing them, just changing the order. 

    My fear about importrange is that I will do something wrong, and they won't go into the proper columns, plus that takes to long and I am not that technical.

    I don't think I am the only one that would appreciate this.  

  • Profile Image
    david
    Answered on March 28, 2017 at 12:46 PM

    The update was made to ensure the integrity of the integration.  Allowing for editing the sheet caused all sorts of issues with the integration breaking. 

  • Profile Image
    melkris
    Answered on March 28, 2017 at 12:50 PM

    Hi David,

    I don't make editing. I only change the order of the columns.  Can you ask the programmers if they can change it back?  It worked perfectly before. I am sure I am not the only one who will appreciate this?

    I use forms a lot for work, and use google integration in every form I create.

    I am sure others do the same, can you ask the programmers if they can switch it back, it worked perfectly.  I don't edit or delete columns.

     

     

  • Profile Image
    david
    Answered on March 28, 2017 at 02:02 PM

     I will forward a request to our developers to see if they can allow for reordering columns in the integrated sheet.  As previously stated, the updated was due to stability issue so it is not likely to be changed. 

    If there are any updates to your request, we will let you know in this thread.

  • Profile Image
    melkris
    Answered on March 28, 2017 at 02:19 PM

    Hi David,

    I know what you mean about stability when you edit but I never edit.  I had only changed column order in the past, and when I did .. the correct info. displayed in the changed column headings.  With your latest update I noticed it would not do that anymore.

    1.  I never had any stability issues before, so I don't see why you say, it's "not likely to be changed?"

    2.  David, that doesn't give your users any confidence that you actually care about what your customers need to support their processes?

    3.  I feel like you are not reading the threads thoroughly before you post, because I stated I didn't edit earlier in the thread, and you still came back and mentioned editing as a reason for stability issues.

    Do I need to ask someone higher up to please help, because I find that you are not wanting to "help" or properly understand the issue I find with the latest release, because in your last post, you are still talking about stability issues as a reason for not taking this request seriously.

    I am not trying to be difficult, but I seriously think that the Google integration is important not just for me but for a lot of your clients and potential clients.  I think that many people would be benefited!!

     

     

     

     

     

     

     

  • Profile Image
    david
    Answered on March 28, 2017 at 02:30 PM

    1.  I never had any stability issues before, so I don't see why you say, it's "not likely to be changed?"

    I understand this worked for you previously, however, you must understand we have many users and your case may not represent our entire user base.

    2.  David, that doesn't give your users any confidence that you actually care about what your customers need to support their processes?

    We do care about each and every one of our users and do our best to provide a great service as well as support.  Please understand there are technical limitations of what we can provide.

    3.  I feel like you are not reading the threads thoroughly before you post, because I stated I didn't edit earlier in the thread, and you still came back and mentioned editing as a reason for stability issues.

    Changing the order of the columns in the spreadsheet does qualify as editing the spreadsheet.  I fully understand this worked for you previously but the update was necessary.  Ensuring the integration works for all users consistently is our top priority, even if that means removing previous functionality.

    I forwarded your request to our developers to see if the ability to move columns in the sheet can be added once again.  If it is something they can add, they will update this thread to let you know.  I am trying to set realistic expectations with my responses.  We would love to be able to provide everything our users request, sometimes we may not be able to do so.

  • Profile Image
    melkris
    Answered on March 28, 2017 at 03:16 PM

    David,

    Okay, wasn't sure if "editing" also meant reordering of column because as I said I never had stability issues when I simply reordered columns.  

    I did experience stability issues when I edited text or deleted columns, but never when I simply reordered the columns.

    I appreciate your willingness to send to your developers.  I also sent an email to the founder who I had been in contact with via email before.

    I am a fan of Jotform. I recommend it constantly to my colleagues!  Thank you again!

    Many kind thanks,

    Kathy Taylor

    Recruiter, Market Research

     

     

  • Profile Image
    melkris
    Answered on March 29, 2017 at 11:35 AM

    Hi David,

    Just an FYI,  I have had to do my last several jobs going back to Google Forms because of the failed Google integration with the last release, and due to another issue as well.  It seems like the new incoming responses after a while don't continue to populate into sheet 1.  The fix I was doing was constantly deleting the old integration and then creating another integration. Not ideal for my processes, because in my work the analysis that was done on the previous integration is lost each time.

    So now I have had to resort going back to using Google Forms.  It's really disappointing because JotForm has so many more features and options that I really loved.

    In a previous post, you said: Ensuring the integration works for all users consistently is our top priority, even if that means removing previous functionality.

    I don't quite understand that comment.  Ensuring it works for everyone, when how could it be working for everyone by removing previous integrity and functionality?  It isn't really integration if it doesn't work.

    I hope the developers can find a way to restore some integrity back into Google integration?  It's such a disappointment to have to go back to Google Forms. 

    Thanks for your consideration!

     

     

     

     

  • Profile Image
    Denis
    Answered on March 29, 2017 at 11:52 AM

    Hello Kathy,

    We have been working on problems that you are experiencing. Currently,  my team implementing solutions and they will be fixed soon. But still, that can take few days or so. We will keep you updated. 

    Regards.

  • Profile Image
    melkris
    Answered on March 29, 2017 at 12:02 PM

    Hi Denis,

    Good Morning!  Thank you for developing such a great product.   Take all the time you need to get it right. Prefer JotForm over Google Form.

     

     

  • Profile Image
    Denis
    Answered on March 30, 2017 at 08:16 AM

    Hello Kathy, 

    Problem is fixed now. You can change the order of columns. If you need any further assistance please feel free to contact us. 

     

    Regards.