Spreadsheet wizard: How to have values with only 2 decimal places

  • Profile Image
    chantalclarkson
    Asked on August 09, 2018 at 12:57 PM

    1533833844jotform question.JPG

  • Profile Image
    AshtonP
    Answered on August 09, 2018 at 02:21 PM

    I tried several ways to limit the decimal points to two places however it didn't work. The spreadsheet widget doesn't support this setting.

    If you are embedding this form in your website, javascript could be used to achieve this. Alternatively, I'll try to look for any other widget that serves the same purpose, if you would like.

  • Profile Image
    chantalclarkson
    Answered on August 09, 2018 at 03:03 PM

    Sounds good! Thank you for looking into this.

  • Profile Image
    AshtonP
    Answered on August 09, 2018 at 03:39 PM

    I'll look into this and post the further updates here.

  • Profile Image
    AshtonP
    Answered on August 10, 2018 at 05:04 PM

    I tried with few other alternatives which didn't quite work like a spreadsheet. This is the best widget to use in your form hence I have elevated this request to our Development team with feature requesting to limit the decimal points. Please note we cannot provide an ETA when this will be implemented in future. Our developers will post the updates here in case of further progress.  

  • Profile Image
    chantalclarkson
    Answered on August 13, 2018 at 11:37 AM

    Thank you for putting in a request to your development team.