Jump to content
Salesforce and other SMB Solutions are coming soon. ×

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
    • 354 views

Virtual List Reporting, part 4

Introduction Back in 2017 I wrote about a technique to enable users to a) produce multiple on-screen reports, and b) interact with those reports in browse mode. The article was called Virtual List Reporting, part 3, and while the approach it advocated works well enough under most circumstances, today I’d like to share some fresh… Continue reading Virtual List Reporting, part 4View the full article

Kevin Frank

Kevin Frank

Set Variable By Name Re-Revisited

Demo files: set-var-by-name-v4 and set-var-by-name-md5 Background This is a quick follow up to last December’s Set Variable By Name Revisited, and to avoid repetition will assume the reader is familiar with the material that was presented in that article. But to briefly recap: 1. FileMaker does not provide an obvious way to programatically name a… Continue reading Set Variable By Name Re-RevisitedView the full article

Kevin Frank

Kevin Frank

Adding .ics files to Calendar on iOS

Try this, email an .ics file to yourself and then attempt to add it to the Calendar app on your iPhone or iPad. Does it work? It didn't for me as of 2021-07-31. Seems like it used to work. A web search suggests that other people are having the same problem. Possibly for security reasons Apple turned this feature off? Anyway, this has an impact on a FileMaker Go demo database I made a while back that exports .ics files. Recently a reader, Nellie, wrote to say: View the full article

Douglas Alder

Douglas Alder

PSOS – Run Script in File not open Locally

Update: See Jason Wood’s suggestion in the comments section for making this technique more secure. INTRODUCTION Today I want to take a look at a certain Perform Script On Server (PSOS) behavior, and for those who find this behavior to be inconvenient, propose a work around. Here’s the behavior, or misconception, actually: a server side… Continue reading PSOS – Run Script in File not open LocallyView the full article

Kevin Frank

Kevin Frank

FileMaker 19 + JSONata

Introduction Recently I had the pleasure of speaking with Jeremy Brown on The Context Podcast about an open-source project called JSONata that enables you to query and transform JSON. The JSONata site is packed with useful information, including this short video… …as well as… Extensive documentation A link to the Stack Overflow forum, where you… Continue reading FileMaker 19 + JSONataView the full article

Kevin Frank

Kevin Frank

Building this plugin was a passion project for ...

Building this plugin was a passion project for me. I found myself searching the same web sites for things like computer products or royalty-free music, video and photos. I wanted it a way to search once and have many tabs open all in one go with the search already composed and ready to go. I looked around but could not find anything that fit the bill. First I built it in FileMaker and it was useful, but I wanted it in my browser, so it was always handy. View the full article

Douglas Alder

Douglas Alder

Bypassing Scientific Notation

Earlier today I needed 1 billion to render in the calc engine as 1000000000, but FM helpfully converts numbers to scientific notation if they A) are >= 1 billion, and B) contain nothing but zeros following the initial digits. Example where “A” and “B” are both true: Example where “A” is true but “B” is… Continue reading Bypassing Scientific Notation View the full article

OData for FileMaker – Examples, Tips and Nuances

This blog post is the second of a three-part series about the FileMaker OData API, introducing a demo file with more than 40 examples plus helpful tips, along with Q&A. Part one of the series highlighted some of the key features of the API which make it an exciting addition to the FileMaker platform. As a […] View the full article

Beezwax Buzz

Beezwax Buzz

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.. View the full article

Joe Scarpetta

Joe Scarpetta

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 View the full article

Kevin Frank

Kevin Frank

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 […] View the full article

Beezwax Buzz

Beezwax Buzz

When 2 is greater than 10

Today we’re going to take a quick look at a potential “gotcha” that can occur when performing 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 first… Continue reading When 2 is greater than 10 View the full article

Kevin Frank

Kevin Frank

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.. View the full article

Joe Scarpetta

Joe Scarpetta

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 View the full article

Kevin Frank

Kevin Frank

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.. View the full article

Joe Scarpetta

Joe Scarpetta

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.. View the full article

Joe Scarpetta

Joe Scarpetta

File IDs, Table IDs and Field-Level Schema

21 Jan 2021: demo has been updated to fix a couple bugs; article has been updated to reflect these changes. Demo file:  file ids, table ids and field schema, v4.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… Continue reading File IDs, Table IDs and Field-Level Schema View the full article

Kevin Frank

Kevin Frank

Set Variable By Name Revisited

Demo file: set-variable-by-name-v3.zip (requires FM 16 or later) [Demo has been upgraded to v3 to fix a bug in the cfZap custom function]. INTRODUCTION You’ve probably heard the old joke that goes… Patient: Doc, it hurts when I do this. Doctor: Don’t do that. Perhaps you’re also familiar with the FileMaker equivalent? Developer: It hurts… Continue reading Set Variable By Name Revisited View the full article

Kevin Frank

Kevin Frank

×
×
  • Create New...

Important Information

Terms of Use