Have you ever wanted to find records where a certain field is empty? Suppose you are updating your contact database and trying to capture email addresses for as many people as possible. You need to find every person for whom you do not have an email address. When searching in FileMaker, the equal sign operator (=) is used to find an exact match; when used by itself in a field, with nothing else following it, it tells FileMaker to find records where the field is empty. So… easy enough, right? Just go to the contact detail view, enter Find mode, type an equals sign into the email field (or select the symbol from the Operators popup in the toolbar), and click the Perform Find button.
The Support Group Blog
The Support Group Helps Mass Insight Help Schools
Mass Insight is a Boston-based group that works to benefit education and provide competitive advantages to schools on multiple levels. The organization is comprised of two segments: Mass Insight Global Partnerships, a consulting firm that unites schools, companies and government agencies for the purpose of building competitive advantage, and Mass Insight Education, a non-profit affiliate that works to improve public school performance in the maths and sciences as well as help to revive the schools themselves.
Like a lot of people, I am the proud owner of a shiny new iPhone 4S. Now, that may not sound unusual (I mean, Apple has sold MILLIONS), but the guys and gals I work with are saying “OMG!!!”
One of our customers recently needed a field to be both non-editable and scrollable in FileMaker Go. Here’s his request:
I need to build a system for someone to read a form on an iPad and capture their signature in a container field. The forms are of variable length and will change over time. So I want to put the body of the text into a field for each form for each signature. Since the form can be very long, the user will need to scroll to read the whole thing. But, when you click into a field, the keyboard pops up on the iPad. Is there away to suppress that?
Last week I presented a webinar titled Maximizing Mobility with FileMaker Go. As we prepared for the session, we encountered a challenge: how to best present the portion of the material that takes place on an iPad and broadcast it via WebEx.
Today I presented the webinar “Maximizing Mobility with FileMaker Go”, hosted by FileMaker, Inc.‘s Rick Colcock. Thank you to all who attended; if you missed it or want to check it out again, you can download the video.
iPhones and iPads have changed the way people work with information. When developing solutions using FileMaker Go, you’ll want to design your workflows and user experience to fit the way people create and consume mobile data. This session will cover useful tips and techniques to optimize FileMaker for mobile use. We will explore FileMaker development with an eye to adapting workflow patterns and user interaction to the mobile paradigm, as well as the new opportunities mobile devices present, such as geolocation.
A reader asks:
When developing for FileMaker Go, is it possible to write a script that does one thing if the iPhone or iPad is held vertically and another if it’s held horizontally? How it could be done?
“Yes we can!” (my son has been watching a lot of Bob the Builder). We need the Get ( WindowContentHeight ) and Get ( WindowContentWidth ) functions.
A number of clients have recently signed up for or renewed their Sapphire Maintenance Plan, and in talking about it, we realized that it’s not as well known as some of our other offerings. It’s an annual service and support agreement that provides you with ongoing access to a team of expert FileMaker Certified developers at a reduced rate.
There’s an old adage that shows up in many forms:
Smart people learn from their own mistakes; really smart people learn from the mistakes of others.
I’d expand that to include learning from one’s successes and the successes of others, as I’ve endeavored to teach my children many times over.
I’ve been in this business over 25 years and worked at Apple for a few years before that. Over that time, I’ve seen a lot of interesting customer experiences, good and bad, with some providing major life lessons the hard way. Most of these are simple in nature but reinforce what many of us know intuitively. The stories I want to share today relate to backing up.
Early in my FileMaker career, perhaps back in the first version of FileMaker, we were hired by a company selling and leasing commercial real estate. The company’s database contained information on properties for sale and lease, completed transactions, and a variety of reports summarizing data by office, district, region, sales person, month and quarter.