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

Button Bar Segment Fun, part 2

This is a quick follow up to Tuesday’s article, and to avoid unnecessary repetition I will assume the reader is familiar with that material. Demo Files button bar segment fun, v3  (from part 1) button bar segment fun, v4 There were some things in v3 I wasn’t completely happy about, and I realized this morning… Continue reading Button Bar Segment Fun, part 2View the full article

Kevin Frank

Kevin Frank

Button Bar Segment Fun

Demo Files button bar segment fun, v1 button bar segment fun, v2 button bar segment fun, v3 Today we’re going to look at some ways single-segment button bars (SSBBs) can help produce dynamic column headings for list views and/or reports, with a goal of concentrating logic into the segment calculation and reducing schema dependencies elsewhere. This… Continue reading Button Bar Segment FunView the full article

Kevin Frank

Kevin Frank

May The Fourth – Yoda Translator

Happy Star Wars Day! I found this Yoda Translator from funtranslations.com the other day and decided it was the perfect time of year to put out a fun demo file for Star Wars Day. All you have to do is type your text in the first field and click Translate to get the [...] The post May The Fourth – Yoda Translator appeared first on The Scarpetta Group, Inc.. View the full article

Exploring Wordlespace with SQL and While

Recently we’ve discussed optimizing SQL queries in FileMaker, and had some fun with various SQL experiments. Today we’re going to explore some ways FileMaker can use ExecuteSQL and the While function to perform letter frequency and text pattern analysis on candidate words for the popular Wordle game. The list of words comes from https://github.com/tabatkins/wordle-list and… Continue reading Exploring Wordlespace with SQL and WhileView the full article

Kevin Frank

Kevin Frank

SQL Multi-Table & Miscellaneous Experimentation

INTRO Today we’re going to pick up where we left off last month, and today’s article will assume the reader is familiar with the material we covered last time (in SQL Multi-Table Query Optimization). This time we’re going to dig a little deeper into multi-table SQL queries, conduct some SQL experiments, and look at a… Continue reading SQL Multi-Table & Miscellaneous ExperimentationView the full article

Kevin Frank

Kevin Frank

SQL Multi-Table Query Optimization

Demo file:  sql-multi-table-query-optimization.zip Recently a colleague requested help w/ a SQL query that was performing slowly. I wrote back: Make sure there are no records open locally, i.e., on your machine, in the tables you are querying (for more information see this article by Wim Decorte: ExecuteSQL – The Good, The Bad & The Ugly)… Continue reading SQL Multi-Table Query OptimizationView the full article

Kevin Frank

Kevin Frank

Claris Connect integrates Eversign, FileMaker and more

Let’s talk about Claris Connect as the way to orchestrate data-driven workflows involving Eversign digital signatures, Claris FileMaker, Slack and a range of other possible platforms! Fabio Bosisio from Beezwax will walk through details for setting up these types of integrations. Eversign (and FileMaker) integration with Claris Connect Event link: https://www.meetup.com/claris-connect-meetup/events/283713457/Speaker: Fabio Bosisio, Beezwax DatatoolsDate: […]View the full article

Beezwax Buzz

Beezwax Buzz

The Benefits of Automated Testing

Software changes over time. Your company's web site this year does things you had no idea you needed two years ago. How can we keep the cost of change manageable? Automated testing is one way. Especially for large software projects, the practice of automated testing reduces the cost of adapting software to new business necessities.View the full article

Beezwax Buzz

Beezwax Buzz

JSONQuery at FM-DiSC

When / Who / Where On Friday, January 14, Steve Senft-Herrera and I presented JSONQuery at FM-DiSC (FileMaker Developers in Southern California). Useful Links Recording of the presentation: https://www.youtube.com/watch?v=dztdZrHdrUQ Current version of JSONQuery:  CF_JSONQuery_20211130_0120_PUBLIC.fmp12.zip Our recent two part in-depth interview series: JSONQuery, part 1 JSONQuery, part 2 Coming soon: Steve Senft-Herrera’s demo file from the… Continue reading JSONQuery at FM-DiSCView the full ar

Kevin Frank

Kevin Frank

The Human Resource – Beezwax Anniversary Edition

