Number Field: Ability to use comma for decimal numbers.

I'm not sure I understood you completely, but you can prepopulate your field with 7,9 if you use constructed URL, for example this URL is empty:

https://form.jotform.com/60704714500950

But this one will have number 7,9 in 'number' field:

https://form.jotform.com/60704714500950?number=7,9

If you had something else in mind, please give us more information so we can assist you better.

 

Hi

I see that it work fine in your form

But my form, with these paramters attached leaves the field blank

https://form.jotform.com/60702642924958??jobtype=1 &crop=2&costGroup=2&materialCost=7,07&averageSalary=500&weightPer=5&yieldPer=5&salaryMethod=Piece

Any ideas?

Med venlig hilsen

Simon Jakobsen
____________________________

Telefon : 98 25 98 88 / 42 44 98 25
Mail: foltved@foltved.dk
Web: www.foltved.dk


Fra: Jotform [mailto:noreply@jotform.com]
Sendt: 11. marts 2016 19:02
Til: foltved@foltved.dk
Emne: Re: Hi JotformTrying to prepopulate a field with a value that consists of a

A new response has been received:

Answered by Nik_C
I'm not sure I understood you completely, but you can prepopulate your field with 7,9 if you use constructed URL, for example this URL is empty:
https://form.jotform.com/60704714500950
But this one will have number 7,9 in 'number' field:
https://form.jotform.com/60704714500950?number=7,9
If you had something else in mind, please give us more information so we can assist you better.

View this thread on browser » Unsubscribe Thread
1457719378
...

There are 2 issues here - based on the link that you have posted Simon.

1st issue - the space

There is a space in the URL right after the jobtype - I do believe that this is something that happened while you were posting the link here and that usually it is not giving you trouble.

2nd issue - the field type

You are using the number field to get the value - which would be desired, but the number only accepts dot as the decimal space separator.

As such the following will work for both text box field and the number field:

https://form.jotform.com/60705586248967?materialCost=7.07&materialCost20=7.07

- with both using dots.

However if we change it up to comma it will only work for text box field:

https://form.jotform.com/60705586248967?materialCost=7,07&materialCost20=7,07

As such for your form you would need to either use the following link:

https://form.jotform.com/60702642924958??jobtype=1&crop=2&costGroup=2&materialCost=7.07&averageSalary=500&weightPer=5&yieldPer=5&

(with a dot)

or change that field into the Text Box field instead.

Ok Thanks for the explanation.

It would off course be better that commas was supported in the form, since its integrated with google sheets, and I’m guessing that if change it to a text field, then it will be formatted as such in google sheets/Excel, meaning some formulas can’t use the field input directly, since it is text formatted.

Any change of adding comma supported number fields on a feature request list?


Med venlig hilsen

Simon Jakobsen
____________________________

Telefon : 98 25 98 88 / 42 44 98 25
Mail: foltved@foltved.dk
Web: www.foltved.dk


Fra: Jotform [mailto:noreply@jotform.com]
Sendt: 11. marts 2016 20:03
Til: foltved@foltved.dk
Emne: Re: How to prepopulate field with decimal number through URL?

A new response has been received:

Answered by Ben
There are 2 issues here - based on the link that you have posted Simon.
1st issue - the space
There is a space in the URL right after the jobtype - I do believe that this is something that happened while you were posting the link here and that usually it is not giving you trouble.
2nd issue - the field type
You are using the number field to get the value - which would be desired, but the number only accepts dot as the decimal space separator.
As such the following will work for both text box field and the number field:
https://form.jotform.com/60705586248967?materialCost=7.07 &materialCost20=7.07
- with both using dots.
However if we change it up to comma it will only work for text box field:
https://form.jotform.com/60705586248967?materialCost=7,07 &materialCost20=7,07
As such for your form you would need to either use the following link:
https://form.jotform.com/60702642924958??jobtype=1 &crop=2&costGroup=2&materialCost=7.07&averageSalary=500&weightPer=5&yieldPer=5&
(with a dot)
or change that field into the Text Box field instead.
View this thread on browser » Unsubscribe Thread
1457723021
...

Before we submit a feature request, can you give us some example of your workflow, so we can have better understanding of the problem you are having with spreadsheets?

We'll wait for your response.

Yes of course.

I’m using the form to keep track of and assign salary expenses to different kind of crops, areas and processes.

The workflow for my employees will be as following:
Employee just finished planting strawberry plants
He opens our work registration app, and chooses a prepopulated link to the form that matches the type of work he has just been doing (Off course the link is presented to the employee as plain text ex. “STRAWBERRY PLANTING” )
And when the employe only has to choose his type of work, and the amount of hours spend, I am sure off that they don’t forget to put on, what kind of crop they worked with, which field area shall the cost be assigned to and so on. Plus keeping data integrity intact, so that I can use the submissions for further calculation in my spreadsheets.


I have attached an image of my link generator spreadsheet.
Everytime we as a company see a new worktype that we want to know the exact cost of performing, we can create them vertically in column A and B, and then I can assign some settings to them.
For example can I assign the Jobtype “Picking Strawberry with Crop number 2, Cost group 3, Materialcost 707 and so on. And at last it automatically generates a prepopulated link to my form.
The clever thing about it is that when I change a setting for a worktype, the link changes automatic as well. Plus some of the variables are based on previous registrations made via the form. For example is the average salary cost based on what has been submitted in the last 14 days. Saving me from manually updating the link constantly.

Hope it makes sense.


Med venlig hilsen

Simon Jakobsen
____________________________

Telefon : 98 25 98 88 / 42 44 98 25
Mail: foltved@foltved.dk
Web: www.foltved.dk


Fra: Jotform [mailto:noreply@jotform.com]
Sendt: 11. marts 2016 21:31
Til: foltved@foltved.dk
Emne: Re: How to prepopulate field with decimal number through URL?

A new response has been received:

Answered by Nik_C
Before we submit a feature request, can you give us some example of your workflow, so we can have better understanding of the problem you are having with spreadsheets?
We'll wait for your response.
View this thread on browser » Unsubscribe Thread
1457728266
...

Can you please elaborate more why decimal number with a dot as separator is not working for you in excel?

I tried performing calculations in Google spreadsheet based on the form submission data and I had no issues in using the submission data for the material cost in the calculations.

 

Because in Denmark dot separated numbers isn’t the standard, we use comma separated numbers. So my locale settings for Google Spreadsheets as well as Excel settings will make it into a trouble, not to mention that it would just look wring in our eys to have dot separated values.


I can make a workaround in Google spreadsheet and Excel, where I rewrite dot separated values into comma separated, but its more formulas, and it costs spreadsheet performance.

It would just be much appreciated from my part of the world, if you could fully support our way of using decimal separators.

And know it hits me that, the widget “Form Calculation” can support comma separators, which by the way could be an alternative to using a text field, since it is possible to disable the read-only settings in the widget field, and set it to use comma separators – Think I just found a solution to my formatting concerns :)

Med venlig hilsen

Simon Jakobsen
____________________________

Telefon : 98 25 98 88 / 42 44 98 25
Mail: foltved@foltved.dk
Web: www.foltved.dk


Fra: Jotform [mailto:noreply@jotform.com]
Sendt: 11. marts 2016 23:48
Til: foltved@foltved.dk
Emne: Re: How to prepopulate field with decimal number through URL?

A new response has been received:

Answered by Nik_C
Can you please elaborate more why decimal number with a dot as separator is not working for you in excel?
I tried performing calculations in Google spreadsheet based on the form on the form submission and I had no issues in using the submission data for the material cost in the calculations.

View this thread on browser » Unsubscribe Thread
1457736532
...