Ben Hamilton

Sugar Logic bug with a workaround for date fields

A client is recording the expiry dates of staff blue cards in their SugarCRM database. So I used the following sugar logic to show if the blue card has expired or not: ifElse(isBefore(today(),$bluecard_expiry_c),”Current”,”EXPIRED”) However, the problem here is that when a user of SugarCRM is editing the record, there is a known bug that means […]

Posted in How to, SugarCRM | Tagged , , | Comments Off on Sugar Logic bug with a workaround for date fields

Remove thousand separator in Integers in SugarCRM

We want to record a ‘Year’ value on a record in SugarCRM, but we don’t have a day and month to do with it, you can’t use a field that is of a ‘date’ type as that requires a full date (year, month, day). You can use an ‘Integer’ field type tho. The downside is […]

Posted in How to | Tagged , , | Comments Off on Remove thousand separator in Integers in SugarCRM