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.


  • Profile Image

    Number Field: Ability to use comma for decimal numbers.

    Asked by Foltved on March 11, 2016 at 12:04 PM

    Hi Jotform

     

    Trying to prepopulate a field with a value that consists of a whole number and some decimals eg. 7,97 - but how do I get the comma inserted via the URL parameter?

     

     

     



    This is a re-post of a comment on Prepopulating Fields to Your JotForm via URL Parameters

    URL decimal number decimal number passing with
  • Profile Image
    JotForm Support

    Answered by Nik_C on March 11, 2016 at 01:02 PM

    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.

     

  • Profile Image

    Answered by Foltved on March 11, 2016 at 01:46 PM
    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
    ...
  • Profile Image

    Answered by Ben on March 11, 2016 at 02:03 PM

    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.

  • Profile Image

    Answered by Foltved on March 11, 2016 at 02:46 PM
    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
    ...
  • Profile Image
    JotForm Support

    Answered by Nik_C on March 11, 2016 at 03:31 PM

    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.

  • Profile Image

    Answered by Foltved on March 11, 2016 at 04:46 PM
    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
    ...
  • Profile Image
    JotForm Support

    Answered by Nik_C on March 11, 2016 at 05:48 PM

    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.

     

  • Profile Image

    Answered by Foltved on March 11, 2016 at 06:46 PM
    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
    ...
  • Profile Image
    JotForm Support

    Answered by Kevin_G on March 11, 2016 at 08:09 PM

    First of all, I'm forwarding this request to our second level, so if there are more users requesting the same feature our developers might work on this, we can not provide an ETA, but we will let you know here if it is available. 

    Now, you may use the workaround that you found, using the Form Calculation widget to send the value to your spreadsheet, as it allows to use the comma. Here is an example about it: https://form.jotform.com/60696955049975?number1=23,5

    Feel free to clone it