Welcome To FMForums

Welcome to our community, full of great ideas on developing your FileMaker solutions effectively,
for peer-to-peer support of the FileMaker Platform and related products and services.

Register and join the conversation!

Sign In

or

Sign Up

Blogs

Featured Entries

Hacking Your Own FileMaker Platform Solutions

By Steven H. Blackwell April 7, 2016

Hacking Your Own FileMaker Platform Solutions Should FileMaker Platform developers mount hacking attacks on their own solutions? At first glance, this may seem an odd question. But I believe that the answer is “Yes, we should.” Consider this. As developers we see our solutions from a totally different perspective than Threat Agents see them. Without practicing our own hacking skills, we can become blind to the vulnerabilities a Threat Agent can exploit to compromise the Confidentiality
- 1 comment
- 3,118 views
A Conversation About '2 Factor Authentication'

By Josh Ormond February 8, 2016

[ Edit: 3/16/2016 - With the help of some other people, we have been able to recover, or recreate some of the original images from original thread. ] Security is always a big topic when it involves data, or people, or possessions. Recently, over on the FileMaker Community, there was a very beneficial discussion regarding security. Unfortunately, that discussion was the victim of a necessary action...and was deleted. It was deleted, because the discussion was tied to a video that, as was det
- 1 comment
- 2,956 views

Designing with Portals

Over the years I've spent a lot of time working on a wide variety of themes for FileMaker Pro. Many of those themes involve taking advantage of every possible display mechanism which FileMaker portals offer. When getting started with creating solutions in FileMaker Pro you don't always know what you can take advantage of. When it comes to portals there are a variety of settings and theme aspects which allow you to create some really creative looks. In this video I strive to show you all those h

FileMaker Magazine

18 hours ago

FileMaker 19

Claris FileMaker Pro 19.1 Overview

Claris’s first of many frequent releases of the FileMaker platform is here as Claris focuses on being agile and low-code moving forward, with new features being released more frequently. In this article we will focus on FileMaker Pro 19.1 and discuss some of our favorite new features, including 9 new add-ons and the new layout design experience preview. https://dbservices.com/blog/claris-filemaker-19-1-overview dbservices.com

dbservices in FileMaker 19

Yesterday at 11:52 AM

FileMaker 19: FileMaker Add-ons with Join Relationships

In Part 2 of All that we Know on Add-ons (part 1 is here), we talked about how to create add-ons that include a simple child relationship. The sole purpose of that add-on was to add a child table and have it automatically relate to the context of the layout in which we drop the […] The post FileMaker 19: FileMaker Add-ons with Join Relationships appeared first on Geist Interactive. View the full article

Todd Geist

October 14

Detecting Data Changes

Here's an interesting dilemma. How do you track when specific fields are modified and adjust your JSON object so it only includes the data which was modified? Or, how about knowing when a user has modified specific fields, then having the user interface direct them down a different path than if they had modified others? In both situations, you simply need to know when a field was modified. Using the Get ( RecordModificationCount ) function we can know THAT a given record was modified and using

FileMaker Magazine

October 13

Claris FileMaker Add-ons: Add-on Events

We’re continuing our discussion of the new FileMaker 19 add-ons. Claris has released a great video on these add-ons, but, in this series of posts, we’re taking a deep dive into how the add-ons work. In this post we look at the FileMaker add-on events. Each FileMaker add-on comes with one or more events. A […] The post Claris FileMaker Add-ons: Add-on Events appeared first on Geist Interactive. View the full article

Todd Geist

October 13

Claris FileMaker Add-ons: Refreshing the Data

We’re continuing our discussion of the new FileMaker 19 add-ons. Claris has released a great video on these add-ons, but, in this series of posts, we’re taking a deep dive into how the add-ons work. In this post we look at how to use the FileMaker add-on refresh feature. The Point of the Add-ons In […] The post Claris FileMaker Add-ons: Refreshing the Data appeared first on Geist Interactive. View the full article

Todd Geist

October 6

FileMaker Add-ons: Refetching To ReRender

We’re continuing our discussion of the new FileMaker 19 add-ons. Claris has released a great video on these add-ons, but, in this series of posts, we’re taking a deep dive into how the add-ons work. In this post we will examine the FileMaker add-on refetch process. Many of the add-ons are sort of ‘dashboard’ add-ons. […] The post FileMaker Add-ons: Refetching To ReRender appeared first on Geist Interactive. View the full article

Todd Geist

October 6

Nineteen Point One

You've all heard it's going to happen! Releases every quarter rather than every year. Even yearly releases were a shock given the multiple years between release in the previous decade. It may be uncomfortable but it's necessary with the way technology moves in the current day and age. You'll get less with every release but the changes will come much faster. As promised publicly by Claris, FileMaker 19.1.2 (or 19.1) includes JavaScript Add-Ons and a few other surprises. View the full article

John Mark Osborne

October 6

Claris FileMaker Add-ons: Using Multiple Instances

We’re continuing our discussion of the new FileMaker 19 add-ons. Claris has released a great video on these add-ons, but, in this series of posts, we’re taking a deep dive into how the add-ons work. In this post we look at how to use multiple instances of the FileMaker add-ons. The Point of the Add-ons […] The post Claris FileMaker Add-ons: Using Multiple Instances appeared first on Geist Interactive. View the full article

Todd Geist

October 5

Claris FileMaker Add-ons: Configuring Each Add-on

