Formatting Negative Numbers

customaware

On a BO Form, I want the user to be able to enter a negative number of the form...

-1,234.56 and then as the user Tabs away from the field or saves the form, I want it to display as (1,234.56)
Also want it to display in a Query as (1,234.56)

Does anyone know of a way to achieve that please?

idpSteve

I think you can try something like

#;(#)

for the number format. I remember getting some errors around this, I don't remember what worked but I think that's part of the fix! Let me know..

customaware

Tried that but it did not work

BLOMASKY

I know with HTML you can have <<BO.attr @ ###,###;(###,###)>>

but you want to do this with the actual attribute format. Not sure if you can do that.

Of course, for the query, you could have a plain text field that is updated when the actual field changes and is formatted properly, but that won't solve the problem of the user tabbing out of the field. I am not sure if you would get stuck in an endless loop, but could you have the following javascript in your form render script:

var cq = parser.getField("customerQty");

$("#" + cq.getId ()).focusout (function () {
if (cq.getValue() != cq.originalValue && cq.getValue() < 0)
cq.setValue('(' + cq.getValue() + ')');
});