Pivot Tables in Xojo and FileMaker

Screen Shot 2019-02-07 at 10.45.15 AM
Pivot Tables will change how you view your data. Recently, I was working with someone who opened an Excel document and created a Pivot Table with the data. I was immediately in shock how fast and easy it was to visualize the data from different perspectives. Read More…

Xanadu for Xojo on GitHub

Xanadu for Xojo is now available on GitHub!

Next week I'm speaking at the Xojo Developer Conference about "Database Driven Apps". The session will show how we're using Xojo to build multi user Apps where users access CRM type data such as Contacts, Invoices, and more. In the session, I will discuss "Making Xojo Database Apps Easier for Everyone, especially for FileMaker Developers" in the form of Xanadu, a Xojo Web App. Read More…

Developing Affordable and Scalable Apps with Xojo
I've been using Xojo since Version One of what was then called REALBasic in 1998 and have created a bunch of apps since then. At first, I wrote shareware apps and the occasional app for the companies I worked for. In the past two years, I've realized that I can use Xojo to create Multi User Web Apps for small businesses that are incredibly affordable due to Xojo's rapid development and licensing focused on developers, not users. Our team has been developing solutions mostly using FileMaker for the past two decades, but we've had Xojo in our back pocket and never realized it. Here are some reasons why we like Xojo so much…
Read More…

Rethinking Software Interfaces - Art Licensing Manager 3 - FileMaker to Xojo Rewrite

We started on Art Licensing Manager 3 a bit more than year ago, but our attention was needed on another project to rewrite a FileMaker solution to a Xojo Web App. We're getting back to working on ALM3 now which also happens to be a FileMaker to Xojo rewrite.

We'll get into the why and and discuss our journey starting with this post. Read More…

FileMakerAddict Interviews CampSoftware's Hal Gumbert

FileMaker Addict: FileMakerAddict Interviews...
Hal Gumbert

Read More…

FMSnippets for TextExpander 1.1 Released

From our Press Release:

Read More…

FMSmallBusiness Updated to v1.2.2

FMSmallBusiness - History | CampSoftware - FileMaker Development and Small Business Software by FileMaker Certified Developers: "2009/03/21 v1.2.2

Read More…

FMSmallBusiness Updated to version 1.3.1 - Adds FileMaker 10's iPhone Web Interface!

Today we released version 1.3.1 of FMSmallBusiness (FMSB) which includes twenty five updates including new items, improvements, and updates.

The most exciting item is the use of the FileMaker 10 Server PHP Site Assistant which generates iPhone interfaces for FileMaker databases, like FMSmallBusiness. Videos and Screenshots [dead link] of FMSB are available including screenshots of our updated iPhone interface.

Read More…

FileMaker Server Backups using Dropbox!

If you have a FileMaker Server, you know how important it is to make offsite backups. The problem is setting it up. This technique should make it easy!

Read More…

FileMaker and Mac OS X 10.6, Snow Leopard Issues

Mac OS X 10.6, Snow Leopard is shipping today. This is what we know about the FileMaker issues in plain English. See the links below for the details. Email us with any suggested changes to this...

Read More…

FMSmallBusiness updated for Mac OS X 10.6. Improves Email Sending and iCal Exporting


FMSmallBusiness - History: [dead link]

2009/09/01 v1.5.2 [3 Items] Note: Some Features are FileMaker 10 only. The next version WILL require FileMaker 10.

Read More…

A QuicKey to Quickly Export a FileMaker XML DDR


Yesterday, I recorded a QuicKey to export a FileMaker XML DDR. It automatically chooses the menu item, changes to XML, and unticks auto open, then clicks create leaving you at the save dialog.

Read More…

FileMaker Products and Windows 7

Tomorrow Windows 7 will be released and FileMaker just released two support documents which may help if you plan to use Windows 7 in the near future.

Windows 7 and FileMaker 10 products

Read More…

PauseOnError Portland Audio Download

The FileMaker PauseOnError Portland unconference ended a few hours ago. Below you can download audio files for the sessions that I attended exported from my Pulse Pen. PauseOnError rocked! Well worth traveling the 2500 miles from Orlando!!!

Read More…

Teaching FileMaker to Send Alerts to an iPhone


Recently I had the need to send alerts to my iPhone from my FileMaker system. I started using Twitter, and while that works ok, the alerts would get lost in my twitter stream. I needed something that would make different sounds based on what kind of alert was coming in.

