AnsweredAssumed Answered

Odd behavior when sending SMS text message from FMP13?

Question asked by DEC on Sep 14, 2014
Latest reply on Sep 14, 2014 by taylorsharpe

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

 

Outcomes