Jump to content


Integrating FileMaker’s Data API and Ruby with the fmrest-ruby gem

We often work on projects that intersect two technologies near and dear to us: FileMaker and Ruby. This allows us to build robust web applications in Ruby on Rails, integrated with data sources from FileMaker solutions. When Claris introduced the FileMaker Data API we were naturally curious to try it out. At the time there […] Afficher la totalité du billet



Understanding External Authentication

Even if it's not a super interesting topic, and really only applies if you're managing a FileMaker server, it always pays to know how things work behind the scenes. If you've never used FileMaker's external authentication via LDAP then you'll want to watch this particular video. If you're creating any type of FileMaker solution which needs to know when your users both enter and exit the system, which especially applies to using external authentication, then you'll enjoy the super simple access

Why Claris FileMaker?

Let me preface this first by saying, I’m not from a technical background. I was in education management for over 15 years and did a lot of work with improving business efficiencies and reducing/eliminating redundancies and I recently changed my career path into pursuing FileMaker Development. Throughout this transition, I commonly hear the question, [...] The post Why Claris FileMaker? appeared first on The Scarpetta Group, Inc.. Afficher la totalité du billet

Migrating Themes

Recently, having had a conversation with a fellow developer about a FileMaker theme potentially causing issues with slow performance, it was asked about how it's possible to update a theme. Whether you simply want to update existing styles and/or remove and add others, there's only a few critical things you need to remember about updating and migrating a theme. If you can get those few things right, then making any number of updates to your existing theme can be quite easy to accomplish. The g

FRAP-Map: A Flexible, Robust, Accessible and Portable Data Mapping Technique

Editor’s note: today we have a guest article by long-time FileMaker developer, Peter Doern, who has come up with an elegant, outside-the-box methodology for managing imports. This is one of the coolest techniques I’ve seen in a long time. Enjoy. FileMaker includes a powerful and fast method for importing data from a source table to… Continue reading FRAP-Map: A Flexible, Robust, Accessible and Portable Data Mapping Technique Afficher la totalité du billet

IU-DATA Add-on : iOS Switch v1

Voici un des premiers add-ons que j'ai créé et que j'utilise régulièrement dans les solutions que nous développons pour nos clients. C'est un sélecteur à 2 positions basés sur celui que l'on peut retrouver sur différentes interfaces d'iOS ou sous différentes formes dans un grand nombre d'applications et de sites webs ! ( et même sur cette page 😉 ) Contenu dans un web viewer, HTML et CSS permettent de lui donner des fonctionnalités impossible à obtenir correctement avec les objets nati

Reporting in FileMaker: How to Make Subsummary Parts Work Hard!

Are you creating a FileMaker Pro subsummary report? A subsummary layout part is used to sort a set of records into groups based on the values contained in a break field. Typically, you can only create one subsummary part per field on a layout. But what if you need both a leading and trailing subsummary part for the same field on a single report? Well, you can do it, given a little creativity! Use case Let me explain the situation first. I was working on designing a report for a client fo

OData for FileMaker – New Player in an Old Game

This blog post is the first in a three-part series about the FileMaker OData API, highlighting key features that make it an exciting addition to the Claris FileMaker platform. Part 1: An Introduction to FileMaker OData I had the opportunity and pleasure to take a one-week dive into the FileMaker OData API. The objective was […] Afficher la totalité du billet



Create a powerful layout design in FileMaker

Typically, portals in FileMaker are used for showing related data. However, a portal based on the same table as its layout would simply display the current found set. If you made the portal large enough, the layout would appear as a list view- which wouldn’t be very helpful. So, in this blog, we will make the portal smaller and create a powerful layout design, the Master Detail portal. If data requires or if users request […] The post Create a powerful layout design in FileMaker first appeared



Customized PDF Output

FileMaker has had the ability to use an internal PDF writer since version 8. It has, however, not always had the ability to merge multiple PDFs into one master and make this work as seamlessly as possible. Being able to do this server side is a really BIG benefit! In this video, we take a look at a subscriber's question about a particular printed layout issue in conjunction with taking advantage of FileMaker's best possible output options. With the ability to Save Records As PDF we can certainl

IU-DATA, nouveau site, des articles et des add-ons !

Grande nouvelle pour nous, IU-DATA intègre le Marketplace de Claris afin de proposer de manière régulière différents add-ons ou produits permettant d'ajouter des fonctionnalités aussi uniques qu'intéressantes à vos solutions FileMaker. Un moyen pour moi de vraiment m'amuser en recherche et développement je dois le dire ! C'était aussi l'occasion pour nous de refondre totalement notre site Internet afin d'y proposer de nouveaux services. D'un côté nous partagerons avec vous des articles auto

