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:
If 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.
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:
One 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.
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.
I got asked on the weekend about what do I use on the iPad to edit Microsoft documents.
I’ve been using an iPad (the ‘new iPad’ or the ‘iPad 3′ depending on who you talk to) and have been needing to both create and edit Microsoft Office Word and Excel documents.
I’ve tried using Google Apps but have found that it just wasn’t that easy, and I had to be online, which wasn’t a problem most of the time, but occasionally was quite frustrating if the connection was either slow or non-existent.
So I hunted around for a native app, and ended up with Quick Office HD, which is perhaps the most expensive app I’ve bought. However, it has proven to be very well spent money.
I’ve been able to open existing files, create new ones, save them to a Dropbox folder and either have them available on my workstation or laptop, or email a colleague a link to the file. This has proved to be a great combination (Quick Office HD and Dropbox).
As it so happens, Quick Office has been acquired by Google, so I’m hopeful that sometime in the near future a better option will exist for Google Doc’s.
This looks interesting: “Bootstrap is a toolkit from Twitter designed to kickstart development of webapps and sites.It includes base CSS and HTML for typography, forms, buttons, tables, grids, navigation, and more.” via Bootstrap, from Twitter, via Scripting News.