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

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

Business Trends for 2021

Business Trends 2021 Wow, 2020, just wow! So many changes in the world and very obvious changes to the way in which businesses operate. How long will these changes last? Has the way in which we work changed forever? With so much uncertainty, it’s comforting to know that predictable emerging trends will see us [...] The post Business Trends for 2021 appeared first on The Scarpetta Group, Inc.. View the full article

Joe Scarpetta

Joe Scarpetta

Christmas Gifts for Tech Geeks

It’s hard for those of us who aren’t in the know, to buy for those who are… so with Christmas 2020 just around the corner, we’ve compiled our top 8 favorite Christmas gifts for the tech geek in your life. Starting off with something super relevant, it’s the UVC Sterilizer Box with Wireless Charger. [...] The post Christmas Gifts for Tech Geeks appeared first on The Scarpetta Group, Inc.. View the full article

Joe Scarpetta

Joe Scarpetta

A Value List Experiment

Demo file: a-value-list-experiment.zip Note 1: today’s demo is recycled from the one that accompanied Virtual Portal, part 2. All we care about this time around is how we assign the parent company; the remainder can be ignored. Note 2: if you’re unclear on value list basics, check out Thinking About Value Lists, part 1. “I… Continue reading A Value List Experiment View the full article

Kevin Frank

Kevin Frank

What are your customers’ pain points?

If there’s one thing that can stop a sale dead in its tracks, it’s an objection. There are always going to be reasons your potential customers hold back from purchasing from you, and you can be one step ahead if you figure out these possible objections beforehand and address them in your website FAQs. [...] The post What are your customers’ pain points? appeared first on The Scarpetta Group, Inc.. View the full article

Joe Scarpetta

Joe Scarpetta

Know your audience

All businesses have a target audience they want to reach, that much is obvious, but why it’s so important as well as how to define your target consumer, may be less so. Whether you’re offering a product or service, as a business owner, you’re going to want to make the most out of your [...] The post Know your audience appeared first on The Scarpetta Group, Inc.. View the full article

Joe Scarpetta

Joe Scarpetta

OOP Fundamentals: The Decorator Pattern

The decorator pattern is one of my favorite patterns. It is simple, extensible and powerful. It feels like it follows the essence of object oriented programming beautifully. Sadly though, it is also easy to be misused or misunderstood. So, in this post I will show you the essence of the decorator pattern, illustrated with a […] View the full article

Beezwax Buzz

Beezwax Buzz

A Simpler Backup Script

Demo file: backup-simplified.zip (requires FM 18 or later) Like many developers I go back and forth between developing locally and in a hosted environment, and many years ago I posted a couple articles featuring a simple backup script to create on-the-fly backups when working on local files. Recently a colleague pointed out that this backup routine,… Continue reading A Simpler Backup Script View the full article

Kevin Frank

Kevin Frank

5 Top tips for working from home

Many of us are still unable to venture back to the office, or we’ve come to an agreement to work from home on a temporary to permanent basis. For some, this is fantastic news as working from the comfort of your own home is a gift to more than a few. But, as with anything [...] The post 5 Top tips for working from home appeared first on The Scarpetta Group, Inc.. View the full article

Joe Scarpetta

Joe Scarpetta

How to build a winning sales funnel

The concept of sales funnels is nothing new, but surprisingly many organziations either don’t have a clear funnel they adhere to or their funnel simply isn’t working for their specific customer base. We’ve talked before about how important it is to have every member of your team on the same page, moving towards the [...] The post How to build a winning sales funnel appeared first on The Scarpetta Group, Inc.. View the full article

Joe Scarpetta

Joe Scarpetta

OOP Fundamentals: The Dependency Inversion Principle

The dependency inversion principle is one of the cornerstones of object-oriented programming. Without it, there is no object-oriented design. It’s that important. What amazes me about this principle is that people can spend years working with an object-oriented language and never learn about it, never take the next step towards becoming a senior developer, especially […] View the full article

Beezwax Buzz

Beezwax Buzz

Getting the best from your team

A study by economists at the University of Warwick found that happiness led to a 12 percent boost in productivity, while unhappy workers were 10 percent less productive. The research team stated, “We find that human happiness has large and positive causal effects on productivity. Positive emotions appear to invigorate human beings.” We’ve all [...] The post Getting the best from your team appeared first on The Scarpetta Group, Inc.. View the full article

Joe Scarpetta

Joe Scarpetta

×
×
  • Create New...

Important Information

Terms of Use