I found a super simple solution. And it was almost free!
Read More…

FileMaker Clip Manager Monkey


Learn how to create FileMaker fields and script statements in seconds with Clip Manger from myFMbutler and a bit of FileMaker code. This example uses FileMaker code to create FileMaker code!

Read More…

FileMaker Type Ahead with FMSnippets and Spell Catcher


For some time now, FMSnippets has been fantastic for speeding development. Typing out simple abbreviations as save us so much time rather than pointing and clicking or typing out the functions.

Read More…

Generate FileMaker Favorite Hosts XML


I was looking at copy and pasting over forty of the Favorite Hosts from FileMaker 10 to FileMaker 11. While I ended up having to copy and pasting them out of FileMaker 10, I created a simple FavHosts.fp7 database to generate the XML portion of the FileMaker Preferences File.

Read More…

CampSoftware holds FileMaker 11 Certification.


Last week, we took the FileMaker 11 Certification Exam and now we hold certification in FileMaker 7, 8, 9, 10, and 11.

Read More…

FileMaker Template for Developing iPad Apps


Today we completed development on our FileMaker Template for Developing iPad Apps. All it needs now is your business data. We started this template to save development time for ourselves and for our clients. The first app will be a Surgical Procedure Log.

Read More…

Ray Cologon's FileMaker UltraLog Modified to use XML


Dr. Ray Cologon is a genius. He really is. He's created so many amazing FileMaker Demo files over the past several years. As listing of many of them is available on his Australian website:

Read More…

Location Search for FileMaker and IWP Web Interface


This week we created a fantastic solution using FileMaker for a client that needed a Location Search added to their website. Their customers would call the the office and ask 'where are your locations in my city'. The locations were in their FileMaker database, but they had no way to make that information accessible to their customers.

Read More…

FileMaker Go for iPad and iPhone



Today, FileMaker released FileMaker Go for iPad and FileMaker Go for iPhone! We're extremely exited to have this available. This year, we're going to see FileMaker in so many places now that it can become so portable.

Read More…

FMSmallBusiness (FMSB) on iPad FileMaker Go - First Glance


Today, we launched our flagship solution, FMSmallBusiness on FileMaker Go. Looks amazing and most items are working well too!

We've tried it with our database, but please be careful testing your database. FileMaker Go does not have the entire set of features that FileMaker on your computer does. Please read the list of the known issues.

Read More…

FileMaker 8 Upgrade Path Ending

If you are using FileMaker 8 or Filemaker 8.5, the upgrade path will be ending on September 30, 2010. After that date, the upgrade price will no longer available. To move up to the current version of FileMaker it will need to be purchased at the full price.

Read More…

FileMaker Go 1.1.1 - Updated with 5 Fantastic Features


Today FileMaker Go was updated to version 1.1.1 with several amazing features. Download FileMaker Go for iPad and iPhone. From the press release and the the kb with comments in bold. If you'd like to implement any of these, get in touch.

Read More…

Signature Capture FileMaker Implementation Details

John Sindelar suggested that I include some more details about our FileMaker Pro/Go Signature Capture Method.

Read More…

Faster FileMaker Development with Clip Manager and FastScripts


Watch the Video in HD...

Read More…

QC Signature Capture for iPad, iPhone, Mac, and Windows


Read More…

FileMaker Runtime Installer For Windows

This week we take a look at a quick and simple way to distribute FileMaker Runtime Solutions for the Windows Operating System. Using Inno Setup you can create a one-click installation process that can make distributing your runtime solutions a breeze.

Read More…

CampSoftware's Signature Capture in FileMaker eNews Issue 5


Today we were pleased to see that our FileMaker Signature Capture solution was profiled in the FileMaker eNews.

Read More…

iBusiness Issue 1 - Faces Of FileMaker


We began writing about FileMaker in the i.Business Magazine to get more information about FileMaker in the hands of small businesses that need to hear about FileMaker.

In the first issue, we discuss several ways FileMaker can be accessed.

Read More…

PauseOnError 2011 NYC Audio Download


Alex Brophy and I attended the FileMaker PauseOnError 2011 NYC and brought our Pulse Pens. We thought you may like to listen to the sessions that we attended.

Read More…

Automate PDF Printing from FileMaker


