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

Layout Calculations in FileMaker 20.2

The recent release of FileMaker 20.2 introduces a feature that developers have long been asking for: the ability to define calculations at the layout level without resorting to workarounds (such as those we saw in Button Bar Segment Fun, part 1 and part 2.) You can read the official word(s) from Claris here… Inserting layout… Continue reading Layout Calculations in FileMaker 20.2View the full article
Kevin Frank

Kevin Frank

0

JSON Currency Exchange Rates, v3

Demo file: json-currencyapi.com.v2.zip This is a quick follow up to a pair of articles I published earlier this year, and will assume the reader is familiar with that material. JSON Currency Exchange Rates revisited JSON – Force Standard Notation Having first blogged about this back in 2020, I had hoped to be finished with this… Continue reading JSON Currency Exchange Rates, v3View the full article
Kevin Frank

Kevin Frank

0

Support Requests and Claris Connect

Support Requests and Claris Connect I am finally getting around to playing with Claris Connect and, to borrow the tagline from McDonalds, I’m lovin’ it! I am finding that I have to think a little bit differently to get my workflows to do what I want. My default logic is to step through [...] The post Support Requests and Claris Connect appeared first on The Scarpetta Group, Inc.. View the full article
Joe Scarpetta

Joe Scarpetta

0

Generating Spreadsheets with LibXL

Introduction From time to time FileMaker developers are tasked with generating Excel spreadsheet output. There are a variety of ways to accomplish this, in some cases via native FileMaker commands (Export, Save/Send Records), and in other cases using various workaround methods — some of which have appeared on this site in years past. Today we’re… Continue reading Generating Spreadsheets with LibXLView the full article
Kevin Frank

Kevin Frank

0

Maximize Your YouTube Viewing Experience with Time-Saving Shortcuts

YouTube has become a juggernaut since its launch in 2005. It is now by far the most popular platform for video consumption on the internet. Unfortunately, watching YouTube videos for their information content can sometimes be a frustrating exercise, especially when the content creators don't optimize their videos. Here are some tips and tricks to make your experience better.View the full article
Douglas Alder

Douglas Alder

0

JSON Custom Functions for FM, part 3

This article is part of a series. See also… •  JSON Custom Functions for FM 19.5, part 1 •  JSON Custom Functions for FM 19.5, part 2 Demo file: json-custom-functions-part-3.zip Note: some of these CFs make use of JSONGetElementType so require FM 19.5 or later. Disclaimer: use at your own risk, these CFs may contain bugs,… Continue reading JSON Custom Functions for FM, part 3View the full article
Kevin Frank

Kevin Frank

0

Historical Foreign Exchange Lookup in FileMaker

Scripts to look up Foreign Exchange rates seem to be something of a recurring item on this blog. It is because the Internet keeps changing and what worked last year, doesn’t necessarily work this year. Also, this time, I had a need for looking up foreign exchange rates on a specific date. I found another […]View the full article
Douglas Alder

Douglas Alder

0

A Fresh Approach to Deduplication

Editor’s Note: Today I’m pleased to present a guest article by Jon Rosen featuring a creative and performant approach to removing duplicate records. Recently, I had a situation where I had a found set of more than 500,000 records, but over ⅔ of them were duplicates. To remove the dupes, I initially went with the… Continue reading A Fresh Approach to DeduplicationView the full article
Kevin Frank

Kevin Frank

0

JSON – Force Standard Notation

Introduction This is a follow up to a behavior I mentioned last month where FileMaker’s JSON functions can transform a number into scientific notation when you might prefer to have that number remain in standard notation. Demo file: json-force-standard-notation.zip Note: demo file uses JSONGetElementType so requires FM 19.5 or later. The overall functionality of the… Continue reading JSON – Force Standard NotationView the full article
Kevin Frank

Kevin Frank

0

Off topic – OVUM, a Cool Music Gadget

Cory has had a passion for electronic music for quite a while and has bought and sold many electronic gadgets over the years and was noticing all the plastic and e-waste that gets produced. His goal with this project was to make something that made interesting music and when its life cycle is ended, can be taken apart easily and most of its components recycled. Hence the use of wood and aluminum in the design.View the full article
Douglas Alder

Douglas Alder

0

Creating a Custom Keyboard to Speed Boilerplate Data Entry

This could be useful for designing a custom set of text boilerplates to quickly add to an email or in a data entry situation. These panels allow you to create a set of custom buttons that can perform a variety of tasks, from typing pre-defined text to executing scripts or even launching applications. I realize […]View the full article
Douglas Alder

