CiviCRM Stack Exchange is a question and answer site for administrators and users of the CiviCRM Constituent Relationship Management software. It only takes a minute to sign up.
Sign up to join this community
I know the documentation says you should leave it the same, but suppose I know I want the text field to be only 3 characters every time?
I can set it fine in custom fields, but when I go to enter data, and a user mistakenly puts in more than 3 characters, it throws a database error. Is there somewhere else besides the custom field specification where I can set up CiviCRM to validate user input?
(note: this can be reproduced on the civicrm demo server)
being able to set a length make sense. As you describe, you might want to have the length limited, because it's a zip code, a country code, a whatever you know has a fixed length.
The problem is not on the database definition, but on the user interface, that should prevent being able to put more chars that the field can accept.
Where do you experience the problem? is this in the back-office or using profiles?
Would be awesome if you could correct civicrm core to the check is done at the interface level (don't make the field longer than what the database can store) instead of the ugly error triggered by the database.
(You might want to check on the next version of civi see if you're lucky and that has already been fixed)
X+
