Saturday, March 10, 2018

Are your custom fields out of control?

FieldManager 1.0 for MySQL

Every SugarCRM installation I have ever worked on has had the same problem.  Custom fields that are out of control.  There are several problems with Studio when it comes to custom fields.  It really doesnt tailor the field to the data it will contain.
  1. The size option for VARCHARs defaults to 255, for dropdowns it's 100 even though we know the exact size of the data that will fill it.  
  2. It doesnt allow for CHARS.  
  3. Fields that are filled from formulas should have the option to be non-db fields as they are usuaally for display only.  
  4. Too many people use TEXT when a VARCHAR would work fine.  
  5. Fields are created and then never used or fields are abandoned in favor of something new.
  6. Fields are created and then are used for a datatype they are not intended for like using a VARCHAR to hold a date or numeric.
  7. Fields are added and then so rarely used it begs for a redesign.  Maybe there is a checkbox that has never been checked or a dropdown that everyone lets default.