FileMaker tips, techniques, and news.

By Devin Drake  Posted on  November 20th, 2019  in  FileMaker, Free Downloads

FileMaker RingCentral Integration

Cloud-based communication and collaboration is taking ahold of businesses everywhere, from messaging apps such as Discord and Slack to VoIP services like Vonage and Intermedia Unite. RingCentral, voted PC Mag's Best Business VoIP Provider of 2019, has put itself in the forefront of cloud VOIP providers because of its intuitive interface and ability to integrate with other services. And with a simple webhook, you can add screen pop notifications to your FileMaker application when users receive calls from RingCentral.

Let's take at look at how to achieve this.

What Is Needed

  • RingCentral Developer account.
  • RingCentral Production ready app (With Read Accounts, Call Control, and Webhook Subscriptions permissions active).
  • A webhook file.
  • Your FileMaker solution hosted on a FileMaker Server.

How To Setup

RingCentral Developer account - If you already have a RingCentral account, you can log into the developer portal. If not, you can sign up for free developer account.

RingCentral Developer Portal RingCentral Production ready app - From the developer portal create a new app. You can create as many apps as you'd like, and as long as the app is not in production, you can edit them as much as you like from the app's settings. When creating an app you will also need to specify several items, these being; app name, app description, application type, platform type, and permissions. And to use screen pop notifications add the following permissions: Read Accounts, Call Control, and Webhook Subscriptions.

RingCentral App Settings Screen Now that your app has been created, you will need to get it approved for production, which you can track on the app's dashboard. Each app will have graduation requirements before you are able to apply for production. These requirements are:

  • 5+ API calls per each used endpoint
  • <5% of 400 errors
  • Exercise all requested permissions

To meet these requirements you can use your sandbox credentials in your FileMaker solutions to make the API calls or you can use RingCentral's API Reference.

Webhook file - This web script, such as a PHP or node script, is what connects RingCentral to FileMaker. When a user gets a call in RingCentral, RingCentral's API will pass that call's information to the webhook file, and the webhook file will in turn pass the information to your FileMaker solution using the Data API. The webhook file must be hosted on a web server and must be accessible over the web to RingCentral's API.

FileMaker Solution - In our FileMaker solution we will create a subscription to track telephony sessions using "/restapi/v1.0/account/~/telephony/sessions" as our event filter. To create this subscription we will need the RingCentral login of an admin user, the client secret, and client ID. For client ID and secret, there will be different values for sandbox and production. For testing, sandbox or production must be specified. When we create a subscription we have to specify a delivery mode address; this address is the URL to our webhook file.

FileMaker RingCentral Integration Subscription Setup Screen

Users will need to use their RingCentral credentials to get their extension IDs; this is what we will use to know which notification should go to which user.

And finally you will need to set up a notification table and a listener table in the FileMaker file. The FileMaker file will create a notification record every time the webhook receives information, and the listener table will link the notification to the user so it will show the correct notification.

How It All Works

  1. When a user logs into the FileMaker solution, the startup script finds the user in the user table and creates a listener record for them. FileMaker then opens a hidden window on the listener layout which has an onRecordLoad script trigger on it.
  2. When a user receives a call from RingCentral, RingCentral passes the call to the webhook file.
  3. The webhook file runs a script in the FileMaker solution to find the user via their extension and grabs their user ID. It will then find notification with the same information and if one does not exist it will create one.
  4. After the notification record is created the script will find the user's listener record and delete it, causing our onRecordLoad script to trigger.
  5. The OnRecordLoad then performs the screen pop by opening a new window and showing the call's information in front of the user.

Conclusion

With a simple webhook, you can integrate your FileMaker solution with RingCentral, providing screen pops, dialing out functionality, and much more. Contact us today if you would like help integrating your FileMaker solution with RingCentral!

Did you know we are an authorized reseller for FileMaker Licensing?
Contact us to discuss upgrading your FileMaker software.

Download
Download the FileMaker RingCentral Integration File
Please complete the form below to download your FREE FileMaker file.
FileMaker Experience *
Terms of Use *
OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This file is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free file, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime.
Devin Drake thumbnail
Devin Drake

Devin is a certified FileMaker and web developer who is outgoing, easily approachable, and places a high value on collaboration and supporting others.

FileMaker 18 Certified Developer
FileMaker 17 Certified Developer
FileMaker 16 Certified Developer
FileMaker 15 Certified Developer
FileMaker 14 Certified Developer
FileMaker 13 Certified Developer
FileMaker 12 Certified Developer
FileMaker 11 Certified Developer
"We were actually able to add more features than we thought would be possible within our budget. We always experienced a ‘can do’ attitude and DB Services was incredibly patient and easy to work with."
Courtney Hartman
Art Director
"The new FileMaker custom website interface is very user-friendly and easy to follow for our clients. In addition, it is much faster than the old Instant Web Publishing (IWP) interface. Thank you and all the others who have helped us out at DB Services. I am very grateful for the excellent service you provide us. Its nice to know we can call you for help if we have an issue."
Wayne Capek
President
"We needed a solution that would simplify the administration of our responsibilities under our contract with the State of Indiana. We have seen a dramatic increase across the state in the number of potential foster and adoptive parents that have begun the preparation and training process. This increase has resulted in a significant opportunity for children available for adoption. That’s a big win for everyone! And it’s all because we can refer potential parents to the proper state contacts efficiently and quickly."
Chris Morrison
Executive Director
"Thank you for all of your expertise and valuable help. I am so grateful to have found DB Services."
Linda Findlay
Owner
"Thank you for our new database system. We transitioned from a carbon copy paper based system to a digital database. The software has saved us time and money. We used to archive all our jobs in cabinets, now we can look up a job in seconds from anywhere. The software allows us to easily email estimates to our customers in pdf format. In a year there was a return on investment just from eliminating the purchasing of our carbon forms."
Todd Cartmel
Owner
"The new system allows us to create and track jobs for customers along with inventory, something we had been doing with separate word and spreadsheet files. Because it’s now so intuitive, new staff members are able to begin using the database immediately without our usual training session and ‘cheat sheets’ for getting around within the file."
Tom Andrews
President