Print this page

Why is the system allowing a user to enter an incorrect data type into a field?

Knowledge Article Number 000220603
Description Why is the system allowing for incorrect data type to be entered into a field?

Examples: 
Text allowed to be entered in number field.
Non email address allowed to be entered in email field.
Text allowed to be entered in date field.
Resolution This is because the internal validation of the system kicks in at the time of saving record.

Hence at the time of entry system does not stop the users from entering incorrect format. However once the save button is clicked the Internal validation rule will prevent the record from getting saved

Ideally at the time of entering a data, nothing gets into the database. Only at the time of saving the data tries to get into the database which gets prevent if the internal validation rule finds that the format is incorrect.

Steps to Test:

1) Create a custom field in any object
2) Select Data Type as 'Number'
3) Add to appropriate profile
4) Add to appropriate layout
5) Save

Once field is created, try creating a new record in the object

Enter text values in the number field created and the system will not stop or prompt any error

But at the time of saving the record, internal validation rule will prevent it. This is working as designed




promote demote