6 Replies Latest reply on Jan 4, 2015 10:22 AM by taylorsharpe

    SMS Integration

    louie23

      Anyone here have tried to integrate SMS in FileMaker? How did you integrate the SMS and what are the script? Thank you!

        • 1. Re: SMS Integration
          itraining

          Hi louie23

           

          Check out http://www.databuzz.com.au/products/fmsms/

          Not sure if Andrew is willing to part with his scripts but you could buy a working version (not sure if it unlocked).

           

          Michael Richards

           

           

           

          Brisbane (Australia)

          • 2. Re: SMS Integration
            eduncle

            We do this without plugins using a web based service from www.textmagic.com, although there are many similar services available.  We buy SMS credits from them in bulk, usually 1000 at a time but they offer different discounts based on quantity.

             

            In terms of integration, they (and quite a few SMS providers) have various options: -

             

            HTTPS API - using a FM Web Viewer object we can send a query to their servers eg:

             

            "https://www.textmagic.com/app/api?username=xxxx&password=yyyy&cmd=send&text=TheTextMessage&phone=441234567890"

             

            Obviously we use calculations to replace the message text and the telephone number and the page this generates in the web viewer can be queried for an acknowledgement.  There are also additional functions you can query which return credit balance etc.

             

            They also support email to sms (which we have found to be easier and faster).  We use the 'Send Email' script step with an address like "441234567890@textmagic.com" subject="<password>" messagebody="<the message to send>".  Using that method we can send the same message to 100's of recipients (we are a school emailing out to parents about trips and such) with a single script sending a single email with multiple recipients.

             

            HTH

            • 3. Re: SMS Integration
              jbante

              If you're in a position where you know the service provider for each number (such as for sending messages to employees on company-owned devices), you can use the provider-specific SMS gateways to send via email with the Send Mail script step without having to pay to use a more general gateway service.

              • 4. Re: SMS Integration
                leonovitch

                Hi,

                 

                I found a way to send record specific SMS's from FileMaker via an Applescript to Apple's Messages.app.

                However, it only works if the receiver is known in Messages.app.

                I still haven't found a way to send a SMS to "unknown" receivers.

                 

                Let me know if you're interested in what I found out so far (calculation fields, FMP script, Apple Script) for Apple users.

                • 5. Re: SMS Integration
                  rybadger

                  I've used Twilio for sms in Filemaker. It works well.

                  Check out this sample file: https://dl.dropboxusercontent.com/u/2817321/twillio%20test.fmp12

                  • 6. Re: SMS Integration
                    taylorsharpe

                    I originally was cheap and did text messaging via the various carriers email conversions.  And that worked, but then I had a client with a need for a serious gateway and sms capabilities and the ability to send pictures and receive pictures.  The picture thing is a big hurdle and basically we found out that doing so means you need one of the short numbers (e.g., 5 digit phone #) which all cost about $1000 a month.  In my opinion FMSMS and one of the gateways is the way to go, but depending on what you need, things can get expensive with the gateway.