We want to create 40-50 custom fields in the opportunity and case module. Is there any issue to have this?
There will be no issues with having the custom fields in Sugar.
An admin user can create as many custom fields as they want using Studio in Sugar.
But please follow some best practices like limiting the max length of text fields as per the field data. By Default max size of the text field is 255. But you can reduce based on the field data you are storing. This is good to follow because if you are using Mysql. it has maximum row size limit.
Hope this information is helpful :)
You won't have any issue doing it, you may have an issue getting your users to fill that many fields though...
Too often I've seen management wanting all these metrics and requesting a whole lot of fields be added but then it all becomes too cumbersome for the user and no one takes the time to fill them. Just something to think about. Personally, I would question the business need for so many fields.
isn't the 'theoretical limit' 4,096 columns, as long as the row size limit isn't exceeded?
Would be great if somehow we could see the current row size for each module within Studio
CRM Business Consultant
A good limit from practice are 200 fields. But as Francesca wrote already it can be really boring for users to fill out all these fields. I had a project where somebody wanted to calculate most of these fields in Sugar Logic, that was an application killer as the page did not react any more.
Principal Solution Architect – Professional Services, EMEA
SugarCRM Deutschland GmbH