Jump to content

Blogs

Featured Entries

  • Joe Scarpetta

    FileMaker®-based vs. Salesforce vs. Hubspot — Which CRM is Best?

    By Joe Scarpetta

    A CRM is an important tool that can help you streamline your processes and boost profitability. A good CRM is flexible enough to adapt to whatever you need it to do: track which leads are converting to customers, automate tasks, learn which activities are driving sales, deliver better customer service, etc. All in an [...] The post FileMaker®-based vs. Salesforce vs. Hubspot — Which CRM is Best? appeared first on The Scarpetta Group, Inc.. View the full article
    • 0 comments
    • 224 views
 

FM18: JSON.UpdateArrayElement

Disclaimer: the technique shown in this article is an attempt to work around an annoyance that can crop up when using FileMaker’s native JSONSetElement function. Use with appropriate caution and at your own risk. Acknowledgement: I owe a debt of gratitude to Paul Jansen for many illuminating JSON-related discussions over the last year or so.… Continue reading FM18: JSON.UpdateArrayElement View the full article

Kevin Frank

Kevin Frank

 

FileMaker Salesforce Marketing Cloud Integration

FileMaker Salesforce Marketing Cloud Integration As one of the top email marketing platform, Salesforce Marketing Cloud provides the ability to create marketing email campaigns that scale from a handful of customers to millions. And with Salesforce Marketing Cloud’s SOAP API and automation tools, you can automatically import email engagement statistics into your FileMaker application and link them to customers and prospects.  Setup The first step is to create a new app package from the Sale

dbservices

dbservices

 

FM Data Migration Companion

FM Data Migration Companion In our previous article, we discussed the FileMaker Data Migration Tool and all of its great benefits: instead of spending hours building custom migration scripts, you just write a command that automatically transfers data from one file to another. This saves time, money, and headache for everyone involved. And to make the process even easier, we built the FM Data Migration Companion, a FileMaker file that automatically creates the data migration CLI commands for you

dbservices

dbservices

 

FileMaker Devcon 2019

FileMaker Devcon 2019 The FileMaker Developer's Conference will be held in Orlando, FL at the Gaylord Palms Resort from August 5-8th. This will be my 18th consecutive Conference, over 20 years with FileMaker, and 11+ years as a company. We have been exhibitors at the conference for the past 6 years. We love catching [...] The post FileMaker Devcon 2019 appeared first on The Scarpetta Group, Inc.. View the full article

Joe Scarpetta

Joe Scarpetta

 

FileMaker Web Apps with Vue.js

FileMaker Web Apps with Vue.js There inevitably comes a time in a successful FileMaker application’s life where it needs to be extended to the web, usually as a customer portal. WebDirect may suffice as a solution, but if the needs go beyond WebDirect’s capabilities, standard web technologies must be used, such as HTML, CSS, Javascript, and a backend scripting language like PHP. Building an app on the web can be a daunting task for a FileMaker developer, especially a web app that’s as inter

dbservices

dbservices

 

Fixed in 18: List + GetNthRecord Bug

Recently I was working in FM 17 and ran into an unexpected bug. My use case was more complex than this, but the following bare bones demo illustrates the problem. Demo file: List+GetNthRecordBug.zip Given two tables joined via a standard primary-key-to-foreign-key equijoin relationship… This works as expected. You might think you could get rid of… Continue reading Fixed in 18: List + GetNthRecord Bug View the full article

Kevin Frank

Kevin Frank

 

FileMaker 18 Adds Support for ESV (Finally!)

Here at the Beezwax, we have been performing research on FileMaker 18 import changes, specifically new support for ESV: Emoji Separated Values. At Beezwax, we develop the bBox FileMaker plug-in (Get it: “Bee Box”?), nicknamed our blog the Beezwax Buzz, refer to our headquarters as the Bee Hive, and our employees (who are always incredibly bee-sy) […] View the full article
 

A Lesson in Functional JavaScript

Functional programming is all about passing functions around. Let’s try a practical example in JavaScript, using high order functions, filters, “currying” and more. But first, perhaps a brief historical review is worth a moment of our time… JavaScript, then and now Before JavaScript had the class keyword, there were many ways to write JavaScript code. […] View the full article

Beezwax Buzz

Beezwax Buzz

 

Filemaker SurveyMonkey Integration

FileMaker SurveyMonkey Integration SurveyMonkey is a popular cloud-based survey platform boasting over 20 million questions answered per day. Flexible and user friendly, surveys generated by SurveyMonkey can be used for a variety of purposes, from large company wide reviews to customer satisfaction surveys. Using SurveyMonkey’s API you can automatically collect survey responses and data directly into your FileMaker application, allowing you to link your surveys to your FileMaker data. 

dbservices

