I searched for this but didn’t find anything matching my issue, so I thought I’d post here. We just discovered that users are able to add text to a currency type column. It gives the red corner triangle with a note staying “Calculation Error. Cannot convert value to the specified format”, if you hover over it, but it doesn’t prevent anyone from typing text into the field. It does this with all number-type columns.
I don’t recall running into this before, but it’s possible that I’ve just never personally tried to add text to a non-text field before.
Has anyone else run into this issue? Does anyone know of a way to actually prevent the entry of non-numerical characters into a currency column (I thought that was the purpose of setting a “number type” of column)?
This can end up being a real problem when we have users who aren’t consistent with data entry.