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

  • chantalclarkson
    Asked on August 9, 2018 at 12:57 PM

    1533833844jotform question Screenshot 10

  • AshtonP
    Replied on August 9, 2018 at 2: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.

  • chantalclarkson
    Replied on August 9, 2018 at 3:03 PM

    Sounds good! Thank you for looking into this.

  • AshtonP
    Replied on August 9, 2018 at 3:39 PM

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

  • AshtonP
    Replied on August 10, 2018 at 5: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.  

  • chantalclarkson
    Replied on August 13, 2018 at 11:37 AM

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