1 Reply Latest reply on Sep 14, 2014 3:07 PM by taylorsharpe

    Odd behavior when sending SMS text message from FMP13?


      Hi Everybody,


      I'm using this method in a database to enable the users (secretaries of a corporation) to send SMS text messages to send text messages to their company supervisors from Filemaker:




      It works great, except that the time field in the text message (which is included as part of the script either formats funny when the SMS is received, or doesn't appear at all (see below screenshot of an SMS text received via the Filemaker script).


      The same script works fine if the notification is sent as an email to the user's email address. There's something about the email traveling through SMS that screws it up.


      I looked into this link, which advises how to format times in a text calc, and it gets the hour correct, but the minutes (and seconds) drop off: http://help.filemaker.com/app/answers/detail/a_id/5746/~/formatting-times-in-a-text-calculation


      Any thoughts? The script is below for your review.









      Send Call Record to Exec via SMS


      Allow User Abort [ Off ]

      Set Error Capture [ On ]

      If [ IsEmpty ( Executives::d_ExecMobile ) or IsEmpty ( Executives::d_ExecCarrier ) ]

      Show Custom Dialog [ Message: "The mobile number and/or mobile carrier aren't specified for this Exec. Go to the Exec record and include this information, then try again. "; Default Button: “OK”, Commit: “Yes” ]

      Halt Script

      Exit Script [ ]



      Send Mail [ Send via E-mail Client;


      To: Case (

      Executives::d_ExecCarrier = "AT&T" ; Executives::d_ExecMobile & "@txt.att.net" ;

      Executives::d_ExecCarrier = "Sprint" ;

      Executives::d_ExecMobile & "@messaging.sprintpcs.com" ;

      Executives::d_ExecCarrier = "T-Mobile" ; Executives::d_ExecMobile & "@tmomail.net" ;

      Executives::d_ExecCarrier = "Verizon" ;

      Executives::d_ExecMobile & "@vtext.com");


      Subject: TextStyleAdd ( GlobalSettings

      For Emailing Calls::CompanyName ; Uppercase ) & TextStyleAdd ( "Call Record" ; Uppercase );



      "______________________" & ¶ & ¶ &
      TextStyleAdd ( "Call Status: "; Bold ) & Calls_Refresh::Data_CallStatus & ¶ & ¶ &
      TextStyleAdd ( "Caller Info: "; Bold ) & Calls_Refresh::Data_CallerInfo & ¶ & ¶ &
      TextStyleAdd ( "Message: "; Bold ) & Calls_Refresh::Data_Message & ¶ & ¶ &
      TextStyleAdd ( "Date: "; Bold ) & Calls_Refresh::Data_CallDate &¶ & ¶ &
      TextStyleAdd ( "Time: "; Bold ) & If(Hour(Calls_Refresh::Data_CallTime) > 12; GetAsText(Calls_Refresh::Data_CallTime - Time(12; 0; 0)) & " pm."; GetAsText(Calls_Refresh::Data_CallTime) & " am.") ] ***NOTE FROM D: If I simply show the Time field here, it comes through SMS all funky. With this line (derived from the above referenced time formatting URL guidelines, the time doesn't show up at all.
      [ No dialog ]

      If [ Get ( LastError ) 0 ]

      Show Custom Dialog [ Message: "An unknown error has occurred. Please contact the system administrator."; Default Button: “OK”, Commit: “Yes” ]


      Show Custom Dialog
      [ Message: "The Call Record has been sent via SMS to " & Executives::d_ExecName & "'s cell

      phone."; Default Button: “OK”, Commit: “Yes” ]

      End If


      End If


        • 1. Re: Odd behavior when sending SMS text message from FMP13?

          It has to do with FileMaker's character set (UTF8) used in their mail program.  Not sure why they did it that way, but the easily solution is to use one of the many 3rd party email plugins and none of them have the problem that the FileMaker email function has.  I personally use the CNS SMTPit and it works well, but there are a number of other good ones.  All of the 3rd party ones I've tried avoid this character set problem that FileMaker has.