Monthly Archives: January 2014

Working out percentages in a Mysql query for reporting tool zuckerreports

Although not strictly Sugarcrm related I had requirement the needed me to work out the percentage of opportunities which had the sale_stage field set to ‘Closed Lost’ and ‘Closed Won’. This would be displayed as part of sugar via Zuckerreports,

Posted in General Programming

Logging custom error messages in SugarCRM

Depending on what your Log Level is set to in the system settings you can log errors to the sugarcrm.log located in the root folder with the following code snippets

Posted in SugarCRM development development hints and tips

Redirect with a custom error message in SugarCRM

If your looking to redirect with a custom error message in Sugarcrm the following code snippet shows you how to do it. This could be used within a controller action for example if a certain condition is not met then

Posted in SugarCRM development development hints and tips

Adding custom JavaScript to a view in SugarCRM

If you need to add custom JavaScript to a view in SugarCRM the first thing you need to do is create your script file and place it in the custom folder of the module you want to add the client

Posted in SugarCRM development development hints and tips

How to add custom validation to form fields in SugarCRM CE and SuiteCRM

I had a requirement to add custom form validation to a couple of custom fields in the meetings module.  The requirement was as follows: When a Meeting is marked as ‘Held’ the Objective Result and Follow Up fields will be

Posted in SugarCRM development and customisation, Uncategorised