Version 2.0 of fmLog – Free Download

Imagine this scenario:
At 4:47 p.m. Fred in sales opens the company’s FileMaker system and navigates to the contact list layout. He selects a contact and clicks a button to print a report of communications in the last three months. A beach ball icon spins for a few seconds, but nothing prints. Assuming something is wrong with the printer, Fred submits a ticket with the IT support desk and goes home for the day.

The next morning, Carrie in marketing wants a list of contacts added to the database in the last month. She logs in and perform a find, but strangely, no contacts show up. She tries again a different way, but gets the same result. Manually scanning the contact table confirms her suspicion: the records are missing. She submits an urgent support ticket to have the most recent backup restored. As the developer of the database, you receive this request minutes later.

Read More

Card Windows: Display Layouts from Another File

With the release of FileMaker 16 came the Card Windows feature, one that I’m still really excited about – seriously! You can read more about them here, but in this post we’ll be covering their ability to display layouts from external files.

This can be accomplished in two ways, depending on what type of information you are trying to display. The Go To Related Record script step (which we’ll cover first) can easily be configured to display related data from another file using a layout that already exists in that other file. This is a great time-saver if you already have an established relationship between the tables in each file. For a nearly limitless method, we can use the New Window script step to open any layout existing in another file (not just the related data) with a few extra steps. This second option is especially useful for modularization in your solutions.

Read More

Get(UUIDNumber) is here – how does it compare to Get(UUID)?

With the long list of new features being released in FileMaker Pro 17, one item that piqued the interest of my inner geek was this new function:  Get( UUIDNumber ). This new function is useful because now you can store your UUIDs in a Number data-typed field instead of having to use a Text data-typed field.  My hypothesis is that storing Numbers in the database will take up less space in the file. (I’m not sure where I got that notion, but it’s stuck with me for a while now…perhaps it was the Tech specs from an older version, where it described the minimum size needed to store numbers vs. text.)

Read More

June 6th Portland FileMaker Meetup

It was good to see folks again this month, for another meeting at AppWorks command HQ.  (I missed last month’s meeting, unfortunately. I was looking forward to hearing the stories from Pause on Error.)  Here are some of the highlights.

There are big changes in the licensing of FM 17.  AppWorks’ own Shawn Prado has a thorough article covering that topic.  When you purchase a 5-user license you get 3 copies of Server now.  That raised an interesting question: Does this mean you can put one of those on FileMaker Cloud with the BYOL option, instead of buying one through the FM Cloud interface?  It used to be that when you used the BYOL option your server license would get converted to FMCloud and NOT be returnable to standalone server installations at a later date if you moved off the cloud.  This then led to some discussion on hosting and server environments.

Read More

FileMaker Pro Advanced 17 Training – Six-part Series for Beginner and Intermediate Levels

AppWorks is offering FileMaker Pro Advanced 17 Training a six-part series at the beginning / intermediate level.

The format will be instructor led with plenty of hands-on development. Bring a specific project to work on if you can, and you’ll have made great progress during the classes. We will be using FileMaker Pro Advanced 17.

Read More