In this post, we will talk about how to send and receive rich text messages from FileMaker with Twilio using PHP code.

Sending and Receiving SMS in FileMaker Through Twilio

Here is the simple five-step process involving Twilio and FileMaker for dealing with SMS.

Step 1

The first step, of course, is to create a Twilio account. The Twilio service allows software developers to programmatically make and receive send and receive text messages using its web service APIs. You’ll need your “Account SID” and “Auth Token,” both available on the Twilio Dashboard.

Step 2

In a FileMaker script, create a new record set the following local values with empty flag value:
$sms_accountID = Twilio AccountSID
$sms_token = Twilio Auth Token
$from = Your Twilio phone number
$mobile_number = The destination mobile number
$message = Whatever you want the message to say

Step 3

PHP Code will find the empty flag value records and perform the loop to send an SMS via Twilio with reply URL and populated the “Sent” value in flag field. Please see the message sample:

Step 4

The user will read the message and reply to the particular message by clicking the Reply link. PHP code will store the message content in FileMaker Db as a new record. Then we can view in FileMaker layout.

Please see the screenshot below:

Step 5

We can view the all message list in FileMaker with two level search option and count of message send and received.

FMDBSolutions: We Know FileMaker

If you want solutions to your FileMaker database, we can help. Click the below box for a free FileMaker consultation

You can also leave us your email below for receiving new updates regarding FileMaker and our company.