How to display a result with decimal and currency

  • Profile Image
    Asked on February 08, 2018 at 03:17 PM

    I've tried everything from the forum and help files. The Masking widget works if it's only user input, and it shows a $ and 00.00. But it won't take calculations. I'm performing calculations. If I use the numbers format for a cell, I get the correct calculation, but I can't add a prefix or decimals. How do I achieve this seemingly simple but impossible task? 

    1518121030Screen Shot 2018-02-08 at 12.1

  • Profile Image
    Answered on February 08, 2018 at 04:32 PM

    You can use a form calculation field. Search for it on the widgets tab.



    Note: When you add your field to the widget you can prefix it with a $ character (click on it so it turns brown). Or append a % character (again click on it so it turns brown. The reason is that when its brown it is treated as a text string. Whereas if its black it is numeric and used in calculations)


    Here's a demo I made:

    1518125281The Easiest Online Form Builde

    Demo here: