Using Google Spreadsheets App.

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

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.

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?


Many thanks,
Robert
Agility Association of Canada

...

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

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

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

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

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

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.
...

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

Thanks Ben

Hello Robert,

On behalf of my colleague, you are welcome.

Do get back to us if you have any questions.

Thank you!