04/12/2014 - Creating a Filtered Portal with Find

03/30/2014 - Using a Toggling Button to Switch a Slide Panel

03/29/2014 - Using Slider Panels in FileMaker Pro 13

02/26/2014 - How to Change the Background image and Font Size in the OS X Notes app

11/02/2013 - Clearing Your Mac Mail’s Spam Folder with Keyboard Maestro

08/03/2013 - Creating a Budget database for FileMaker Go

06/09/2013 - Use an Applescript to Clear the Spam Folder

06/04/2013 - Working with Formatted Text in a PHP web application

02/10/2013 - Jailbreak your iPhone!

09/21/2012 - Bob’s Bookshelf - 09/21/2012

04/21/2012 - Longterm Solutions Announces FileMaker 12 Hosting

10/17/2011 - We’ve doubled our speed!

07/02/2011 - Bob’s Bookshelf - 07/02/2011

01/19/2011 - A Year on the Titanic

10/15/2010 - How to Skip Forward or Backwards in iTunes

09/06/2010 - Designing FileMaker Databases for FileMaker Go

07/31/2010 - Grey Matters

07/26/2010 - FileMaker Go Arrives!

07/25/2010 - The iPad Saga

07/03/2010 - What Do Clients Want?

04/24/2010 - Creating Script Templates Using ScriptBuildingBlocks

04/15/2010 - I Helped Launch the Titanic!

02/21/2010 - Oh, the Agony of a Bad Book

01/26/2010 - Use VOIP to Make Phone Calls From FileMaker

01/03/2010 - Bob’s Bookshelf - 01/03/2010

12/26/2009 - Dreaming of Sugar Plums and iSlates

11/18/2009 - Bob’s Bookshelf - 11/18/09

10/25/2009 - Ten Must-Have iPhone Apps... and More...

10/16/2009 - A Cool Case for Script Triggers

10/10/2009 - Independence Day - How to Get It Done

10/01/2009 - Spreading the Love for the Best Customer Service

09/17/2009 - Voice Over IP (VOIP): A Technology Whose Time Has Come

08/13/2009 - Programming at 36,000 Feet

08/11/2009 - FileMaker Pro Templating

07/19/2009 - Art versus Craft: Keep the Customer Satisfied?

06/22/2009 - FileMaker 10 Certification

04/24/2009 - Longterm Solutions LLC Announces NowPublisher for Music Publishers

03/15/2009 - How to Post to Twitter from a FileMaker Database

Use VOIP to Make Phone Calls From FileMaker

01/26/2010 - I’ve been using RingCentral VOIP for a few months now, and will probably never go back to a traditional landline again. The other day I started doing some research to find out how to make phone calls directly from a FileMaker database, using my RingCentral account. The solution was much simpler than I thought it would be.

Download the demo file here

Because RingCentral uses an API that is available to the curious customer, I was able to write a simple script that will allow a user to make a RingOut call from a database. The method is simple, and requires a single web viewer to do its work.

The RingOut API uses an HTTP GET to make the call; string requires a few pieces of information which are easy enough to provide:

Your RingCentral account number (your RC phone number)
Your RingCentral password (all digits)
The extension you want to use
The phone number you wish to call
(optional) the CallerID you wish to have displayed to the callee

As you’ll see in the “dial_out” script, I’m setting the web viewer (hidden under the Longterm Solutions logo) when the user clicks one of the phone icons. Each icon passes a script parameter, which is the phone number that we wish to call; using a script parameter, we can use the same script to make a call to any of the numbers in a user’s record.

The “dial_out” script switches to the LOG tab, then calls a 2nd script that creates a call log entry for the call, with a timestamp and the number you just called. You can type notes into the log entry by going to the LOG tab.

I stored the user settings (username, password, extension) in a separate table so that I could access them from any record in the Contacts table; using a cartesian join, where every record in one table relates to every table in another, I can always access the username, password and extension.

There are a few other RingCentral calls available, but this is the only one I found useful; hopefully they’ll one day allow us to retrieve other values, like call length, callerID, and perhaps even voice-mail. Stay tuned!