Hello All
I am working on a new workflow that will have a cost field in it and the purpose is to enter the cost of the item. The cost field is a number that will range from $999,999.99 to $0.01
I started out with a numeric text field but that will just allow entry of numbers so that did not work.
I have now found the MaskEdit componet which allows me to start the box with a "$" and I can place commas and a decimal to format as a money field but when you enter the numbers say 5000, it displays it as $500,0. I have tried all variations of the mask filters but I cannot find a way that if someone enter 5000 and it shows as $50.00 in the field.
Does anyone know the best way to get my results that I am looking for.
Thanks for any information that anyone can provide me.
Richard