Nick
Member
I'm using some numbers fields to do some basic math based on a user submission in the first number field. Two questions:
1. Can I make the calculation fields empty until the first field is filled in? As it is, they show weird numbers based on the math that are completely irrelevant.
2. Since the numbers represent money, is there a way to force two decimal places even when the hundredths place is zero? I want 2.50 to show as 2.50, not 2.5.
Thanks!
Can you use conditional logic to hide the field until the last number required for the calculation is entered? I don't know of a way to blank the field out until the last value is entered, without using jQuery.
Please see this for formatting a field as currency:
http://gravitywiz.com/2012/05/24/format-field-as-currency/
That was written by Gravity Forms developer David Smith.
Nick
Member
Duh, I should have thought about conditionally displaying the math fields, that's an easy one. Thank you.
Unfortunately the link you sent keeps breaking my form. Plus, reading through the comments, it doesn't work on number fields, which I need since I'm doing math.
"Unfortunately the link you sent keeps breaking my form."
Can you explain what you mean?
To force a field to be 2 decimal places, and still be a number, you can use different jQuery, like this http://stackoverflow.com/a/478266
cphillips.ia
Member
I have the same issue. The "breaking" in http://gravitywiz.com/2012/05/24/format-field-as-currency/ references some single quotes the were not escaped, but that aside, this did not actually solve the problem. The solution David highlights in his article only works with text fields, not number fields... We need several fields that do calculation to display results as currency.
@cphillips.ia, please include a link to the page on your site where we can see the form, and let us know which fields you're trying to format as currency. David's solution was meant to work in general cases, but you may need something more specific, but utilizing the same approach.
Please email chris@rocketgenius.com - there is no PM function here.
I've been having a similar problem. I have two number fields feeding into a total number field with a calculation and for some reason the snippet suggested here http://gravitywiz.com/2012/05/24/format-field-as-currency/ breaks two of number fields the total one displays fine. Here's a link to the test form I've been working on http://www.christianlegacy.org.uk/pdf-form-test/ . I've also noticed that the two non functioning numbers fields are also not displaying decimal points number format. Is there any reason for this?
The number fields will not work for calculations after applying this code. Please see this comment from David Smith http://gravitywiz.com/format-field-as-currency/#comment-1589
