FileMaker 12 is here and with it comes a new file format. Follow these simple rules and you should have no issues, only joy.
When writing a FileMaker script to perform a find, sort, or export, doing it manually first can save you LOTS of time. Development manager Jeremy Kipling describes one way.
How to get word wrapping to indent the second line, and all lines thereafter, for a standard, edit-box text field
Extended privileges are probably one of the most underused features in FileMaker and at the same time incredibly simple and powerful with regards to enforcing security and access control.
Sometimes an empty field isn't really empty, but instead means that a related record doesn't exist. Here's how to search for those instances.
Our customer wanted to suppress the virtual keyboard in FileMaker Go when scrolling through a read-only field with many paragraphs of text. The solution? Using a web viewer instead.
When developing solutions using FileMaker Go for iPhones and iPads, you'll want to design your workflows and user experience to fit the way people create and consume information on the go. View the webinar with Chad Novotny.
To check to see whether you are holding your iPhone or iPad in portrait or landscape orientations, use the Get ( WindowContentHeight ) and Get ( WindowContentWidth ) functions
Scripted Quick Find and error 401 can leave seemingly inaccurate results.
A reader wants to know why some toolbar buttons are disabled in FileMaker 11, and how to fix them. The culprit? Custom menus.
A reader asks why a calculated full name is being exported as the number 0. The answer is probably that pesky calculation result type.
A reader asks how to create a portal paging system -- instead of showing a portal with the scroll bar, buttons take the user to the first, previous, next, and last set of records in the portal -- using filtered portals in FileMaker 11. Senior Developer Jud Wolfskill demonstrates a solution.
When it comes to FileMaker Pro, calculations and scripts are your tools to "make stuff happen." In this webinar, we explore some techniques for building robust, feature-rich databases with complex calculations, powerful scripted automation, and elegant user interfaces.
Conditional formatting can be a convenient tool for pointing out new database functionality for your users.
Display the running count of records in a portal, and summarize number fields with running totals.
Sometimes you want to convert a field with multiple values (paragraphs) into multiple records, each with one value. What if you have multiple such fields? In this article, we examine a script to take any number of fields and create all manner of combinations for records.
View the recording of Chad Novotny presenting on integrating FileMaker with Google Apps contacts, calendars, and more, and download the sample files to see how it all works.
While FileMaker Go can't directly access the iPhone's GPS, you can use a web viewer and Mobile Safari's geolocation features to map your location.
We have a bunch of really smart FileMaker developers here at The Support Group who can do some clever stuff with FileMaker. To find out just how clever, our Development Director ran a contest for the entire technical staff to see who could build the fastest Sudoku puzzle solver using FileMaker. This is the result.
A reader asks: "What is the best way to create a script that loops through all selected records?"
Creating a watermark for a report that prints across multiple pages is easy, if you remember that only part of an object needs to be in the header for it to print on every page.
Ever wanted to display event records in a calendar format? Of course you have! And FileMaker Pro 11 makes this so much easier with filtered portals.
FileMaker Pro 11's new OnObjectValidate script trigger provides us with the ability to control and massage data in ways we couldn't before. While this trigger is often thought of as a way of adding additional limitations and restrictions on data entry beyond the built-in validation options, you can also use it to ease and allow more flexible data entry.
FileMaker 11's filtered portals exist don't really cooperate with aggregate calculations, as those calculations aren't "aware" of the filter. Here's a simple technique to summarize the rows ina filtered portal, using summary fields instead.
FileMaker Pro 10 introduced Set Field By Name step, allowing you to use a calculation to choose the field to be edited. But where's Set Variable By Name? Here's how to dynamically name a variable using Let() and Evaluate().
When working with dates, it's often useful to be able to find the preceding Sunday. Here's a method for finding any given preceding day of the week.
Use the Get(ApplicationVersion) function to test for users using Instant Web Publishing.
You can use FileMaker Pro Advanced's custom menus to set a default for which records to print.
Make sure you understand how FileMaker Pro 11's Quick Find feature works and what fields you're actually searching.
Highlighting the active field with conditional formatting requires the simplest formula in the world, but HOW to use it is not so obvious.
FileMaker 11 introduces three new functions, but two seem awfully familiar...
We're busy updating our blog with past tips and tricks from our Get ( Answers ) newsletter.