What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Using Google Spreadsheets App.

    Asked by AA_C on December 22, 2014 at 10:17 AM

    Hi,

    I am currently using the Google Spreadsheets App. for two forms. Can I do some or all of the following on my Google sheet and still get the data correctly into the columns or because the names and positions do not correspond will it fail ?

    1) Rename a column

    2) Move a column 

    3) Delete a column

     

    Thank you, Robert

    Agility Association of Canada

    Page URL:
    http://www.jotform.com/33504157430850

    google google spreadsheet spreadsheet google integration renaming column deleting column moving a column
  • Profile Image
    JotForm Support

    Answered by Jan on December 22, 2014 at 11:58 AM

    Hi Robert,

    You cannot rename a column, if you did then the entry will not appear in the spreadsheet. I tried cloning your form and integrate it with my Google spreadsheet and that is exactly what happened. The entry did not show up in the spreadsheet. If you need to rename it then you will be required to rename the field the re-integrate the Google spreadsheet.

    The fields on your form is associated with the column titles on the Google spreadsheets using assigned IDs or keywords. So it is possible for you to move a column as long it still has the same column title.

    You can delete a column from the Google spreadsheet. So even if the user put a data on the field, it won't appear on the spreadsheet.

    Hope this helps. Thank you.

  • Profile Image

    Answered by AA_C on December 22, 2014 at 12:10 PM
    Hello Jan,

    Yes this is very helpful.
    As I thought column names must remain the same, but you say I can move a column or delete it, that’s great!

    So now I have another question, can I integrate the two forms data into one Google sheet as long as the field names are the same?
    I see you have an app for combining forms data, is it possible to use the two apps together?


    Many thanks,
    Robert
    Agility Association of Canada

    ...
  • Profile Image

    Answered by Ben on December 22, 2014 at 01:34 PM

    Hi Robert,

    As I thought column names must remain the same, but you say I can move a column or delete it, that’s great!

    I would like to add that while possible, it might result in a need to recreate the integration at some point(s) if it breaks due to the changes. Our system will try to send the data to the spreadsheet each time, so if you are making a lot of changes in the spreadsheet please test if the submissions are saved into it or if there is a need to recreate the integration.

    So now I have another question, can I integrate the two forms data into one Google sheet as long as the field names are the same?

    Technically yes, you would be able to do so, but when I tested earlier it created the documents with the same name instead - Testing it right now made the same thing happened again, so while technically possible, it is however not.

    Now in regards to your last question about combining it with Combine Submissions app, I have moved that question to a new thread here: http://www.jotform.com/answers/480836 since we can only provide assistance to one issue per thread.

    Best Regards,
    Ben

  • Profile Image

    Answered by AA_C on December 22, 2014 at 01:48 PM

    Hi Ben,

    Thank you for the reply. I understand that I may require a new integration, That's OK if it works for me.

    I found this part somewhat confusing

    Testing it right now made the same thing happened again, so while technically possible, it is however not.

    What do you mean the same thing happened again?

    What do you mean tech. possible but is not possible?

    At some point the light bulb will go on!

    Regards,

    Robert

  • Profile Image

    Answered by Ben on December 22, 2014 at 01:58 PM

    Hi Robert,

    I apologize for the confusion I have created.

    What do you mean the same thing happened again?

    I meant that it created another document with the same name instead of getting associated to the same file created for another integration ("when I tested earlier it created the documents with the same name instead").

    What do you mean tech. possible but is not possible?

    By technically I meant that we could give it the same name and place it in the same folder which would suggest that we would be using the same file, but when actually trying it, it is not possible as Google creates a new spreadsheet with the same name instead.

    I hope this makes more sense, but if not, feel free to let us know.

    Best Regards,
    Ben

  • Profile Image

    Answered by AA_C on December 22, 2014 at 02:50 PM

    OK Ben,

    I got it now. Very interesting. Thanks for clearing that up.

    But as you say it may be possible just not this way...or with this app.

    How then may it be done or can it be done at all?

    Robert

  • Profile Image

    Answered by Ben on December 22, 2014 at 03:25 PM

    Hi Robert,

    You are welcome.

    Unfortunately it seems that it is not possible at this time due to Google creating new spreadsheet instead of using the one with the same name, I apologize if I insinuated that it could.

    It seems that you can not even set Google Forms to use the same spreadsheet.

    I was able to find however a website that has instructions how you can setup the connections from one spreadsheet to several others, but in Excel: http://smallbusiness.chron.com/insert-data-multiple-excel-spreadsheets-one-excel-spreadsheet-75667.html this has lead me to search further for something similar in Google and I might have found it: http://stackoverflow.com/questions/12282419/merge-two-google-forms-data-into-the-one-spreadsheet

    I would suggest taking a look at the later to see if something like that would work for you and if yes, then you would need to manually create it.

    Do let us know how it goes.

    Best Regards,
    Ben

  • Profile Image

    Answered by AA_C on December 22, 2014 at 05:10 PM
    Hi Ben,

    Thanks for doing the research for me.
    I am familiar with the ‘ImportRange’ function so I will try it out. It is dynamic so it should work.
    Unfortunately I have some work to do before I can use it.
    Because my forms are in English and French the field names don’t match so I’m looking into that now before I do anything else.
    ...
  • Profile Image

    Answered by Ben on December 22, 2014 at 05:25 PM

    Hi Robert,

    You are welcome.

    I am glad to hear that you are familiar with it and hopefully it will allow you to accomplish what you are after.

    If you feel that you would like to ask us a question feel free to do so and we would be happy to answer them for you.

    Best Regards,
    Ben

  • Profile Image

    Answered by AA_C on December 22, 2014 at 08:48 PM

    Thanks Ben

  • Profile Image
    JotForm Support

    Answered by ashwin_d on December 23, 2014 at 03:17 AM

    Hello Robert,

    On behalf of my colleague, you are welcome.

    Do get back to us if you have any questions.

    Thank you!