26 years in, a founding Bee reflects Julian Nadel is president and founder of Beezwax. He’s celebrating the 26th Anniversary of Beezwax with this update to his original Beezwax Blog post. In 2014, a colleague interviewed me about Beezwax; the interview transcript was the orginal basis for the article herein. It was then and still […]View the full article

Beezwax Buzz

Beezwax Buzz

Connecting Portals to JSON Arrays

Have you ever wished you could connect a portal to a JSON array? Portals and JSON arrays seem like they should be a natural fit, but FileMaker doesn’t offer us an obvious way to connect one to the other. (Why would you want to do this? One use case would be to provide dynamic scrollable… Continue reading Connecting Portals to JSON ArraysView the full article

Kevin Frank

Kevin Frank

Getting past Paywalls on a Mac with Safari

A Simple Solution to avoiding a paywall: Turn off Javascript in Safari (Safari Menu, Preferences, Security Panel, toggle 'Enable Javascript') and then the reload (Command R) the web page. Remember to toggle Javascript back on, because so much of the display of the modern web relies on it, that it really isn't very functional without Javascript turned on. This works for casual use, but if you find yourself avoidi paywalls often, you may want to go the next step. View the full article

Douglas Alder

Douglas Alder

Beezwax Wins Claris Excellence Award

Beezwax Recognized for Advocacy Excellence, Sharing Expertise and Passion with Customers and Developers In the Claris Community CUPERTINO, Calif. – Dec. 15, 2021 – Claris International Inc., an Apple company, named Beezwax Datatools Inc. as winner of the Advocacy Excellence Award as part of the Claris Excellence Awards for 2021, which honor Claris Partners and […]View the full article

Beezwax Buzz

Beezwax Buzz

Find My Present – Holiday Scavenger Hunt

‘Tis the Season….to have fun!   All the heavy lifting has been done on this one, all you have to do is use the app to create a fun family activity - no development skills (or purchase) required! This Scavenger Hunt is appropriate for all ages, so the Clues [...] The post Find My Present – Holiday Scavenger Hunt appeared first on The Scarpetta Group, Inc.. View the full article

Joe Scarpetta

Joe Scarpetta

JSONQuery, part 2

Continuation of interview with Steve Senft-Herrera [Editor’s note: the demo file and custom function have been significantly updated since part 1.] Demo file:  CF_JSONQuery_20211130_0120_PUBLIC.fmp12.zip KF: Welcome back Steve for part 2 of our JSONQuery conversation. SSH: Thank you, Kevin. KF: One thing we didn’t mention last time, because they were late-breaking additions, were the inequality operators.… Continue reading JSONQuery, part 2View the full article

Kevin Frank

Kevin Frank

Drop the Spreadsheets: Find Freedom and Increased Revenue

Are you looking for a way to manage your business that will free you from staring at spreadsheets all day? A solution that will help you better see what is happening with your business and help you figure out where you need to spend your time each day? Then l have a solution for [...] The post Drop the Spreadsheets: Find Freedom and Increased Revenue appeared first on The Scarpetta Group, Inc.. View the full article

Joe Scarpetta

Joe Scarpetta

OOP Fundamentals: Quick and Dirty Guide to Testing

This won't be a detailed post on every possible topic on object-oriented programming and testing, there are many books about that already. Instead, this will cover basics of testing, so you understand how and why we test, and you can adapt it to your own needs.View the full article

Beezwax Buzz

Beezwax Buzz

A fast, flexible Tableau Connector for FileMaker

Building a custom Tableau® Connector for Claris® FileMaker® enables faster, more reliable and more flexible connections between Tableau and FileMaker datasources, compared with the legacy Web Data Connector. For a number of Beezwax client projects, we’ve installed and deployed a Tableau Connector (aka “TACO”) for FileMaker. The TACO was built using the Tableau Connector SDK […]View the full article

Beezwax Buzz

Beezwax Buzz

The Value and Benefits of Transactions with Claris FileMaker

Let’s talk about Claris FileMaker and transactions! Join Vincenzo Menanno to discuss what transactions are, how they relate to FileMaker data operations (creating, updating, and deleting records), database normalization, and how to use transactional concepts to improve FileMaker performance, especially over a wide area network (WAN). This is a live, virtual event as part of […]View the full article

Beezwax Buzz

Beezwax Buzz

×
×
  • Create New...

Important Information

Terms of Use