We had the need for sometime to automatically print documents with our document management system using SuperContainer. In the past, we'd open the documents so the person using the system could print.

Read More…

FileMaker Go 1.2.1 Released with Printing, Signature Capture, and Charts


This morning, FileMaker Go was updated to 1.2.1 for both iPad and iPhone. Download or

The 'What's New' list included the following items. Looking at the list, you can definitely see the focus on adding what is needed to increase productivity and what enterprise customers need.

Read More…

Backup your Hosted FileMaker Database Backups via FTP with Transmit


While we backup the FileMaker databases on our server every hour of the day, we've been bad about backing up our FileMaker databases from our hosting provider, Foxtail Technology. Don't get me wrong! Foxtail creates backups for us automatically, but when it comes to backups, I want and need a copy of the backups at my disposal. Most hosting providers will let you download your backup files via FTP, so this solution addresses that need.

Read More…

GoLaunch Mentioned in TechNet eNewsletter!


Thanks FileMaker! Our GoLaunch solution [dead link] was mentioned in the May FileMaker eNewsletter!

GoLaunch [dead link] makes it easy to to create iOS device home screen buttons that let you launch your FileMaker Go databases with a single tap!

Read More…

FileMaker Web Publishing PHP Deprecated Messages


While working on a FileMaker/php project recently we came across an interesting situation. Though our solution was connecting to our database properly and displaying the data we requested we were seeing a lot of Deprecated Messages being returned by the FileMaker API.

Pasted Graphic

If you’re running PHP 5.3 or greater there are several methods in the FileMaker API that are deprecated, that is, they won’t be supported in future versions of PHP. While it’s good to know that your solution may have some trouble down the road right now it’s a bit of an annoyance to see all of the deprecated warnings. It also makes debugging a touch difficult.

The good news is you can turn all of the deprecated messages and still be able to see the rest of the errors that you will need for debugging. In the head of your document (or in a file that’s included in every script) add these lines of code:

This little snippet should hide the deprecated messages and still give you the notices and errors that you need to build and debug your site.

Read More…

Controlling Safari from FileMaker


This week we needed to gather data from a website and store the result into a FileMaker database running on Mac.

Everything worked great when we manually tested it in Safari, so when we tried it in using the FileMaker Web Viewer we were surprised that the page would not load as it did in Safari. We also considered the script step 'Insert from URL', but that wouldn't work since navigation of the site is required.

Read More…

Controlling Microsoft Word from FileMaker


We're working on a project for a client who gathers and formats data in a FileMaker database. The goal was to create a complexly formatted PDF file where the main content needed to be two columns. So, we tried a few things and found that Microsoft Word could format data in two columns very easily.

Read More…

FileMaker 12 - Internal SQL Code Formatting


One of the new features in FileMaker 12 the ability to perform SQL Select statements against FileMaker data. SQL Select statements can be simple and can easily get complicated and difficult to read. This is just one way to make it SQL statements easier to read.

Read More…

FileMaker Go Power Entry


A client needed a method to quickly input voltage reading into FileMaker Go on iPad and David Burton came up with this method of entering the data. The key was to not use the built in iOS keyboard, but rather provide on screen buttons that offer probably choices.

Read More…

FileMaker Automation with iClip and QuicKeys

Sometimes while developing FileMaker databases, we need to perform repetitive tasks, but you can save time by using tools to automate!

Read More…

FileMaker Scripting & Calcs. Now in Color!


Which do you like better:


Read More…

Spawning FileMaker


Brian Schick posted on Twitter a link on how to open additional instances of FileMaker, or any other application on your Mac. This was also mentioned at PauseOnError this week several times.

Read More…

FileMaker 13 is Available


FileMaker Inc released FileMaker 13 today! From the press release...

Read More…

Send Twitter Searches to a Google Spreadsheet


IFTTT ( If This Then That ) added the ability to send Twitter searches to a Google Spreadsheet.

This will let you store tweets of things that interest you. I have one set up to store FileMaker Tweets.

Read More…

FileMaker Related Field Updater / Storing Unstored Fields


NOTE: We really like this method, but it won't work in FileMaker Go since it requires an Extension. If the ExecuteSQL function had INSERT, UPDATE, and DELETE or if we could run a script in the calculation engine, this would work.