Successful UI Design - Part 2

FileMaker themes are simply a collection of the popular CSS standards plus a few extra attributes which are FileMaker specific. Each element on your FileMaker layouts is defined by these CSS settings. They can be seen when extracting them from the clipboard, and if you know the right location to retrieve and store them, can be defined by any enthusiastic developer. When FileMaker, now Claris, first introduced themes they likely had the intention of allowing users and/or third parties to create

When 2 is greater than 10

Today we’re going to take a quick look at a potential “gotcha” that can crop up when doing numeric comparisons. Jason DeLooze and I discussed the general behavior back in 2011 (Space Is The Place), but this time around I want to focus on one particular set of circumstances where the problem can arise. At… Continue reading When 2 is greater than 10 Afficher la totalité du billet

Successful UI Design

How easy is it for you to design the user interface of your FileMaker database? Are there any tips you have which makes the process easier? If so, then I would love to hear them! In this video, I'm providing you with the best information I have about a successful UI design process. It's the opening video to a deep dive about how themes actually work within FileMaker. I start with a blank layout and go over the major areas of what I consider when starting the design of a new database or a re-ski

Top 5 inspirational quotes to help you get things done

This month we’ve been looking at how we manage our time more efficiently in order to be more productive, you can check out our blog post on this – Practical tips for improving time management. But sometimes, your own will and way just doesn’t do the trick, so we’ve come up with a list of [...] The post Top 5 inspirational quotes to help you get things done appeared first on The Scarpetta Group, Inc.. Afficher la totalité du billet

Fun with SQL Joins and Currency Formatting

Demo file: sql-join-fun-etc.zip requires FM 18 or later. Recently I was asked to create a mini-report combining data from a pair of related tables via ExecuteSQL. This provided an opportunity to think about SQL joins, and also to come up with a way to apply currency formatting to dollar amounts in the SQL query result,… Continue reading Fun with SQL Joins and Currency Formatting Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

Catching Duplicates with Validation

One of the best feelings for any database developer is knowing that duplicate data simply can't sneak into your solution. You've got clean data such that when you search for a specific email address you know there's only one and it belongs to the right entity. In the associated video and sample file you'll get all the details for how you can use FileMaker's Unique value validation option. You'll see how you can prevent FileMaker from showing it's annoying dialog box which uses the name of the f

Networking Online – What’s the Etiquette?

Whether you’re just starting your business, or you’ve been established for quite some time, you’ll likely understand that networking plays a huge role in the success of your business. It’s also likely you can think of at least one professional relationship you have that has had a positive impact on your business. The term [...] The post Networking Online – What’s the Etiquette? appeared first on The Scarpetta Group, Inc.. Afficher la totalité du billet

Securing QR Barcodes

Pretty much all over the world you'll find technology which can scan barcodes. Smartphones with cameras just waiting to scan either their very first, or even their 1000th barcode scan. With just over a decade since the first iPhone came out, it's pretty hard to not find a use case where a barcode can help you retire some antiquated manual process. Barcodes can be used almost anywhere to make faster and/or easier solutions. Given that FileMaker Go supports all major barcode types, you simply nee

Case Sensitive Searching

Out of the box, FileMaker is a really easy solution for inputing data and simply finding the results you want when searching that data. There are, however, times when you need to break away from FileMaker's "solve all" solution of case insensitive searching. Times where you simply want to present some data within your user interface - without setting up extra relationships or fields. Or, those times when you simply need to search based on the case sensitivity of the data within a field. In ord

Remove the Background? There’s an API for that? RemoveBG

Remove the background from an image? Did you ever need to remove the background from an image? For example, maybe you have user photos in your FileMaker database and want all of the photos to be uniform for an ID. Or maybe a product photo that is too busy and it would [...] The post Remove the Background? There’s an API for that? RemoveBG appeared first on The Scarpetta Group, Inc.. Afficher la totalité du billet

Native Web Scraping with JavaScript

Some of my most favorite moments, when working with technology, are when you see the result of a few lines of code do what used to take hours and hours of work. Seeing the fruits of knowledge labor which replaces a lot of manual labor. It's glorious! The example I'm mentally referencing is any time you need to extract some content from a web page and it's literally SITTING RIGHT THERE in front of your face and you end up using your precious time doing the good old copy and paste. Every day the

File IDs, Table IDs and Field-Level Schema

Demo file:  file ids, table ids and field-level schema.zip (requires FM 18 or later) INTRODUCTION Recently I was asked to help document a FileMaker solution by creating and populating a “schema” table as per the above screen shot. One of the requirements was to programmatically determine internal ID numbers for the file and for the… Continue reading File IDs, Table IDs and Field-Level Schema Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

  • Create New...