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.
I think this is a spreadsheet issue the slider was set on 4-16 Google thought it was a date
I'm sorry for the trouble caused to you.
It seems you are right. I did test the "Fancy Range Slidr" widget and I am able to replicate the issue you are having. The google spreadsheet displays the value of Fancy Range Slidr widget as date.
I am reporting it to our back end team. We will get back to you as soon as this issue is fixed.
We've made an update to the Fancy Range Slider Widget. We've added a way to output currency prefix/suffix together with the output:
This will make sure that wherever you export your values to Google Spreadsheet- the prefix is added as well - https://docs.google.com/spreadsheets/d/1ro_PpKmxnCi4AEa-NxhTxzJcYRKyzmB9A5OwcapLN1Y/edit?usp=sharing so it will not be reformatted to a date value.
You will have to re-add the widget to get the update (be careful not to lose your existing submissions - use a copy of your form)
Another way in which you can resolve the formatting issue is to instruct Google Spreadsheet on the kind of values expected for that column:
Let us know how it goes :-)
I re-installed the fancy range slider and tested.It still shows as a date in Google sheets
I also could not reproduced the original issue anymore.
I made a test using your jotform and integrate it to Google spreadsheet.
The submission result in the spreadsheet for the 'Product Price Range' slider widget is not a date but an range number value, which is correct
You can also try test submitting my test form http://www.jotformpro.com/form/50238089091961 I will check the result on the integrated spreadsheet.
If OK with you, can you also removed the google spreadsheet integration on your jotform http://www.jotform.us/form/43607526368158 and then clone it on your account?
user guide: -How-to-clone-an-existing-form-from-your-account
And then integrate to google spreadsheet on the cloned version. Use the cloned version to test again.
Check if the cloned version will also exhibits the same anomaly as the original form with issue.
Hope this help. Please let us know if issue remains.
Your section was to high 60 cannot be mistaken for a date try the test again but keep the selection under 20 or even under 10
the reported fix should show a $ sign your test does not
You were right. I was now able to reproduced again the problem if you select lower range value.
Here is the test form http://www.jotformpro.com/form/50241916497964
and this is the shared spreadsheet to check the result.
I have now re-opened the ticket for this bug so that our developer assigned will check again.
We will let you know for any status update as soon as we can.
Google Spreadsheet can be very persistent when a set of numbers (integers) contain hyphens, backslashes or periods when trying to figure out what type of value it is. See this forum thread.
The Google spreadsheet autocorrect script can be very helpful at times, and sometimes its devastatingly counterproductive.
Unfortunately - there is little we can do about that, but we can allow you to pass non-numeric characters with the result - so that the numbers with the hyphen between them are not mistaken for a date or scientific sequence.
We added the option to output the prefix (which in your case, is the $ sign) for this purpose:
Kindly Test: http://form.jotformpro.com/form/50250539034952?
Changing the number format in Google spreadsheet may hit or miss (possibly because of the data type designation in the Google Spreadsheet integration) - but please try outputting the prefix value as well - let us know if that works for you.