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.