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

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

10 Top tips on small team efficiency

“Running a small team is easy”- words spoken by many a large team leader. For a team to work symbiotically, it’s not about the numbers, it’s about the actions taken. Sometimes this can be tougher in a smaller team because if one person is MIA there are fewer people to pick up the additional [...] The post 10 Top tips on small team efficiency appeared first on The Scarpetta Group, Inc.. View the full article

Joe Scarpetta

Joe Scarpetta

bBox for FileMaker v0.96 Now Available

We are pleased to release bBox version 0.96. bBox is a free utility plug-in to extend FileMaker solutions to easily use code libraries and macOS-based functions from Python, JavaScript, PHP, Ruby, AppleScript, Bash/sh, XPath, and SQLite. View the full article

Beezwax Buzz

Beezwax Buzz

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

Kevin Frank

3 Simple marketing hacks to attract more customers

We all need to market our services or products to gain visibility and encourage sales, but in order to optimize opportunities, you need to be seen by the right audience. Your target market should already be clear to you, but if it isn’t, try asking what problem your product solves and who most encounters that [...] The post 3 Simple marketing hacks to attract more customers appeared first on The Scarpetta Group, Inc.. View the full article

Joe Scarpetta

Joe Scarpetta

How to streamline your sales process

It goes without saying that you need sales in order for your business to survive. But for a business to thrive, you need to build fantastic funnels and streamline the sales process from start to finish (and after). We’ve got a post in the pipeline on how to build winning funnels, but for now, [...] The post How to streamline your sales process appeared first on The Scarpetta Group, Inc.. View the full article

Joe Scarpetta

Joe Scarpetta

JSON Currency Exchange Rates

Welcome back for another exciting round of JSON exploration. Last time we discussed a JSON-related bug fix in FM 19, as well as a free package tracking service that returns results in JSON format. Today we’re going to look at a free currency exchange rate service. Demo file: json-exchange-rates.zip I threw together this FileMaker front… Continue reading JSON Currency Exchange Rates View the full article

Kevin Frank

Kevin Frank

FM Quickstart 19

FM Quickstart 19 The latest version of FM Quickstart–DB Services’ free CRM app for FileMaker–is finally here! Our team has listened to feedback from FM Quickstart users, and have added some major new features including: Task List Calendar Sidebar Navigation Additionally, DB Services is excited to announce the launch of our FM Quickstart Implementation Plans! These new plans will help you get set up with your new FileMaker system using FM Quickstart, including user s

dbservices

dbservices in CRM

×
×
  • Create New...

Important Information

Terms of Use