- BenAnswered on April 08, 2015 at 11:54 AM
I apologize for the inconvenience. Since I am able to recreate the issue, I am raising it to our developers for inspection.
As soon as there are any updates in regards to this, we will update you through this thread.
- windirectAnswered on April 08, 2015 at 02:26 PM
the last entries are not complete.
Nome, Cognome, Via, Luogo, Cap, Paese;
- BenAnswered on April 08, 2015 at 04:14 PM
Thank you for adding additional details.
I have already raised this to our developers so as soon as there are any updates, they will update you here.
- windirectAnswered on April 09, 2015 at 05:46 AM
the spreadsheet does not synchronize today.
what can i do?
- BenAnswered on April 09, 2015 at 10:30 AM
Unfortunately we will need to wait for the time when the developer posts the update on the forum that the integration is again possible. Until that time, you will not be able to create the spreadsheet.
The only temporary alternative if you must have the data in the spreadsheet would be to use Zapier.
This is the Zap that might be able to assist you: https://zapier.com/zapbook/jotform/google-sheets/
You can see more about how to create the integration over the zap here: JotForm is now on Zapier: Send Your Form Data to 100+ Web Services
- BenAnswered on April 09, 2015 at 12:42 PM
Our developers have notified us that the Google integration issue has just been resolved.
Please try to connect to it by:
1. removing the current integration
2. creating a new Google Spreadsheet integration
Do let us know if you have any further issues after following these steps.
- BenAnswered on April 09, 2015 at 01:57 PM
We always urge you to open a new thread for your issue so that we can best assist you. Now since this thread is opened by windirect, I have moved your thread to here: http://www.jotform.com/answers/549512
Our developer will be answering it for you shortly.
That way we will be able to assist you and assist the thread owner windirect.
- windirectAnswered on April 09, 2015 at 03:15 PM
I have created a new sheet. Now missing the entry in the first column :-((
- windirectAnswered on April 09, 2015 at 03:23 PM
I work with scripts and copy the data to my company database. When changing the columns I need to change the skripte every time. :-((
Please tell the developers: Please.... No longer move the column !!
- BenAnswered on April 09, 2015 at 04:57 PM
This is not directly related to Google Spreadsheet, but since you say that you are copying the data to database, I would recommend checking out our webhooks integration. It will allow you to pass the data to your scripts directly, so that you can take care of it in the manner of your choice.
This should work with Google scripts. I know that you could capture POST, so this should be possible, but also possible over the php scripts.
Now in regards to the spreadsheet columns.
I believe that you would be able to move them around and to have the integration still upgrade the data properly.
Please do note that you should not make any changes to the spreadsheet however such as adding scripts to it since that could break the integration as well at some point. I would always suggest using ImportRange option and import data from this spreadsheet to another one with the script.
Doing it this way, will mean that even if you create new integration, all you would need to do is to change the import range function to point it to a new spreadsheet.
- BenAnswered on April 09, 2015 at 04:59 PM
Just to add, you can see more about webhooks here: How to Setup Webhook with JotForm
Also, if once you move the columns, the integration is not updating the cells properly do let us know and we will raise this to our developers.
- windirectAnswered on April 10, 2015 at 02:02 AM
My endpoint is another spreadsheet. Even with import range I had the same problem. If a value in another column migrates everything has to be changed.
if I get a new entry of Jot in the spreadsheet, then I copy with scripts in the endpoint sheet and delete the entry to avoid duplicate. At the moment I do not have the value in the first column.
- JotForm SupportWelvinAnswered on April 10, 2015 at 09:26 AM
You probably had something in your script that automatically deletes the content in the first column. Can you check? You have few submissions in the "Tipo richiesta" field and it's impossible that the spreadsheet integration wouldn't include these data.
If you don't mind, can you share the script here so we can try it too? Just to help you debug and confirm the case.
I have cloned the form and made a few submissions and they all appear in the sheet so I suspect something in your script that creates the issue.
Clone form: http://www.jotformpro.com/form/50993717109967
- windirectAnswered on April 10, 2015 at 09:43 AM
I'm sorry my bug !!!
Before that, I always deleted column A.
I hope that will not happen and the columns do not move more;-)
- JotForm SupportWelvinAnswered on April 10, 2015 at 10:46 AM
No worries. I would suggest changing the way how you process the data and make sure that all columns in the original sheet will remain intact.
Please contact us again if there are any problems.
Have a great day!
- windirectAnswered on April 13, 2015 at 05:16 AM
I'm looking for some time for a solution to embed the form in wordpress.
Today user call me because they have problems with the I pad.
Various applications such as for example mobile menu and toggles on the left are blocked.
I think the reason for this is the embed code.
Currently works Chrome, Firefox and IE.
Before I had always problems with scrolling on IE.
Please have a look
my wodpress Site http://it.win-direct.com/preventivo-infissi/
<iframe id="JotFormIFrame" frameborder="0" scrolling="yes" style="width: 100%; height: 2720px; border: medium none;" src="//form.jotformeu.com/form/50076119320344?nojump" allowtransparency="true">
- BenAnswered on April 13, 2015 at 08:29 AM
Since we can only assist with one issue / question per thread I have moved your question to a new thread here: http://www.jotform.com/answers/551178
We will be replying to it shortly.
- windirectAnswered on April 18, 2015 at 06:18 AM
here is my sheet from yesterday
Today I have column A - Submission Date!
Everything moved again
- windirectAnswered on April 18, 2015 at 06:22 AM
I noticed is the last entry.
- JotForm SupportBJoannaAnswered on April 18, 2015 at 07:39 AM
Considering that I can not access to your Google Integration Spreadsheet I cloned and tested your form and I can not reproduce problem with dates. However Submission date is in Column A and this is normal behavior.
Are you still facing problem with wrong dates? In case you are you can try
1. removing the current integration
Hope this will help. Let us know if you need further assistance.
- windirectAnswered on April 21, 2015 at 10:46 AM
I have every day a new problem!!!
now I have a part of the fields blank. Nome, Cognome, (Firstname and name) is blank.
This has nothing to do with my script. I've checked
- windirectAnswered on April 21, 2015 at 10:49 AM
I get only a part of the data !!!
it just does not work !! The columns have shifted again. And now missing half the data !!!
I have not changed anything since 2 months.
I am sorry
if that does not work I will look for another provider.
- BenAnswered on April 21, 2015 at 12:05 PM
I believe that the issue here is that you have a different local settings of your spreadsheet than it is for example if it is set as Spain.
If I change back to English, the date and everything was working.
Could you please check and let us know if that works for you as well.
If not, we will raise this to our developer to check and see what might be the issue.
- windirectAnswered on April 21, 2015 at 12:28 PM
I tested with this setting ...
the same problem!
- BenAnswered on April 21, 2015 at 12:43 PM
OK thank you for the screenshot. I am notifying our developer working on this to take a look and help resolve this issue.
He will update you on this thread as soon as he inspects the issue and finds what is the cause of it.
In the mean time I can only suggest to use zap to connect your jotform with zapier: JotForm -> Google SpreadSheet
- windirectAnswered on April 21, 2015 at 12:57 PM
I only need a stable interface. I do not need anything else.
Today I had a record. The missing completely in the spreadsheet and I did not get any mail from Jot. We solve a problem and get it 2 new.
- alp_denizAnswered on April 21, 2015 at 01:06 PM
I was working on additional features and it has been a very difficult month for me. Please accept my sincere apologies for the problems you experience. I will make sure they are resolved today and update this thread.
Thank you for your understanding
- windirectAnswered on April 21, 2015 at 01:41 PM
Okay thanks. Please find a solution.
- alp_denizAnswered on April 26, 2015 at 10:07 PM
The problems should have been fixed, however, unfortunately I was not able to test your integration. Could you please let me know?
All the best
- windirectAnswered on April 29, 2015 at 10:07 AM
what should i do?
I still receive incomplete data!
- BenAnswered on April 29, 2015 at 11:32 AM
Yes, do try to remove the integration and then recreate the integration once again to see if the same issue is still present for you or not.
If it is, do update us here about it.