The CicoNET's blog
I decided to start publishing, sometimes, some of my developing experiences with SugarCRM CE (6.5) and SuiteCRM, with the PHP language, in building App iOs (iPhone or iPad) and Android, with the Java language and everything I think that could be interesting to share... I began with an interesting discover with SugarCRM CE 6.5 or SuiteCRM.
In SugarCRM CE 6.5 or in SuiteCRM, the way fields are displayed in SubPanels, follows more or less the same rules as displaying them in ListView, but sometimes it's useful to be able to see certain fields in a unique, non-standard way.
In this article, I'll show you how to create a completely customizable display of any field in a SubPanel.
How to create a custom view of type Edit in SugarCRM CE 6.5 or SuiteCRM
In SugarCRM CE 6.5 or in SuiteCRM there is the standard EditView mask that allows you to insert/modify an object of a specific module, there is also the QuickCreate that can be used to quickly insert an object.
These two masks are standard and easy to manage with Studio.
Sometimes, however, it can be useful to create a custom view of type Edit to manage personalized insert/modify to be used in specific cases.
How to increase the size of a TextArea field in SugarCRM CE 6.5 or SuiteCRM
In SugarCRM CE 6.5 or in SuiteCRM the TextArea type fields are automatically created on databases as TEXT fields, that is multi-line text fields that can store up to 65,535 bytes (64 Kb.).
Sometimes however, you need a larger number of bytes, for example to store an XML or a JSON or for larger literary texts, or for texts written in languages that use many MultiByte characters, such as the Arabic or Chinese (in general, in a UTF-8 text, each character uses a number of bytes between 1 and 4).
I found a simple Upgrade-Safe method to transform TextArea fields into larger fields, such as LONGTEXT, which can store up to 4,294,967,295 bytes (4 Gb.).
Predefined searches in SugarCRM CE 6.5 or SuiteCRM
In SugarCRM CE 6.5 or in SuiteCRM each user can create, on each module, some saved search filters to be reused many times in the ListView, moreover the system "remember" the last search done in a particolar module.
Very often, however, customers request some predefined search filters to be defined for all users, or users of a given role, to find them ready in the modules they work on most frequently, or that some module "always starts" with a specific pre-set search.
I found an interesting article by Chad Hutchins that put me on the right track to do both of these things.
How-to add any field to Mass Update in SugarCRM CE 6.5 or SuiteCRM
By default, SugarCRM CE 6.5 (and also SuiteCRM) allow to Mass Update only fields of Data Types:
- Checkbox
- Datetime
- Date
- DropDown
- Dynamic DropDown
- Integer
- Multiple Selection
- Radio
However I found an Upgrade-Safe method to add any field to Mass Update.