FileMaker 18 introduces two new cryptographic functions which can be used to generate and verify digital signatures:
Generate digital signature
CryptGenerateSignature ( data ; algorithm ; privateRSAKey ; keyPassword )
Verify digital signature
CryptVerifySignature ( data ; algorithm ; publicRSAKey ; signature )
Why Use Digital Signatures: An Example
Digital signatures are a digital analog to good old-fashioned physical signatures which we’re all familiar with. Digital signatures serve a simil
Hello everyone! I have created a custom function for dynamically creating JSON arrays for related records in FileMaker, and I’d like to share it with you all.
The custom function can be found in the sample file. Its full signature looks like this:
#JSON_GetRelatedData ( objectName ; attributeList; relatedTO; relatedRecordCount; JSON; iterationRecord; iterationField )
Figure 1. Custom function for creating dynamic JSON
It takes in several parameters, as described below:
Dynamically Create JSON Arrays for Related Records
Download the custom function for dynamically creating JSON arrays for related records in FileMaker, built by Makah Encarnacao, Soliant Consulting Technical Project Lead.
The file includes two buttons that use this custom function: Manufacturer and Model JSON and Model JSON. The Manufacturer and Model JSON button demonstrates how you would use this custom function in combination with other JSON data. The Model JSON button demonstrates how to us
Every summer, our team enjoys traveling to DevCon, FileMaker's developer conference. As a FileMaker Platinum Partner, we attend the conference to build on our skills, meet with clients, and share our knowledge.
In fact, a handful of team members are presenting and sharing their insights with attendees this year:
Bob Bowers, President
Learn advanced techniques and strategies for creating high-performing, scalable FileMaker custom apps. Explore tools and techniques to make yo
Unfortunately, there is a downside to this method of powerful, free data display. Implementing
Not ( Having a Computer Science Background )
The FileMaker developer community seems to consist of people with quite a wide range of backgrounds, much more so than is the case with developers from other programming languages and software development platforms. I suspect this is a consequence of the rapid application development (RAD) nature of the platform and its lower learning curve. This makes it possible for individuals to change course in their careers once they serendipitously encounter F
FileMaker Templates are out! Our team here at Soliant was lucky enough to help build the files and tutorials, and I wanted to share our hopes for how you can make use of them. Three templates are available so far, and each one targets a different business model: Job Tracking, Event Management, and Memberships.
Each template comprises a few parts:
A core file
Tutorials for how to add Build-On features
A final file that includes all Build-ons
The idea is that you begin with a core file and
Our team worked with FileMaker to build several template files to help businesses launch specific functionality. These files encourage workplace innovation without requiring extensive development experience.
File Foundation Built for You
At the core of these templates, you’ll find a solid, consistent design, clean look, and strategic user interface and user experience. Look under the hood and you’ll find much of the same. That wasn’t by accident. Our team spent a great deal of time determining
Do you miss the statistics chart?
Figure 1. FileMaker 16 Admin Console with Statistics live view
The admin console was rewritten in FileMaker Server 17, and the Statistics section was not carried over to the new version. But when you are dealing with server performance issues, having a live view of the FileMaker Server statistics can be critical.
If your FileMaker Server runs on Windows, you can regain most of this lost functionality using the Performance Monitor tool ("Perfmon").
FileMaker introduced a very different kind of capability with the ExecuteSQL function. First introduced in FileMaker 12, it allows you to perform “select” queries against your FileMaker data, as opposed to the more familiar “Find” functionality available in FileMaker.
SQL (Structured Query Language) is a standard used with other, more traditional, database servers. Using SQL, SELECTS on indexed data is blazing fast and efficient. It allows you to construct relationships in SQL that do not neces
One of the biggest risks in undertaking a big software development project is underestimating the time and effort involved from start to finish. Our team has provided estimates for hundreds of projects, and sometimes we’ve missed the mark, especially in the early days of our business.
Over the years, we’ve put together a strong model for estimating how much time and effort a project is likely to require; our employees undergo annual training on the method. Using these methods ensures we present
What Are Script Parameters?
Script parameters are one of many tools that all FileMaker developers should learn to utilize when developing custom FileMaker applications. Numerous benefits include writing fewer scripts, increased code reusability, and improved coding organization.
By designing your scripts to pass parameters, you can use a single script with logic branching (i.e., IF, ELSE IF, ELSE) to perform multiple actions within your FileMaker solution. For example, you can create a Sales Or
FileMaker Portal Columns
I was recently asked to sort portal columns for a client, and I figured there has to be a newer and cooler technique out there to accomplish portal sort than when I did it last. I reached out to the other FileMaker developers at Soliant, and I got a great sample file from Ross Johnson. He shared a really cool technique with me, crediting mr_vodka (sounds like a fun guy!). Read mr_vodka’s original post here.
For my client, I was also asked to filter the portal and batch
Take Your Portals to the Next Level
FileMaker portals are invaluable for showing related data; there are several techniques for enhancing their functionality. Our demo contains three methods for adding the ability to sort, filter, and batch update portals.
Follow along with our step-by-step guide and get started with expanding the functionality of the portals in your FileMaker solution.
Complete the form to receive the demo file:
Trouble with this form? Click here.
The post FileMaker P
Gemini to Apollo
Just like trailblazers such as Gus Grissom, working on the Mercury, and later, Gemini projects for NASA, we sometimes require separate or parallel environments in project deployments. Gemini could be viewed as the “Dev” phase that led up to the “Prod” project that followed, Apollo. Development environments are a critical part of projects where experiments and testing can be done without risk to critical resources, allowing bugs to be found and worked out.
Similarly, in FileMa
This is the final post in my series about the demo I presented during my “IoT and the FileMaker Data API” session.
The 'master' branch is the more interesting one as it uses the viseme information that Amazon Polly provides. For this to work I needed some linguistics help to interpret what those visemes mean.
In my DevCon session I jokingly stated that the session happened because of the help of both my daughters, one is in university studying Biology (fish, get it?) and the oth
This is the fourth in a series of posts about the demo I presented during my “IoT and the FileMaker Data API” session.
Making it Work in Python
The first half of my DevCon presentation would be about collecting sensor data from a Raspberry Pi and sending that data to FMS through the Data API, and I am using Windows 10 IoT and .NET code for that. If I could do the second half of the presentation using Python, then it would show off the versatility of both the Raspberry Pi device and the FileMak
This is the third in a series of posts about the demo I presented during my “IoT and the FileMaker Data API” session.
Construct #2 - Billy Bass Bones
As mentioned in my previous post, I decided to do everything from the Raspberry Pi to control the Billy Bass toy.
While I was scouring eBay looking for pristine Billy Basses I came across this one as shown in Figure 15.
Figure 15 - Ordering a Billy Bass
I thought that would be funny and I could make the story about the fact that almost 20
This is the second in a series of posts about the demo I presented during my “IoT and the FileMaker Data API” session.
Construct #1 - the original Billy Bass
I wanted to find a Billy Bass that was as close to the original one used in the 2001 DevCon session, so I started digging around on eBay, and this is the one I ended up buying:
Figure 9 - Buying an original Billy Bass
When it arrived, I unscrewed the back to see how I could get at the motors (see Figure 10). There's a small controller
At this year’s DevCon in Dallas, TX, I presented a session on FileMaker and IoT (Internet of Things); in preparing for it I settled on this definition of IoT:
Based on that definition and the highlighted core elements, I split up the DevCon session into two parts:
Collecting sensor data and sending it to FileMaker Server through the Data API; and
Manipulate the environment by driving motors based on data retrieved from FileMaker Server.
The first part was easy, using a couple of Raspberry
Last week I wrote about my experience assisting with Bob Bowers’ Advanced session. I also interviewed two other trainers about how their sessions went. That was so much fun I decided to interview everyone who gave trainings this year.
I managed to track down three more: Mike Beargie of MainSpring, Jeremy Brown of Geist Interactive, and Cris Ippolite of iSolutions. It was a pleasure to speak with them all. Here’s some of what they had to say.
Intermediate - FileMaker Shared Hosting Master Class
Today was the final day of DevCon, and it has an entirely different flavor. It is Customer Day! Rather than technical topics, the majority of today’s sessions show-and-tell client stories of problems solved by utilizing FileMaker.
Success Stories of Soliant's Philanthropy Committee
The first session I attended began with a presentation by our own Makah Encarnacao. Makah shared her own story of a chance conversation with Chris Manto during DevCon a few years ago. Over a drink at the bar he shar
After a busy first day of FileMaker DevCon 2018, day 2 continued the theme of FileMaker being a Workplace Innovation Platform.
FileMaker + Tableau, a Match Made in Data Heaven!
The morning sessions included an eye-opening Tableau integration session from Vincenzo Menanno. In his session, Vincenzo demonstrated how one could use Tableau charting and graphing tools inside a FileMaker WebViewer and subsequently use Tableau's URL Actions, to call specific FileMaker scripts within your solution, whi
The FileMaker Developer Conference has become, for me, a bit of a reunion. As a remote employee, FileMaker DevCon is a chance to hang out with my co-workers… and it feels like the FileMaker community at large is just an extension of that group.
The sessions are good, too.
Workplace Innovation Platform
The morning kicked off with a Special Session, where Andy LeCates introduced FileMaker as a Workplace Innovation Platform. This framing hits the nail squarely on the head. They’ve summed up wh