FileMaker tips, techniques, and news.

By Mason Stenquist  Posted on  March 3rd, 2020  in  FileMaker

Claris Connect Overview

Claris Connect, the latest product from Claris International, Inc., is a "no-code" platform that allows organizations to quickly connect multiple cloud services together like QuickBooks Online, Box, Gmail, etc. to build high-value business processes. It is the result of Claris' acquisition of Stamplay, an Italian startup that notably won a contest to make the best use of Visa's new APIs. Perhaps the best way to describe Claris Connect comes from Stamplay's cofounder Giuliano Iacobelli, who says it is "LEGO for APIs". In this article, we'll go over some of the "LEGO pieces" that will allow you to build advanced workflows bringing all your apps and data together.

In the following video, we create an advanced Flow that is integrated with FileMaker, FormStack, and Google Calendar (Coming Soon!) all in under 15 minutes.​

Services

Claris has been busy adding services to Claris Connect, and the number of services continues to grow. Connecting to all these services is usually as easy as logging in and authorizing access to the app. Claris Connect handles the rest. Below is a list of what what was available on day one:

Active Campaign Docparser Google Translate QuickBooks
Asana Docusign Mailchimp Slack
AWS Lambda Dropbox Mailgun Stripe
AWS SES Eventbrite Mailparser Trello
AWS SNS FileMaker Cloud MS SQL Server Twilio
AWS SQS FileMaker Server MySQL Server Twitter
Box Formstack Particle Typeform
Calendly Freshdesk Pipedrive Wufoo
Clearbit Google Maps PubNub Zendesk

For a current list of available applications and the functions available for each app, check out the Claris Connect App Directory.

Get in the Flow

Claris Connect works by building Flows. Flows are a way to create a common business process that might involve multiple different actions from separate services. Out of the box Claris Connect includes some prebuilt Flows to help get you started, or you can build your own. Some of the prebuilt Flows include adding attendees to a Mailchimp mailing list when they sign up for an event through EventBrite, or creating a new Zendesk ticket from a Typeform submission. Flows have access to the data of all previous actions making it easy to pass data from one step to the next.

Claris Connect - Get in the Flow

FileMaker

We are extremely excited by how easy it is to integrate Claris Connect with FileMaker. You can trigger a Flow via a FileMaker script step, by using insert from URL. Claris Connect also has a host of actions it can perform on a FileMaker file such as creating a record, editing a record, getting a record by id, deleting a record, performing a search, and executing a FileMaker script. Behind the scenes, Claris Connect is using the FileMaker Data API to do all this, so you need to make sure that you've enabled the fmrest extended privilege set in your FileMaker file.

Claris Connect - FileMakerUtilities

Often times when you are building out your flows, you'll need to format the data differently between services. For instance, FileMaker likes its dates to be formatted as MM/DD/YYYY, while most web-based services want dates formatted YYYY-MM-DD. Utilities allow you to format and manipulate data and other special use cases to help you accomplish your goals. Below is a brief overview of some of the utilities available to you.

Claris Connect - UtilitiesCalculations Utility

The Calculation Utility allows you to do simple math on any previous data. You can add, subtract, multiply, average, return a random number, or build out complex expressions that perform multiple calculations.

Dates Utility

The Dates Utility lets you add time to a date, subtract time, get the number of days between two dates, grab the current date, or format a date.

Documents Utility

The Documents Utility is more powerful than one might originally think. It allows you to extract text from a .pdf, .doc, .docx, .png, .jpg. It also allows you to translate data between the following formats; JSON to XML, JSON to CSV, XML to JSON and CSV to JSON.

Text Utility

The Text Utility is especially powerful. It allows you to format your data any way you want, and can help you extract info like URLs or email addresses, though you might need to learn a bit of Regular Expression to access the full power of this utility.

Pricing

Developer FileMaker Plus Essentials Standard
Pricing $19.99 per month $49.99 per month $99 per month $249 per month
Active Flows Unlimited Unlimited 15 Unlimited
API Calls 500/month 10k/month 10k/month 50k/month
Apps Unlimited Unlimited Unlimited Unlimited
FileMaker Apps Unlimited Unlimited Unlimited Unlimited
Collaboration Yes Yes Yes Yes
Update Time Real-time Real-time Real-time Real-time
SSO Yes Yes Yes Yes

Conclusion

Although Claris Connect and FileMaker are different products, it is easy to see why Claris acquired Stamplay: both share the goal of helping problem solvers transform workplaces by making them more efficient and effective. Claris Connect allows one to quickly and easily create business process workflows across multiple apps and services, without extensive time or coding knowledge.

Our consultants are ready to help you make the most of Claris Connect. Contact us today for assistance with Claris Connect!

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

Mason Stenquist thumbnail
Mason Stenquist

Mason is an experienced and Certified FileMaker developer motivated by creating innovative solutions for his clients. His interest and talent in the realm of art combine to form the foundation for his exceptional design skills, which helped him win the FileMaker Developer Cup at DevCon.

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