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 it will display “EXPIRED” regardless of if the date is in the past or future.

The workaround for this bug (thanks Anthony) is to wrap the date field in a date(toString($datefield)) bit of code, this transform the original sugar logic into this:

ifElse(isBefore(today(),date(toString($bluecard_expiry_c))),"Current","EXPIRED")

It is essentially force-casting the field to a date field for the javascript-side while passing the formula validator in Studio by first casting the date-type field to a string type.

Which works a treat.

Activate IFTTT SMS Channel on Optus in Australia

How to activate the SMS channel on IFTTT on the Optus network in Australia.

Assuming your mobile number was 0410 123 456.

Drop the leading zero = 410 123 456.
Add the Australian country code 61 to the front = 61 410 123 456.
Add 00 to the front of the number 00 61 410 123 456.
Remove all the spaces = 0061410123456.

Use this number (0061410123456) to active the SMS channel on IFTTT.

Hat tip to @Trail_929 for the pointer.

If this works for you on other networks in Australia, please let me know.

Update 2014-05-12 : I’ve had a few people on Optus Post Paid that haven’t been able to get this to work. It’s worth noting that IFTTT also now has both iOS and Android notification channels available, they may do the trick for you.

Update 2015-04-22 : Alex Townsend says he has it working on Vodafone.

Update 2015-11-02 : Marissa Roberts has confirmed it’s still working today.

Screenshot & screencasts on Mac OSX

Back when I worked exclusively on a Windows machine, I loved using Screenpresso for the ease with which it allowed me to do screenshots and screencasts (if you’re still stuck on Windows, go buy it, it’s worth it).

But now that I’m on a Mac, what to do?

So to start with just press SHIFTCMD4 and you can take a screen shot. It’s a native Mac thing.

If you have Dropbox installed go to Preferences | Import and tick the Share screenshots using Dropbox option.

If you want to do screencasts, then fire up QuickTime Player (CMDSPACE | Quicktime ↩) then press CTRLCMDN to start video recording.

That’s how easy it is on a Mac.

How to get Google Chrome to open your pages from your last session

I use Google Chrome as my primary browser on the MacBook.

Although I only restart the machine every few weeks I like it to re-open the same tabs that were open last.

To do this, in Google Chrome type chrome://settings/ into the address bar and press enter.

This loads the Settings page. Then check the Continue where I left off setting. Close the tab. You’re done. :)

Google Chrome On Startup Continue Where I Left Off

Sharing a host folder with a guest Virtual Machine

I’m using VMware Fusion on my MacBook. At times I have either files on the local host (the MacBook) that I want to edit or installers that I want to run on the guest (the virtual machine).

With your virtual machine running, click on the Settings icon, select Sharing | Shared Folders ON | tick Downloads.

Your local “Downloads” folder will now be available to your virtual machine.

VMware Fusion Settings | Sharing

SharedFolders On