- kubinyiAsked on February 27, 2013 at 08:54 PM
My forms are integrated with google spreadsheet and the integration has been working fine, however when looking at the spreadsheet there are many inconsistencies sush as date format, justification, font size and font type etc. Is this a known issue? If I delete my spreedsheet file and re-create the integration all the existing data gets copied into the new spreadsheet with the same formatting however when new submissions occur later the inconsistent formatting can be observed again.
- jeanettebmzAnswered on February 27, 2013 at 10:39 PM
I have tried to reproduce the error. With no success
Can you please refer to us the formID and the spreadsheet link?
- kubinyiAnswered on March 03, 2013 at 04:58 PM
Here is an example of the formatting issue:
I also noticed that if I delete and re-create the integration all the records are formatted nicely and consistently - these are the already existing submissions, however the next time a new submission happens the formatting changes, this is what you can see in the screenshot above. I don't think our forms do anything special, you should be able to reproduce this by using a quick test form with a date field. I see this with the following form 23467496352159.
- kubinyiAnswered on March 03, 2013 at 05:03 PM
It seems to me that the difference lies in the fact if you are doing a submission verses exporting\importing all the already exisitng records.
- jeanettebmzAnswered on March 03, 2013 at 05:36 PM
I checked the link for your website you embedded on this thread, we will make some tests to determine what is causing this
- kubinyiAnswered on March 08, 2013 at 06:30 PM
I found another discrapancy when integrating with google sreadsheets. See the following two records:
This one is produced when the integration is 're-set' or set up for the first time and existing submission data is being sent to the sheet:
16U\18U Water Polo (Amount: 375.00 USD)
==Payer Info==First Name KurtLast Name BergtholdE-Mail email@example.com
This one is produced when the integration is already set up and there's a new submission by a user:
<table cellpadding="0" cellspacing="0" border="0"><tr><td>16U\18U Water Polo (Amount: 375.00 USD)<br>Total: $375.00<br></td></tr><tr><td><br />
<table cellpadding="0" cellspacing="0" border="0" style="font-size:10px;"><tr><td colspan="2"><b style="color:#777; font-size:12px;">==Payer Info==</b></td></tr><tr><td width="70"><b style="color:#777">First Name</b> </td><td>Alex</td></tr><tr><td><b style="color:#777">Last Name</b> </td><td>Koper</td></tr><tr><td><b style="color:#777">E-Mail</b> </td><td>firstname.lastname@example.org</td></tr></table></td></tr></table>
They are both done by the same form: http://form.jotformpro.com/form/30245729648966
Have you been able to duplicate this issue?
- kubinyiAnswered on March 12, 2013 at 04:51 PM
Do you have any updates for this issue?
- jeanettebmzAnswered on March 12, 2013 at 05:13 PM
I am forwarding the issue to our developers to be taken care ASAP
- kubinyiAnswered on April 01, 2013 at 08:17 PM
Any udate on this issue yet?
- sidharth_kchAnswered on April 02, 2013 at 03:19 AM
This has been already reported to our development team but we haven't received any updates yet. As soon as there are any updates on this you will be informed.
- kubinyiAnswered on April 10, 2013 at 08:36 PM
I'm sorry but I reported this 6 weeks ago, and it is just a formatting discrepancy I though it would be a simple fix. Why is this taking so long to address?
- JotForm SupportjonathanAnswered on April 10, 2013 at 09:29 PM
We apologize for the latency of a solution to this issue.
Currently, the bug ticket for this is till open and even marked as important. But unfortunately, bug tickets are also being addressed by developers according to priority sequence. This ticket is not reached yet in the sequence up to this time.
We ask for your patience and understanding for waiting on this. It will be dealt with by our developer once the ticket number is reached.
- alp_denizAnswered on August 02, 2014 at 06:03 AM
Please accept my apologies for this late update. As of April 2014 we have totally re-build our Google spreadsheets integration and it is being refined for over 6 months already.
I sincerely hope that you are experiencing the issue. Otherwise, please let us know.