Field validation?

[lmoreau]

Sorry for all my questions just signed up for Sugar today, bye bye Salesforce!

In Salesforce you can easily have validation on fields, so for example, we have a sales rep ID number that's a text field. It looks like BJD3743, CHD9228 etc. It's 3 letters and then 4 numbers. In SF I can have it only allow entries that match that.

Same with province, only a 2 letter province/state from a list of valid state and provinces are accepted. Is there any way to do this in Sugar? Can't seem to figure it out.

[Angel]

This requires some custom programming.

The closest you could come to it without programming would be to use the "required" option on a field, but that's exactly what you are looking for. Its benefit is that it would automatically validate the data based on the type of field, i.e. integer fields would only allow numbers, but it wouldn't allow you do define your own rules, while also requiring that the field be populated, which might complicate things further for you. The benefits of its use may be very minimal, if any.

[rafael.q.g@hotmail.com]

Yes, the deafult dugar validation is just to check wheter a certain field is empty or not.
Any "custom" validation needed to be programmed. It could be done with javascript (called before form's submit) or with php (called in sugar before_save logic_hook)

[lmoreau]

Got it thanks everyone. It's not really critical or necessary it was just nice to have. I guess for province/state I could make it max size 2, which would keep it at least in the 2 character format.

[Angel]

You could also make it a drop down field as it would require the users to pick a value from a predefined list, as opposed to them being allowed to type random values.

Also note that address fields are handled in a special manner by Sugar. In a nutshell, you can't modify existing address fields individually without some custom programming, that includes replacing an existing field with a custom. For example, replacing the existing state field with one of your own.

Of course, that's only of relevance if you want your field to be part of the default address block.

[srishti.kumari@accenture.com]

Only way to add validation to a custom field is via javascript ? We can not have any validation through configuration ?