Formula
From the Resources Tab create:
OR( AND( ISBLANK({!$Record.Mogli_SMS__Mogli_Number__c}), OR( NOT(ISBLANK({!$Record.MobilePhone})), NOT(ISBLANK({!$Record.Phone})) ) ), ISCHANGED({!$Record.MobilePhone}), ISCHANGED({!$Record.Phone}) ) |
|---|
From the Resources Tab create: Formula > Text Variable (United States Number Only - See International Section for International Number instructions)
IF(ISBLANK(TRIM({!$Record.MobilePhone})),"", IF(REGEX(TRIM({!$Record.MobilePhone}),"[\\s\\S\\w\\W]*[a-zA-Z@#$%^&*<>!?\\[\\]_{};:'/~`]+[\\s\\S\\w\\W]*"),"", "+1" & SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE(("+"& TRIM({!$Record.MobilePhone})),"++1",""),"+1",""),"+",""),"(",""),")","")," ",""),"-",""),",",""),".",""))) |
|---|
IF(ISBLANK(TRIM({!$Record.Phone})),"", IF(REGEX(TRIM({!$Record.Phone}),"[\\s\\S\\w\\W]*[a-zA-Z@#$%^&*<>!?\\[\\]_{};:'/~`]+[\\s\\S\\w\\W]*"),"", "+1" & SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE(("+"& TRIM({!$Record.Phone})),"++1",""),"+1",""),"+",""),"(",""),")","")," ",""),"-",""),",",""),".",""))) |
|---|