Please join Skeleton Key's FileMaker STL meetup, January 23, 2018, 6pm (CT). Colleague, Jeremy Upton, will present: "Alexa, ask FileMaker...". SK is Skeleton Key. SK is host to FileMaker STL Hey Siri. Hey Google. Hey Alexa...the holiday season was explosive with its ads for voice command devices. Wouldn't it be cool if you could say something like "Hey Alexa, ask FileMaker how many contacts live in the state of Texas?", and have the results of your FileMaker database said back to you? We think so too! And that's why we are excited to have Skeleton Key's very own Jeremy Upton lead the meetup topic this month.
Entries in this blog
We are excited to announce that, due to our continued growth, we are moving Brightsource IT and Skeleton Key to a new office space on August 21st.
Mark Richman, President, Greg Lane, VP of Application Development, and Application Developers: Chad Adams, Jay Sayers, Todd Stark, and Jeremy Upton, are headed to Phoenix, AZ from July 24-27 to participate in FileMaker, Inc.'s annual Developer Conference aka DevCon. They'll be staying at The JW Marriott Phoenix Desert Ridge, host hotel of more than 50 DevCon sessions. They will join over 1,500 FileMaker developers to network, catch up with colleagues. Primarily, they will take advantage of the variety of session tracks, to further their knowledge with tips, best practices, and techniques to continue building powerful business solutions for our clients.
Mark R., Greg L. and Chad A. will have the honor to host the following sessions:
- Tuesday, 7/25, 2:15pm, Grand Saguaro North: 7 Tips for Getting More out of FileMaker Cloud, with Greg Lane (Deployment Track)
- Wednesday, 7/26, 10:30am, Grand Saguaro East/West: The Power of Bidirectional Relationships, with Chad Adams (Intermediate Track)
- Wednesday, 7/26, 1pm, Grand Canyon 7: Security 101, with Mark Richman (Beginner Track)
- Wednesday, 7/26, 2:15pm, Grand Saguaro East/West: Introduction to SQL and ODBC for FileMaker Developers, with Greg Lane (Intermediate Track)
The FileMaker 16 Platform has launched and it's packed with great new features for both developers and users. We're excited about significant new features such as server-side PDF creation, card windows, the new Windows UI, enhanced data viewer, and native JSON functions. The platform also introduces several innovative features such as the FileMaker Data API, external script steps, OAuth 2 support, and region monitoring.
The new FileMaker 16 Platform is stronger than ever and we can't wait to start building with this great new feature set. Our team has written a series of blog posts to introduce some of our favorite new features. Check back soon for more posts.
FileMaker 16: Card Window by Jay Sayers
FileMaker 16: Layout Objects Window by Alan Kirtlink
FileMaker 16: New Windows Interface by Calvin Cooper
FileMaker 16: Data API by Todd Stark
FileMaker 16: Enhanced Data Viewer by Jay Sayers
FileMaker 16: Animations and Transitions by Chad Adams
FileMaker 16: New JSON Functions by Jeremy Upton (Coming Soon)
The FileMaker 16 Card Window is a new user interface tool which will not only make your application look better, it will help you reuse your layouts. Using the Card Window Style you will be able to display unrelated record data, related record data, and transform the look of currently viewed records. At the same time, it just might make window management easier.
Once upon a time FileMaker layouts were simple. Everything was visible all of the time and unless it was done by mistake, we never stacked objects on top of one another. Over the years however, a lot of features have been added to FileMaker to help us get the most out of small screens. These days we have tools such as tab controls, slide controls, pop-overs and object hiding that allow us to cram lots of objects into a small amount of space and show the users just those that we want them to see.
These features allow us to do things that used to be impossible, but with so many objects on a layout it can be difficult to find the one you are looking for. To help us with this, FileMaker 16 adds a feature called the Layout Objects window (LOW). Here's how it works.
With the release of FileMaker Pro 16 a great new feature has been introduced for those of us who use the Windows operating system. The FileMaker Pro 16 Windows interface has been redesigned to work more like the Mac OS version by now allowing multiple and separate windows! No longer will Windows users be limited to keeping all their layout windows within the FileMaker Pro application window.
Individual windows can now be resized independently. Each window also contains its own menu bar and status toolbar.
Windows natively has a window snapping feature when dragging windows to the sides of the screen. You can now effectively leverage this snapping feature with the changes to the FileMaker Pro 16 Windows interface.
REST comes to FileMaker
While we have been able to use plugins and the Insert from URL script step to consume data from other web-based systems using either SOAP or REST services, FileMaker did not have a native way to easily serve its data to other sites. There is custom web publishing, and ODBC connections, but that was still somewhat limiting when it came to serving data to other web-based systems from anywhere in the world. That all changes in FileMaker 16 with the introduction of the REST based Data API. Now your FileMaker solution can behave like any number of other databases from around the globe who have distinct APIs written for external users to consume the data.
The Data Viewer in FileMaker Pro 16 Advanced got some much needed attention with this release which can best be described as FAST! Its improved interface will have you working, testing and troubleshooting faster and easier thanks to the Auto-Complete, Search and Automatically Evaluate tools.
Since the addition of the Set Layout Object Animation script step and slide panels you have been able to mimic a slide transition while navigating from layout to layout. The cost of implementing this simple UI experience is a complication of your layouts that may be unacceptable.
FileMaker 16 vastly simplifies the process and at the same time adds many more transition options.
I recently tackled a request from a client to implement a back button that functioned similar in nature to the back button in a web browser. This is certainly not an uncommon request and a simple explanation as to why this isn't practical normally results in the client withdrawing their request. However, the customer was adamant that they wanted this functionality. So, I set out to design a solution for them and came up with a solution using snapshot links.
Our trainers are Certified FileMaker Developers, who have been developing custom solutions at Skeleton Key for many years. Please visit our webpage for information, dates, and to register.
If you have a website that connects to a FileMaker database, this simple tip might help improve performance.
top, right: Mark Richman; bottom, left to right: Calvin Cooper, Chad Adams, Greg Lane
Mark Richman, President, Greg Lane, VP of Application Development, Chad Adams, Senior Developer and Trainer, and Calvin Cooper, Developer, are headed to Las Vegas from July 18-21 to participate in FileMaker, Inc.'s annual Developer Conference aka DevCon. They'll be staying at The Cosmopolitan, host hotel of more than 60 DevCon sessions. They will join over 1,500 FileMaker developers to network, catch up with colleagues and take advantage of the variety of session tracks including core, design, innovation, mobility, business & web, to further their knowledge with tips, best practices, and techniques to continue building powerful business solutions for our clients. Mark, Greg and Chad will have the honor to host four of these sessions.
With the release of FileMaker 15 Server the Chrome browser on the Android operating system is now supported for use with FileMaker 15 WebDirect when using devices with a five inch or larger screen. I have spent some time testing this out and I've found that things seem to work as well as it does on the other platforms. However, during my testing I did come across something I found to be a bit odd and not quite as intuitive due to the variety of Android screen sizes and resolutions.
iOS has historically used whole number multipliers to scale to the native screen resolution. Using either a 2x or 3x multiplier they can scale the output resolution to the native screen resolution and keep all elements of the items large and legible on the device screens.
Android uses multipliers in the same manner as iOS, however the difference is that Android strays from simple 2x and 3x multipliers. Depending on the device resolution the multiplier may be anywhere from 1.3x to 3.5x! With the increasing density of new devices this problem is only going to get worse.
The post Sizing layouts for Android devices for FileMaker 15 WebDirect appeared first on FileMaker Development Company.
When FileMaker Go is running a script and the user locks the device or switches to another app, the script is paused and FileMaker Go enters a suspended state. Check out this video for a simple technique to allow a script to continue to run while FileMaker Go 15 is in the background. This can be a great way to help ensure a long-running script isn't interrupted by an impatient user.
Group Session #1
Hi. My name is Andy and I'm an API Addict.
In my defense, I have to say it's all Brian Dunning's fault. See, when I was first starting out with FileMaker, and discovered all that sample data on Mr. Dunning's website, I found I couldn't get enough. I was sorting, and parsing, and testing, and munging, and wrangling, and...and...and I just kept needing bigger and bigger datasets to "work" with. When I'd gone through the biggest one there, I realized I still needed more.
Our 2016 FileMaker training courses are scheduled!
Our trainers are Certified FileMaker Developers, who have been developing custom solutions at Skeleton Key for many years. Please visit each page for information, dates, and to register.
If you would like an individual invoice, please contact us. We offer a multi-person discount for companies that would like to send more than one trainee. Please contact us with interest in this discount. We offer on-site training for companies that qualify. Please contact us if you'd like training for your staff members at your company's location.
In a recent discussion at the FileMaker Community a question was asked about why a FileMaker developer would choose NOT to use SQL-friendly field names. It's an important question that I believe many FileMaker developers often answer incorrectly. Here's a bit about how my view of naming conventions has changed over time.
For reference, a SQL-friendly field name in FileMaker would be a name that:
starts with a letter
contains only letters, numbers, and underscore characters
is not a reserved word (an evolving list of over 200 words including DATE, FIRST, FROM, VALUE, ZONE, etc.)
Developers also often adopt naming conventions that use PascalCase, camelCase, or a variety of prefixes and suffixes to indicate properties of the field or alter the sort order of fields.
I was once in the camp that thought it was a best practice to always use these kinds of naming conventions to optimize developer productivity. I come from a computer science background with experience in dozens of different languages, each with its own arcane naming rules. Some of those languages were created when every byte was precious...many computers had just a few kilobytes of memory, data transfer rates were measured in bits per second, and programs and data were stored on punched cards or magnetic tape. I started using some amalgamation of the various rules I knew when I began using FileMaker in 1986. Over the years, my naming conventions evolved modestly as the FileMaker platform changed and I was exposed to other developers' code.
L5SimpleFM is a PHP package used to provide a simple, readable, declarative syntax for accessing data hosted on a FileMaker Server from a composer-friendly PHP project. The package also has a ServiceProvider class which allows it to be easily pulled into a Laravel 5 project.
Join us Tuesday, September 22, for a free one-hour webinar at 2pm (EST)/ 1pm (CST)/ 11am (PST), as Mark Richman presents Options for Licensing FileMaker Platform. During the webinar, he will explain the different options for connecting users to FileMaker solutions, and demystifies the various options for licensing the technology.
The post Join Us for FM Academy Webinar: Options for Licensing FileMaker Platform appeared first on FileMaker Development Company.
I ran into a situation recently where a user would not or could not remember to commit their changes before exiting their FileMaker Go solution on their iPad.
The truth is it's easy to complain that the user isn't using the system as it was intended. Complaining about the user doesn't really solve the problem, and we are problem solvers. This is custom software; it should work the way the user works, not the other way around.
In this case, the user was using an iPhone or iPad Mini. He pulls it from his pocket, opens a work order, adds some photos and notes, and then sticks the device back in his pocket. Then he does some work (like replacing a window in a building) and then takes some more photos of the completed repair.
Skeleton Key will be taking our 3-day Developer Essentials, FileMaker Training class to the Nashville, Tennessee area from Tuesday September 22 to Thursday, September 24.
The course will be hosted at:
Goodall Homes, 323 Maple Street, Suite 100, Gallatin, TN 37066
Seating is limited. Register ASAP, if you are interested in attending this training class.
The post FileMaker Training: Developer Essentials Class in Nashville, TN Area appeared first on FileMaker Development Company.