For years, we’ve had problems with Filemaker unstored Fields. Don’t get me wrong, unstored fields are great for having related data available in related FileMaker tables. However, unstored fields don’t work so well for Finds, Sorts, or Relationships.

Read More…

FMEasyWeb with FileMaker Layouts


Tim Dietrich and I have been experimenting with the FileMaker and the Web recently using Custom Web Publishing. One thing led to another.

Read More…

Reference for FileMaker App for Made with Xojo

refere ceforfilemaker

Last week we released Reference for FileMaker our iPhone / iPad App that makes looking up FileMaker details quickly.

Not only is it one of our first apps, it's one of the first iPhone / iPad Apps created with Xojo! Xojo is really amazing. With it, we can create real apps for Mac, Windows, Linux, Web, and now iOS ( iPhone / iPad/ iPod ). Xojo is also working on adding Android to the list, but no dates have been set for the release date.

Read More…

DBObservers for FileMaker Developers Interested in Xojo


Always Learning

We've been using Xojo since 1998 and are still learning about it all the time such as the Observer Pattern. Last year, Paul Lefebvre posted about the Observer Pattern.

Read More…

Moving from WordPress to FileMaker

Pasted Graphic

Time to Move

Yep. We moved from WordPress to FileMaker. It sounds insane, but it's working great all due to FMWebFrame by Tim Dietrich. Of course we didn't do this overnight and without reason. Our site was running on Wordpress and while it was working, we noticed that it was sluggish and we had added several plugins for things we really didn't need. It was time to simplify.

Read More…

WARNING about FileMaker 13.0v9 Security Update


FileMaker released an important security update yesterday. However, you REALLY need to devise a plan to install the update.

The short story is DO NOT UPDATE FileMaker Pro or Go UNTIL you update FileMaker Server. If it's not done in the right order, you'll find yourself NOT ABLE TO CONNECT to your database.

Read More…

FileMaker 14 Has Been Released


We'll be blogging more about this next week. For now, we suggest that you don't upgrade for at least a month until we see if there are any issues with the new release.

Read More…

Looking at FileMaker 14 a Month after the Release


FileMaker 14 was released a month ago and it's a nice update. Here's what we found interesting...

Read More…

ALM v3 - Conversion of a FileMaker Runtime to a Xojo Web App


Getting Started

This is the beginning of a series of posts discuss converting our Art Licensing Manager product that runs as a FileMaker Runtime to a Xojo Web App. We'd love suggestions, feedback and more than willing to answer any questions about the process. We plan to get into a little detail, but not too much and some sample code.

Read More…

Art Licensing Manager v3 - EasyData2 Database Model for Xojo

Summer Vacations and Thinking

It's been a few months since the last post about converting the Art Licensing Manager to a Xojo Web App. It's been a busy summer between working on projects for clients, going on RV camping trips, and thinking about the best way to convert our FileMaker Runtime to a Xojo Web App. One of my favorite 'work' days this summer was working on the web app from our travel trailer campsite while enjoying the weather.

Read More…

Excited Labels for Xojo which could also work in FileMaker

Field Labels can be Excited

Just like a microwave excites water molecules, you can excite your field labels.

Normally we all place field labels to the left of our fields but that takes up a ton of space. That works and will continue to work, but when I was visiting last night I saw a very nice animated way to handle a field label.

Read More…

Export FileMaker Tables to JSON

FileMaker to Xojo

We're still working to convert the Art Licensing Manager, our FileMaker Runtime based solution, to a Xojo Web App. It's a high priority for us since FileMaker Runtimes are listed to be deprecated, although we have several years as building Runtimes are available in FileMaker version 14 and will also be included in the 'next' version according to FileMaker Inc. We plan to have the Art Licensing Manager 3 available well before then.

Read More…

Xojo Background HTML Named Color Styles Generated from FileMaker

Xojo WebStyles

Xojo Styles are VERY powerful. Specifically, we're using Xojo WebStyles for our Web Apps. You can define just about everything you need. Below you can see a Style that defines that the background for the color '6495EDFF' which is also known as 'Blue Cornflower' as an Official HTML Named Color.
Read More…

Trees for Representing Referrals and Marketing Sources in Xojo and FileMaker

Fuzzy Vision

For some time, we struggled with how to visualize word of mouth referrals and marketing sources for one our favorite clients. We knew that both word of mouth and the advertising were doing something, but it was hard to see the which was stronger with standard reporting tools. Read More…