Here’s a quick fix if you have an Excel spreadsheet that has a field that combines the city, state, and zip in one field. Three calculations will easily extract the information and place them into individual fields allowing you to easily import them into FileMaker. The combined field is present in B2 and the formula [...]
Las Vegas—July 18, 2016—The Scarpetta GroupTM, Inc. announced today that they would be releasing an update to Jarvis CRM to V3, a full-featured business solution. Jarvis is a full-featured business solution for desktop, mobile and web. Built on the FileMaker 15 platform, it runs on Windows, Mac, iOS, and in a web browser. Jarvis was [...]
Occasionally, in development, I find that I need to provide some sort of user feedback regarding the completion of a script or to display information to the user and sometimes a custom dialog is not the best solution. And, me just being me, I want to do it in a very useful, efficient and [...]
FileMaker provides us with many great tools for reporting purposes. One of these tools is charting capabilities. FileMaker's built in charting can be very useful for displaying a variety of analytics, but sometimes you run across a situation where you need just a bit more than what FileMaker offers. This is where using jQuery in [...]
In part 3 of this series I am going to showcase a user submitted solution from Stephan Bansemer who works with Attend GmbH in Hamburg and is a freelance FileMaker developer. Stephan read the previous blogs in this series and decided to take on one more level of jQuery fun in FileMaker by implementing [...]
Part 2 of the series on using jQuery UI in FileMaker. In this tutorial, I am going to explore using the jQuery UI slider control in FileMaker to set a value on a predetermined scale. I will be using FileMaker's data URL functionality and sending data back to FileMaker using the FMPURL method. For those [...]
This will be a multi-part series detailing many various jQuery integrations in FileMaker. In this tutorial, we are going to explore using jQuery and jQuery UI libraries in FileMaker natively without requiring a web server or an Internet connection. This is made possible by using FileMaker's data URL functionality. For those of you who [...]
Most developers are familiar with the built in Google mapping features within FileMaker Pro. However, with FileMaker Pro 13 bringing HTTP POST methods natively into the game, there's much more we can do by leveraging the Google maps APIs in FileMaker. So what can we do with FIleMaker 13 Google maps? In this article, [...]
In FileMaker, showing distinct values in a portal can be accomplished in various ways. In this tutorial, I show how to do this using a self-relationship combined with a portal filter using the GetNthRecord ( field name ; recordnumber ) calculation function. An example of this technique being useful is when you want to list [...]
We work on a lot of custom web applications for FileMaker solutions varying from custom CMS functionality to third-party API integrations. Recently, I worked on a project that required building an efficient way to manage an ever-changing web navigation system. I put together some nifty recursive PHP functions to handle most of the grunt [...]