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

    Odd behavior when sending SMS text message from FMP13?

    DEC

      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:

       

      http://www.youtube.com/watch?v=f5oaDpggrHI

       

      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.

       

      -D

       

      photo.PNG

       

       

       

       

      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 [ ]

       

      Else


      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 );

       

      Message:

      "______________________" & ¶ & ¶ &
      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” ]


      Else


      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?
          taylorsharpe

          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.