dbservices

 

New in FM 18: While, part 2

Today we’re going to dig a little deeper into the new-in-18 While function, and to avoid repetition, will assume readers are familiar with last month’s article on SetRecursion and While. We’ll examine some new examples ranging from basic to advanced, talk about the circumstances under which While can use variables previously declared via Let, and […] View the full article

Kevin Frank

Kevin Frank

 

We’ve been waiting for While()… for a while

FileMaker has been missing a looping control structure in its function set for…well…a while. So, the introduction of FileMaker 18’s While() function is less a fancy new feature than it is a fix for a long standing limitation in FileMaker’s function set. But even if it’s long overdue, its introduction profoundly changes what it is […] View the full article
 

Native HTML Email in FileMaker 18

Email is one of the simplest tools used to communicate and send information. Just open a mail client, write a message and press a button to virtually send a letter or message to a recipient. Sometimes, in addition to simple text, we want to enrich our emails with graphical contents and attachments, making it more […] View the full article
 

9 Ways to Increase CRM User Adoption Rates

A CRM is the hub of your organization, streamlining your business processes to increase productivity and sales. Most companies recognize the value of a CRM, and according to CRM Magazine, 91% of companies with 10 or more employees have a CRM. However, a study by Merkle Group Inc. found that CRM initiatives have a [...] The post 9 Ways to Increase CRM User Adoption Rates appeared first on The Scarpetta Group, Inc.. View the full article
 

Imports without Tariffs. Natively, with FileMaker Server.

Combining functions, features, or steps in creative new ways can deliver productive results. I was thrilled to discover in FileMaker 18 that the new file-based script steps give us the ability to perform imports natively on FileMaker Server, with no configuration or changes needed. You can also take advantage of Perform Script on Server (PSoS), […] View the full article
 

New in FM 18: SetRecursion and While

Author’s note: Inevitable comparisons will be drawn between the new While function and the venerable CustomList custom function, which I wrote about at length several years ago. Preliminary testing indicates that CustomList is faster under certain circumstances and While is faster under others. In my opinion, both of them belong in your developer tool kit. […] View the full article

Kevin Frank

Kevin Frank

 

FileMaker 18 Security Enhancements

FileMaker 18 Security Enhancements Among the ensemble of new things to play with, FileMaker 18 brings with it a collection of security enhancements. Some of these changes include a redesigned Manage Security dialog aimed towards improved ease of use, an ability to manage FileMaker users without the need to have Full Access privileges, and a security warning for potentially malicious plug-ins.  Manage Security Redesign The Manage Security dialog has been redesigned, combining the Detail

dbservices

dbservices

 

FileMaker While Function

FileMaker While Function Sometimes smallest features offer the biggest impact. The new While function, which gives the ability to loop within a calculation, drastically reduces the need for one-off recursive custom functions, speeding up development in any part of FileMaker that requires looping in a calculation. Let’s take at how it works.  How It Works The format of a while function is broken into four parts: initial variables, the condition, logic, and the results. The function repea

dbservices

dbservices

 

FileMaker 18 Database Engine Improvements

FileMaker 18 Database Engine Improvements FileMaker Server 18 brings some exciting database improvements in the form of faster processing of parallel queries and automatically recovering corrupt databases when the server starts up using a transactional log. This auto-correction feature, called Startup Restoration, will save significant time and headaches during disaster recovery of a FileMaker application. Both updates are intertwined within Startup Restoration, which means that added speed and

dbservices

dbservices

 

Redesigned FileMaker Import Dialog

Redesigned FileMaker Import Dialog The new FileMaker 18 Import Dialog has been redesigned to be more user-friendly, flexible and fast. Some of the new features include the ability to select the target fields in a list that can be filtered and the ability to perform auto-enter options individually for each field.  What Is New? User-friendly interface Ability to select the target field from a list that can be filtered A custom row can be used as the “Field Names” row in the source fil

dbservices

dbservices

 

FileMaker Script Error Logging

FileMaker Script Error Logging For many years FileMaker Server has automatically logged errors in server side scripts, but now with FileMaker 18 developers have to ability to log script errors client side in FileMaker Pro and Go, saving time troubleshooting issues with scripts. And with the new file manipulation script steps, developers can automatically import script error logs into a centralized table to quickly view errors across all clients.  A simple-to-use script step Error lo

dbservices

dbservices

 

Using REST and cURL with FileMaker Server 18’s Data API

Well, here we are again! With the release of FileMaker 18 we get the third version of the FileMaker Data API. This version brings an iterative advancement in features while maintaining the core functionality that was introduced with V1 of the API in FileMaker Server 17. I’m following suit with an iterative advancement of my previous […] View the full article
×
×
  • Create New...

Important Information

Terms of Use