How can I add decimal places on calculated fields?

  • Profile Image
    davsun55
    Asked on February 07, 2018 at 08:56 AM
     - The 'Total cost' field is in n.nn format and I'd like the other total fields to be the same. I thought I saw where to nominate decimal places but I can't find it again!
  • Profile Image
    Kevin_G
    Answered on February 07, 2018 at 09:53 AM

    If you're using calculation widgets, you can format the result as shown on the following screen-cast: 

    15180151911.gif

    If you're using a short text entry element, then it cannot be formatted like the calculation widget. 

    I hope this helps. 

  • Profile Image
    davsun55
    Answered on February 08, 2018 at 12:21 AM

    OK - I understand it is not possible. Is it possible to format amount fields with a $ symbol? 

  • Profile Image
    ashwin_d
    Answered on February 08, 2018 at 05:31 AM

    Please note that you can manually add "$" in the form calculation widget. Please check the screenshot below on how to add "$" in the widget:

    1518085761addCurrency.gif

    Hope this helps.

    Do get back to us if you have any questions. 

  • Profile Image
    davsun55
    Answered on February 08, 2018 at 06:00 AM

    That's excellent - thanks. What about the other number fields (Accommodation and Meals)? Also, is there a way of making readonly fields grey so they don't look like they can be edited?

  • Profile Image
    ashwin_d
    Answered on February 08, 2018 at 08:53 AM

    Unfortunately it is not possible to add non-numeric field in number field. The one possibility I can think of is to replace the number field or hide it. You can then add "Form Calculation" widget to read the data from number field and also add "$" symbol as explained earlier. 

    Do try it out and get back to us if you have any questions.

  • Profile Image
    davsun55
    Answered on February 08, 2018 at 09:01 AM

    Thanks - that would work.  :)