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

    Advanced Spreadsheet adds decimal places to typed numbers - How to stop that?

    Asked by fsvault on June 22, 2015 at 02:56 PM

    I have a form that I need to allow people to add different numbers into the different columns I created. The problem is whenever anyone types a number in any of the cells, it converts the number into a dollar amount by adding ".00" at the end of the number. 

    How can I change the setting on that so it doesn't do that anymore?

    Page URL:
    http://www.jotformpro.com/form/51616754374965

    Screenshot
    table amount Advanced spreadsheet decimal places
  • Profile Image

    Answered by Ben on June 22, 2015 at 04:36 PM

    Unfortunately there is no option that would do that for you. This is a feature that is built into the widget so that it will do that for you, but if use Spreadsheet widget instead (notice it missing 'advanced' in the name), you will quickly see that there are no decimal numbers added to it.

    Do let us know how it goes.

  • Profile Image

    Answered by Estefania  on June 22, 2015 at 06:56 PM

    The thing is, we need to change the column/row headings to have labels. For this reason, we started using the Advanced Spreadsheet widget. However, this widget changes all the numbers to dollar amounts. In the demo, there is no dollar amounts so I figured that there must be a way for this to work that way.

     

     

  • Profile Image
    JotForm Support

    Answered by Chriistian on June 22, 2015 at 10:49 PM

    Hi Estefania, 

     

    I checked the Advanced Spreadsheet widget and unfortunately, I was not able to find any workaround to this. I can escalate this issue to our development team as a feature request. I just need your confirmation if you want this feature to be added in the widget. However, I cannot guarantee if this feature will be added. It will depend on the findings of our development team. 

     

    We will wait for your response.

     

    Regards.

  • Profile Image

    Answered by Estefania  on June 23, 2015 at 10:12 AM

    Ok, is there any way to change the column/row labels with the regular spreadsheet? Or is that only available on the Advanced Spreadsheet?
  • Profile Image

    Answered by Ben on June 23, 2015 at 11:31 AM

    Yes, you can do that, but it requires a bit of CSS.

    Now I have moved that to a new thread here: http://www.jotform.com/answers/594776 so that we can assist you properly with this and will follow up on it shortly with the CSS code that will allow you to do just that.