We’re continuing our discussion of the new FileMaker 19 add-ons. Claris has released a great video on these add-ons, but, in this series of posts, we’re taking a deep dive into how the add-ons work. In this post we look at the FileMaker add-on configurator The add-ons are meant to be working with little effort. […] The post Claris FileMaker Add-ons: Configuring Each Add-on appeared first on Geist Interactive. View the full article

Todd Geist

October 5

Claris FileMaker Add-ons: Required Fields

Learn all about each in-product add-on's required fields. The post Claris FileMaker Add-ons: Required Fields appeared first on Geist Interactive. View the full article

Todd Geist

October 2

Scripting - JSON Data Writer

While working on a solution which made heavy use of an online API for REST based communication, the solution slowly revealed it had a large number of "specially dedicated" data processing scripts. Many of these scripts were quite normal in the realm of "I have some data, I want to put it into the right place." You know, your typical Go To Layout then Set Field script steps. The issue, however, was that most all of them did somewhat they same thing - a lot of code duplication. They either put th

FileMaker Magazine

October 1

FileMaker Add-ons: Filtering the Data

We’re continuing our discussion of the new FileMaker 19 add-ons. Claris has released a great video on these add-ons, but, in this series of posts, we’re taking a deep dive into how the add-ons work. In this post we look at the FileMaker Add-ons Filter mechanism. The Default Behavior By default, the add-ons work with […] The post FileMaker Add-ons: Filtering the Data appeared first on Geist Interactive. View the full article

Todd Geist

October 1

Claris FileMaker Add-ons: Refining the Find

We’re continuing our discussion of the new FileMaker 19 add-ons. Claris has released a great video on these add-ons, but, in this series of posts, we’re taking a deep dive into how the add-ons work. In this post we look at the FileMaker Add-ons Find mechanism. FileMaker Add-ons Find Mechanism By default, each ‘dashboard’ add-on […] The post Claris FileMaker Add-ons: Refining the Find appeared first on Geist Interactive. View the full article

Todd Geist

October 1

How Claris FileMaker Add-ons Work

As we have said before (and I’ll probably say one hundred more times), the Claris FileMaker Add-ons just work. In just a few minutes, you can get a fully functional heatmap or activity timeline running with your data (all records or a found set) in your custom apps. In just a few minutes, you can […] The post How Claris FileMaker Add-ons Work appeared first on Geist Interactive. View the full article

Todd Geist

September 29

Add-Ons, the Complete (and almost TMI) Guide

The most recent update of Claris FileMaker Pro (19.1.2) includes add-ons. Finally. a calendar, a timer, a kanban board, and much more are part of the actual FileMaker product, built as add-ons. These add-ons are designed to be fully functional with just a little bit of set up. Each add-on contains layouts, scripts, custom functions, […] The post Add-Ons, the Complete (and almost TMI) Guide appeared first on Geist Interactive. View the full article

Todd Geist

September 29

FileMaker Integrations

FileMaker Amazon Textract Integration

Integrate your FileMaker database with Amazon Textract to turn paper or scanned documents into useful digital data. Includes a video and free sample file: https://dbservices.com/blog/filemaker-amazon-textract-integration dbservices.com

dbservices in FileMaker Integrations

September 23

FileMaker CRM

FM Quickstart 19

FM Quickstart, the premier free CRM app for FileMaker, has been updated for FileMaker 19. Several new features and modules have been added including Task Lists, Calendar, and more. FM Quickstart Implementation Plans have also been added to our services offered in order to assist with setup and customization of FM Quickstart. Learn more about these exciting new features and get started with FM Quickstart here: https://dbservices.com/blog/fm-quickstart-19 dbservices.com

dbservices in FileMaker CRM

September 23

Writing Custom Functions - Successfully

While taking the time to write a four hour custom function the other day, it occurred to me that some viewers may think that complex custom functions are just something which pops out of your head and immediately ends up on the screen. When, in fact, the truth is it takes a lot longer than you expect because you rarely get things perfectly the first time. It's all about wading through the errors and issues and ending up with the desired result. In this video, I walk through my process of compo

FileMaker Magazine

September 22

Quick Find Power Mode

Who doesn't like the simplicity of using a single field to search across many. That's essentially what Quick Find is. In fact, by default FileMaker makes the silly assumption that every field you add to a layout is something you want the user to be able to search. Essentially, you want to take control of the user experience in terms of search and make sure the user is not only searching what you want them to search, but also able to search in a fashion which is both familiar and comfortable. T

FileMaker Magazine

September 10

Transactional Processing

Record locking in a multi-user scenario is easy to control on a single record. Just use the Open Record/Request script step and test for an error 301. If the error occurs, stop the script and present a dialog telling the user they can't run that script right now. If no error occurs, the current user now has control of the record and it can be freely modified by a script. However, if your script loops through records or uses the Replace Field Contents script step, the difficulty controlling recor

John Mark Osborne

September 8

Render Found Set as JSON Object

Demo file: found-set-to-json-object.zip (40MB; requires FM 18 or later) [Author’s note: the demo file is a work in progress. Modify it as you see fit.] Today we’re going to compare various methods one might consider employing to render an arbitrary found set as a JSON object. The demo consists of a table of US customers… Continue reading Render Found Set as JSON Object View the full article

Kevin Frank

September 7

Killer Keywords

In many situations, you'd think the easiest solution would be the best. Saving time and getting the job done quickly. This, however, just isn't the case if you're going to allow users to use a simple text field for managing keywords or tags. A tagging system relies on making it easy for the user, but it may not be so easy to implement itself. Here are a few questions you might be faced with. What happens when one user enters "devloper" on record 1 and another user enters the correctly spelled "

FileMaker Magazine

September 2