[Forums]  [Store]  [Cart]  [Resources]  [Learning]  [About]  [Solutions]  [Consulting]  [News]  [Links]

Questions s Coffee cups indicate the complexity of a file, tip or article. One coffee cup is the easiest and three is the most advanced. To download a file, click on the green arrow icon next to the listing. If there are no coffee cups or platform icons, the listing may be an article, Quick Tip, Knowledgebase or bonus file.

Displaying 1...10 of 52 Resources found  [Another find]
Date Search Techniques    Beginner   Quick Tip    Version 11
New FileMaker 8 Date Search Techniques
Some of the new date search features in FileMaker Pro 8 are just what I've always wanted. For example, you can type in a range of "Monday...Friday" or "Mon...Fri" to locate all weekday dates. Or, you can use wildcards to locates all dates on January 1st, regardless of the year, by typing "1/1/*". You can use curly brackets to specify a range of months, such as "{1...6}/*/* to locate all the birthdays in the first 6 months of the year. Try these same wildcard techniques with time fields too. Play around with these tools, and I'm sure you'll be impressed with the flexibility. And let me know if you figure out some combination of these new features that let's you accomplish some really cool technique.
Indexing    Intermediate   Quick Tip    Version 11
How Indexing Works on a Text Field
FileMaker Pro indexes every word in a text field so that finds can be performed quickly. Think of the analogy of a book. Rather than trying to locate something by thumbing through each page, you look in the index and find all the pages numbers at once. FileMaker works in the same way. In order to make finds as fast as possible, the first 100 characters of every word is indexed. If you click into a field and type Command-I (Macintosh) or Ctrl-I (Windows), you can view the index of a field. Most characters are indexed but you may be surprised what characters designate a new word other than a space. The index does take up space, so if a field is not going to be searched on or used as a match field in a relationship, set the Storage Options in Manage Database to never index that field.
Interactive PDF Woes    Beginner   Quick Tip    Version 12 New
Common Issues with Interactive PDFs
A lot of people wonder why the Insert PDF option is dimmed or greyed out under the Insert menu even when they have a container field selected. The two most common reasons, other than installation issues, are the interactive option is not checked and the container field is in a portal. Start by going to layout mode, click on the container field and display the Inspector. Navigate to the Data tab and scroll to the bottom to see if “Interactive Content” is selected. If the Insert PDF option is still not available, it is likely your container field is in a portal and interactive PDFs are not available for size and performance reasons. Consider inserting the PDF as a file. It can still be opened with your favorite PDF reader using the Export Field Contents step but won’t be interactive inside FileMaker.
Portal Pop    Intermediate   Quick Tip    Version 11
Eliminate Portal Pop in FileMaker Pro 7
In FileMaker Pro 6 and earlier versions, portals scroll back to the top row whenever you click outside the portal (e.g. into a field). This behavior is disconcerting for users who wish to keep the currently-scrolled position of the portal while they work somewhere else on the record. FileMaker Pro 7 solves this huge developer request right out of the box -- except in one scenario. If you click on the layout where there are no fields or type the Enter key on the keypad, the portal will still pop back to the top row. To eliminate this behavior: enter layout mode, open Layout Setup from the Layout menu, and then Uncheck the option to "show field frames when record is active". While this will remove the dotted or dashed lines around fields when a record is active, most developers add enough interface to make it easy to locate fields anyhow.
Recovering Files    Intermediate   Quick Tip    Version 11
The Proper use of Recovery
For some reason, many FileMaker developers think you can recover a file and continue using it. Well, you can if you want to live your life dangerously. Recover is a great tool when used properly. The proper use of the Recover feature is to recover a file and then import the recovered data into a backup of the file which is not damaged. In other words, the Recover feature is for recovering your data not your schema. Even with the new recovery features in FileMaker 10, always remember that FileMaker assumes you are recovering a file because you have no other choice. Therefore, the Recover feature will remove any suspect scripts, fields, layouts and other features it believes could be causing the problem. While the Recover feature could completely fix your file, it's also possible it may not remove all corruption even though the file appears to be functioning properly. For more information on recovery, see the white paper titled "Demystifying FIleMaker Pro File Recovery" by Steven Blackwell, available in the Resources area of this web site.
Un-Maximize      Quick Tip    Version 11
Setting the Restored Window Size
Many developers call the Toggle Window [Maximize] script step on startup when deploying FileMaker Pro solutions on the Windows platform. Since FileMaker cannot lock the window in the Maximized state (due to Microsoft guidelines), the window will become Restored (or Unmaximized) whenever another FileMaker file is opened -- often to an undesirable window size that obscures the interface and leads to user confusion. To define the size of the Restored window, call the Toggle Window [Zoom] script step during the startup script before the Toggle Window [Maximize] step. The Toggle Window [Zoom] step will size the right and bottom sides of the window to the object that is farthest to the right and bottom on the layout. Depending upon your interface you may want to define a utility layout which contains one object in the position the window should size to.
Container Comparison    Intermediate   Quick Tip    Version 12
Compare Two Container Fields
FileMaker Pro can actually compare two container to see if they are equal. A true or false or false result is returned. This can be handy if you are trying to create a multi-state or conditional button. FileMaker Pro is also smart enough to realize that the same graphic is used on multiple layouts or records and should only be stored once. This saves file space and speeds up the display of graphics.
Creeping Labels    Beginner   Quick Tip    Version 12
Stop Labels from Creeping up the Page
Does the information on your labels creep up or down such that the last labels on the page are at the top of the label? The most-likely reason the labels are creeping is due to the Body part being too big or too small. However, let's start with the first row of labels. Does the first row of labels hit exactly where you want it to? If the labels are too low, decrease the size of the Header part. If they are too high, increase the size of the Header part. Once you have your first row printing correctly, move on to the rest of the rows. If they are creeping up, you need to make the Body part bigger. If they are creeping down, you need to make the Body part smaller. When you change the size of the Body part, any change is multiplied over the number of rows of labels you have. Change the Body size as much as the difference in position between the first and second rows of labels and all the labels should adjust correctly. It may take a few tries.
File Maintenance    Intermediate   Quick Tip    Version 11
The Differences Between File Maintenance Tools
FileMaker 7 and 8 have three methods for optimizing files. The Save A Copy As feature is available in FileMaker Pro, Developer and Advanced. This feature allows you to save a compacted copy but not like WinZip or Stuffit. A compacted copy is a duplication of the file compacted and optimized. FileMaker stores data in blocks and, when information is deleted, those blocks may become partially full. Compacting a file merges partial blocks, so there are fewer and fuller blocks -- thus creating a smaller file. Optimizing a file is a lot like optimizing your hard drive. Blocks are swapped so that data in records are grouped together. Scripts, Fields and other areas of FileMaker are also optimized to increase performance by allowing similar data to be accessed sequentially. The File Maintenance feature in FileMaker Developer 7 and FileMaker 8 Advanced simply splits these two tasks into separate features. The big difference is that the File Maintenance feature works on the current file, so you don't have to swap out the old copy for the new one.
Record Locking    Intermediate   Quick Tip    Version 11
How Record Locking Works in v7
In FileMaker 6 and earlier versions, record locking occurred when a guest on the network clicked into a field. That's was all that was required to prevent others from changing the record. Unfortunately, this also prevented other guests from copying data from a locked record and other basic features. FileMaker 7 has changed how record locking works. In order for a guest on the network to lock a record, he must actually modify a field, allowing user to work with a record without locking it. However, the most important change is when scripting for record locking. You don't want to test if the record is locked by setting a field to a value. FileMaker 7 introduces the Open Record/Request script step which attempts to lock a record without modifying it. If the record is locked, an error of 301 will be returned. If the record is not locked, this script will lock it until the Guest exits the record manually or the Commit Record/Request script step is intiated.


Digital Fortress Where Internet solutions grow Database Pros recommends Digital Fortress for Colocation of your Web Server!