Prevent Letters In Currency Field

[SWalker]

Hello, I have had a problem recently with people entering n/a into currency fields. When they do this, the field is stored in the database as a blank causing many issues. Is there a way to prevent text from being entered into the currency field like other number fields?

I have set up a table rule to fix this mistake on the backend but would ideally like to stop it on the front end.

[SuiteUpstairs]

Hey @SWalker, I agree that this field should only allow numbers. As a work around, you could use a number field instead of the currency field. If you need the dollar sign to appear on the table you can use a display rule. Just an idea until that gets fixed.