


It’s important to note that this is a function that you cannot undo! Be sure that you know what you’re doing with your data. Choose Edit, Find/Replace to open the Find/Replace dialog box (see Figure 2.41).Place your cursor into the field in question.Choose Records, Show All Records otherwise, your change is applied to only your current found set.To quickly take care of migrating from an old value to a new one, follow these steps: Enforcing the consistent use of terms is important in maintaining your data integrity. For example, perhaps you’ve changed a value list of vehicle types to read “auto, bike, boat, plane,” rather than “bike, boat, car, plane.” If you leave things alone after changing the value list, you’ll have both “car” and “auto” data in your system. You’ll often run across cases in which you need to globally replace some data with other data.


A second click re-sorts in descending order. Don’t forget that clicking a column header sorts for that column. This gives you a bird’s-eye view of your information. But if you just need to look at the raw data in your system, you can opt to change to Table view from any layout in FileMaker Pro, assuming that your developer hasn’t disabled the option. User interfaces have their purpose and more often than not greatly assist data entry and working with a given solution. FileMaker’s online help details all the key commands available. You’ll become much faster with FileMaker Pro if you take the time to learn your key commands. (Command-up arrow) and (Command-down arrow) page through your data. The (Return) key executes default values in dialog boxes, performs finds, and so on. Entering (Command-F) brings you into Find mode. Technique 1: Using Your Keyboard for More Speed In working with a developer, you can guide that person’s priorities (or your own) based on a solid understanding of the platform. This helped greatly for future estimating.īecoming adept at using FileMaker Pro enables you to understand what information you can pull from the system, but, most important, it enables you to know what to ask for. For example, in our consulting firm, we were able to analyze our time entry data and calculate the average amount of time we need for testing. Manipulating data can illuminate a wide range of information and can allow business users to draw conclusions they might not have been able to perceive anecdotally. Learn More Buy FileMaker Extra: Becoming a FileMaker Pro Power User
