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.
Google Spreadsheet Integration: Formula "=TEXT()" is showing in Submission ID fieldAsked by mediatask on March 18, 2017 at 05:37 PM
We're experiencing the same issue.
Some ID's are OK, while others are not, see below:
I made a test just now and made changes to the first form in the above list (ID 35071179...) and saved them.
Here's what happened:
So it looks as though only the newly created/changed form get the incorrect sumbission ID's
Hope this helps you fix this issue quickly!
I have forwarded your concern to our development team. You will be informed once this is fixed.
Hello, still not working, can you give me another solution?
@ramblenos - Here's your original thread https://www.jotform.com/answers/1094289 From how I see it, there are no updates yet so please stay tuned.
If you have something to add or have a followup question, please don't reply via email. Instead, open your thread by clicking this link, then kindly post your reply from there.
@jinnie3009 : I had moved your concern to a separate thread at https://www.jotform.com/answers/1096154
You will be replied shortly on the newly created thread.
I tried to disable and re-enable the google spreadhseets integration but instead of helping this made matters worse!
The Submission ID colulmn now displays an ERROR.
Here's a breakdown, which should help you nail down the bug:
1. before the problems started this column displayed only the number, for example:
2. when the bug appeared new or edited entries started showing a stringified formula (note the apostrophe at the beginning!), like this:
3. after resetting the integration ALL entries show a formula (no apostrophe, so GS doesn't treat it as a string), like this:
Up until #2 we managed to workaround by using the Subsitute funciton in GS but now (#3) we're completely screwed.
When will this be fixed?
Sorry for the troubles but we still haven't heard from our Developers about this so I'm following up with them on your behalf.
Seeing that the apostrophe is gone, the sheet now treats it as a formula, thus causing the #ERROR! to show up.
I cloned your form and integrated mine with Google Spreadsheet but failed to reproduce this problem.
Rest assured, we'll keep you apprised on this same thread when there's an update. Thanks in advance for your patience and cooperation.
I reproduced this error on a completely new form:
The result is exactly the same - I get a formula instead of a number in the "Submission ID".
What's more important I also confirmed yet another, perhaps even more critical bug:
Edited submissions show up on top of the google spreadsheet and overwrite other records!
Step 1. I created 2 submissions priort to integrating with GS and one after making the integration.
Up until this point it works ok (except the issue with Submission ID of course)
I then edited the second entry (test2)
Step 2. Now the edited entry shows up overwriting entry 1!
Step 3. A look at the jotform database shows that the data is intact, so it's only a Google Spreadsheets integration error
In our business we strongly rely on JotForm's google spreadhseets integration and these critical bugs produce significant problems. I strongly urge you tu fix these. Please inform me when can we expect these issues to be resolved.
I had forwarded you observation to our Developer team and requested them for updated.
You will posted in the same thread about the status update.
Thanks for your patience.
Waiting for the solution.
Manwhile I have narrowed the problem for you even further:
You're using a comma instead of a semicolon as the parameter separator in the function.
Semicolon should be used as it is the GS default which will work universally. A comma apparently only works for some locations. (that would explain why you couldn't replicate the problem)
See this related threads:
So, if instead of
the integration script would produce this
the problem should hopefully be resolved.
At least partially.
We found a workaround which involed changing the local/language settings in our Google Spreadsheets account.
It is however a temporary workaround, I still hope you will fix the issue and let us know when we can go back to our initial setup.
Thank you for updating us. The solution you provided on this thread (https://www.jotform.com/answers/1094289) is very helpful. This thread is already assigned to one our developers and it is still open.
We'll let you know once the issue is fixed.