I am creating a form for transferring funds from one budget account to another. So, the person enters the account numbers and the amounts to increase/decrease each one to effectively move dollars around.
How do I make the Decrease column display as a negative number with two decimals in parentheses - e.g. (200.00) even if it is input as a positive number - e.g. 200.00?
Probably the simplest way is to convert any positive values to negative and set up the field format so that negative numbers display as you want. You can use a custom Validate script to do this:
if (+event.value > 0) event.value = -event.value;
Worked like a charm - you are my hero of the day! Thank you!