2013-10-30 Open loops


Off-topic, well, on topic, or both maybe: I’m finding it useful to write these ‘open loops’ as it’s just a bunch of links that I want to come back to, without losing them. Quite frankly it’s easier to find them here on my blog than anywhere else. I am the intended reader of these posts, but do let me know if your find them useful at all.

photo credit: MOLLYBLOCK via photopin cc

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:


small_4956707000If you use a Decimal field type you can remove the floor() portion of the formula so that it doesn’t round it down. This means you will see just how old they are to a decimal point. Personally I tend to prefer just knowing that they are 21 or 42 rather than 21.45 or 42.01.

photo credit: Fouquier ॐ via photopin cc

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:


However today I need to make this particular field visible if the field it is dependant on is one of a few values. Thusly a different ‘dependant formula is required:


Hat tip to Anton in Sugar Support for pointing to the ‘isInList()‘ instead of trying to build something with nested ifElse()’s.

What I miss from iOS and how simple it was to fix it

thumbn_9080100066One of the ‘little’ things on iOS that I truly have come to love is this: when you type ‘two spaces’, it auto replaces that with a ‘period and a space’. For example ‘  ‘ becomes ‘. ‘

This is especially useful on iOS devices because to get to the period (aka full stop) you need to change which keyboard you’re viewing, and this little, helpful item means it is so much quicker to type a message or email on iOS. Love it.

But I miss it on my newly acquired Mac. I find that I’m often double tapping the space bar, expecting it to transform into ‘. ‘ – but it doesn’t.

Well, no longer, using TextExpander, I’ve created a new Group, whose snippets only expand in specified applications, at this point only in OmniOutliner as that is where I do most of my writing. My first snippet in this group is triggered by a double space and, yes, you guessed it, transforms into by beloved ‘. ‘

Already my typing feels smoother. :)

Update 2013-10-30: I’ve since expanded this ‘expansion’ to occur in a number of other apps, Outlook, Mail, Word to name the main ones.

photo credit: Robert S. Donovan via photopin cc

Mac OS X Keyboard Shortcuts

As a recent convert to the Mac OS X platform (I bought a Mac Book Pro), I’m loving OmniOutliner for creating outlines and documents, with one small annoyance. The default keyboard shortcut isn’t easy enough for me to use to move items up and down the outline list.

So when I found this article Alternative Options and Shorter Shortcuts I saw that using the same method I’d be able to ‘re-map’ ⌘↑ and ⌘↓ to move items up and down the list. And it’s worked. ☺