About Scarpetta Group

This author has not yet filled in any details.
So far Scarpetta Group has created 17 blog entries.

Separating Info in Excel Combined Fields

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 [...]

2016-11-01T17:01:16+00:00 By |

Jarvis CRM V3: A New Way to Think about CRM

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 [...]

2016-11-01T17:01:16+00:00 By |

Using jQuery in FileMaker – Part 4

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 [...]

2017-01-02T20:01:08+00:00 By |

Using jQuery UI in FileMaker – Part 3

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 [...]

2017-02-08T11:12:42+00:00 By |

Using jQuery UI in FileMaker – Part 2

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 [...]

2017-02-08T11:15:22+00:00 By |

Using jQuery UI in FileMaker – Part 1

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 [...]

2017-02-08T11:16:37+00:00 By |

FileMaker 13 Google Maps API Geocode

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, [...]

2017-02-08T11:17:37+00:00 By |

FileMaker Portal Show Distinct Value Tutorial

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 [...]

2016-11-01T17:01:18+00:00 By |

FileMaker PHP Custom Web Menus Tutorial

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 [...]

2017-02-08T11:19:46+00:00 By |