Ben Hamilton

2013-11-04 Link Roundup

A great metaphor, using cups of water, that explains Google, Apple, Microsoft, Amazon and the dance between them. There is no private cloud, no public cloud, just hybrid, and 68% of customers will change vendor. Good explanation of a ‘partitioned’ approach and an ‘iterative’ approach  using dice to help explain the concepts. Read this to understand how to […]

Posted in General, SugarCRM | Tagged , , | Comments Off on 2013-11-04 Link Roundup

SugarCRM how to calculate a persons age

In SugarCRM we oft record a persons birth date (in the field birthdate). Sometimes it’s useful to know how old this person is. So we create a new field age_c (note: this can be of field type Integer or Decimal) and then using this formula we can see how old they are: floor(divide(subtract(daysUntil(today()),daysUntil($birthdate)),365.242)) If you use […]

Posted in How to, SugarCRM | Tagged , | Comments Off on SugarCRM how to calculate a persons age

SugarCRM field visibility dependant on multiple values

I’ve often got cause to make fields in SugarCRM (Professional and Corporate editions) to only appear based on the value of another field. We can do this easily using SugarLogic in Studio using this ‘dependant’ formula: equal($fieldname_c,”value_1″) However today I need to make this particular field visible if the field it is dependant on is one […]

Posted in How to, SugarCRM | Tagged , | Comments Off on SugarCRM field visibility dependant on multiple values

Resolution of SugarCRM Not Sending Notifications

One of my clients had their SugarCRM notifications stop working. After a lot of testing, it turns out that if I set the FROM name to be the same as the FROM address it started working again.

Posted in SugarCRM | Tagged , | Comments Off on Resolution of SugarCRM Not Sending Notifications

Importing Data Into SugarCRM

Working with SugarCRM (Pro, OnDemand) last week and discovered a wonderful thing! SugarCRM has been designed to import record ID numbers from other systems. So long as the id numbers you’re importing are less than 36 characters, and are globally unique (not just unique to the entity, i.e. contacts, notes, accounts) you’re in business, you can […]

Posted in General | Tagged , | Comments Off on Importing Data Into SugarCRM

Getting ifttt to add to RTM

If that headline made sense to you, then you’re in the right place :) The problem I had is that ifttt doesn’t by default integrate with RTM. So I’ve come up with a way that creates a new RTM task for me whenever there is a new item in a particular RSS feed. We create […]

Posted in Productivity | Tagged , , , , | Comments Off on Getting ifttt to add to RTM