I didn’t see an option to tell a calculated field to have only 2 decimal places. My calculated field is working fine but has a result of something like 28.1324333 where I would like it to be a currency result like 28.13. Is there an easy way to do this? I want it to be in a read only field that basically displays the total for the user so I guess I will also want to add a dollar sign to it if possible.
Any plans on adding a currency field to future versions?
Thanks,
-Darrin
August 18, 2011 at 2:18 pm
There probably won't be a currency field, but options added to a number field to format it as currency.
There's a post going right now with some changes that will be included in the next version for formatting numbers in the custom display:
http://formidablepro.com/help-desk/how-to-format-number-with-a-comma-2/
Formatting the original calculation on the other hand is a bit more complicated to include without some big changes. For now, you can make this change, but it will need to be made after each update until this is an included option.
Please open formidable/pro/classes/views/frmpro-entries/footer_js.php
Change line 130 from:
$("#field_<?php echo $result ?>").val(total);
to:
$("#field_<?php echo $result ?>").val(Math.round(total*100)/100);
August 18, 2011 at 4:21 pm
Thank you much! Fixed it for me. :)
-Darrin
Topic closed.