Douglas Alder

0

JSON Currency Exchange Rates revisited

Demo file: json-rates-via-api-exchangerate-host.zip Today we’re going to take a fresh look at pulling currency exchange rates into FileMaker, and this article is directly based on its predecessor. Why the re-visitation? Two reasons actually: The “free” endpoints I relied on back in 2020 (and in 2021 when I revised the original demo) have been monetized, and… Continue reading JSON Currency Exchange Rates revisitedView the full article
Kevin Frank

Kevin Frank

0

FileMaker to Google Translate for Longer Texts

ChatGPT is a better FileMaker Programmer Than Me So, I decided to ask ChatGPT to re-create the script that I had worked so hard on. In a few seconds, the way it does, it came back with a much simpler way of doing the task.View the full article
Douglas Alder

Douglas Alder

0

Claris Studio (part 4): Forms the easy way!

About the author: Beverly Voth has been in the Claris FileMaker community many years. In addition to FileMaker Pro and its integrated products, she is a Full Stack Web developer & SQL database administrator. The only recipient of the FileMaker Excellence Award for Outstanding Contribution to the FileMaker Web Publishing Community (DevCon 2003), she’s been… Continue reading Claris Studio (part 4): Forms the easy way!View the full article
Kevin Frank

Kevin Frank

0

AI-Written Javascript Paywall Jumper

With plenty of time and patience, I might have been able to figure this out myself after much searching for code samples and tweaking to get it to work. Instead, I asked the AI-based ChatGPT to write me a bookmarklet. In 30 seconds, I had my response. I added the Bookmarklet and it works! Call me pretty impressed.View the full article
Douglas Alder

Douglas Alder

0

A Summary Field Bug and Workaround

Introduction Recently a client asked me to implement a virtual list reporting framework similar to the one I wrote about a few years ago in Virtual List Simplified. I added the framework to the client’s hosted file, and things went smoothly until I ran a report similar to the one shown below… and observed that… Continue reading A Summary Field Bug and WorkaroundView the full article
Kevin Frank

Kevin Frank

0

Simple Pick Lists in FileMaker Pro

Download Demo File Recently, I was explaining the Pick List technique for a friend and thought there might be a good example online, but couldn’t find one, so here is my version. This is a pretty simple technique and can be adapted to many different aspects of a solution. Whenever you want to get data […]View the full article
Douglas Alder

Douglas Alder

0

Claris Studio (part 3) – Spreadsheet: Details, please!

About the author: Beverly Voth has been in the Claris FileMaker community many years. In addition to FileMaker Pro and its integrated products, she is a Full Stack Web developer & SQL database administrator. The only recipient of the FileMaker Excellence Award for Outstanding Contribution to the FileMaker Web Publishing Community (DevCon 2003), she’s been… Continue reading Claris Studio (part 3) – Spreadsheet: Details, please!View the full article
Kevin Frank

Kevin Frank

0

Unite Hacks 2022 Hackathon

Who doesn't love a good hackathon? Unite Hacks, a 12-hour, student-led, in-person hackathon is happening this weekend in Oakland, CA. We can't wait to see what these talented developers can build.View the full article
Beezwax Buzz

Beezwax Buzz

0

GitOps with GitHub Actions

Originally presented at Beezwax's internal Developer Show and Share meeting, this video presentation covers "GitOps with GitHub Actions" by Victor Olivo, Beezwax DevOps Engineer.View the full article
Beezwax Buzz

Beezwax Buzz

0

Design Think Your Code

Have you ever opened an existing solution, took one look at the source code - and your eyes just glazed over - as if you were attempting to decipher the Matrix? You’ve entered the world of DX, or “Developer Experience”. Consider these Design Patterns for your next solution, with the audience beyond the UX, to also include the DX.View the full article
Beezwax Buzz

Beezwax Buzz

0

Claris Studio (part 2) – Integration with Claris Pro

About the author: Beverly Voth has been in the Claris FileMaker community many years. In addition to FileMaker Pro & its integrated products, she is a Full Stack Web developer & SQL database administrator. The only recipient of the FileMaker Excellence Award for Outstanding Contribution to the FileMaker Web Publishing Community (DevCon 2003), she’s been… Continue reading Claris Studio (part 2) – Integration with Claris ProView the full article
Kevin Frank

Kevin Frank

0


×
×
  • Create New...

Important Information

Terms of Use

  I accept