I've never tried with a Decimal Field, but couldn't you do a REPLACE in a filter Set Fields to remove the $
Set Fields action REPLACE( $Decimal Field$, "$", "" ) Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Tuesday, September 01, 2009 10:16 AM To: arslist@ARSLIST.ORG Subject: Re: Decimal Field ** Hi Joanne, How do I use a mask for this field? It is a decimal field that gets pushed to the same form with an AL. I guess pushing this field content does not throw an error but only pushes 0.00. So if a user enters $150.00 the value ends up 0.00. Anyone have an idea how to prevent this? I put this large note on the form but our staff seems to not read it. You would think we would have good readers at a publishing company :) IMPORTANT Please enter only numbers in the cost field. DO NOT ADD A DOLLAR SIGN ($). Thanks, Brian -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mansur, Joanne Sent: Tuesday, August 11, 2009 1:24 PM To: arslist@ARSLIST.ORG Subject: Re: Decimal Field ** My suggestion would be to put the $ outside the form at the left edge - customers would be less likely to add a $ if there was already one there. But you could also use a mask to be sure that all values entered are either numeric or a decimal point. Hope this helps, Joanne Mansur Client Systems Analyst Northeastern University (617) 373-3295 (office) (617) 373-5985 (fax) j.man...@neu.edu -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Monday, August 10, 2009 2:13 PM To: arslist@ARSLIST.ORG Subject: [ARSLIST] Decimal Field ** I have a form that is part of a purchasing application. The cost field on one of the forms is a decimal field. If a user enters a $ in front of the amount it is saved as 0.00. Any suggestions on preventing the users from entering a dollar sign? Thanks Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
