Critical News
Bugs
*Update* Printing Large Documents in FMP 8.5 and Windows... UPDATE: The latest update for FileMaker, 8.5v2, resolves some of these issues. If you are experiencing problems with printing, an upgrade is recommended. Please keep in mind that this update is Windows only. Bug: In FileMaker Pro Clien...
Reviews
Comparison of CNS Audit Log and Nightwing Audit Log Two main audit tracking systems that have proven very proficient are the CNS Audit Log and the Night Wing Enterprises Audit Tracking System. CNS Audit Log: The CNS Audit Log uses two audit fields, one timestamp field, three custom functions, a...
FMStudio for Dreamweaver and FileMaker Quick Review: Anyone who has worked with Filemaker and PHP knows it can be very time consuming. The Developers at FMWebschool have come out with another product that can greatly increase your productivity. FMStudio allows Dreamweaver MX to dir...
FMSA and WPE Bug: In FMSA 8.0v4, under certain conditions, there is a case where FileMaker Server's connection to the web publishing engine goes deaf. This requires you to restart FileMaker Server about once every 2-4 weeks. This is a different from the we...
Tips
Link for Outlook 2003 Question: On Outlook 2003 for Windows does anyone have the link to the application you add to Outlook to prevent this message from coming up? Answer: Yes...here it is!
Carriage Returns & Linefeeds on a Mac  Question: I want to create an export file on the Mac which has to be uploaded into another system. The other system needs to have a full carriage return and line feed at the end of each record for it to pass validation. The Mac only puts ou...
Instance where Globals are still Required Question: Can I use a variable to store values from a Custom Dialog box? Answer: No. If using custom dialogs with input, fields--possibly globals--are still required to capture the input values. Variables won't work in that situatio...
Last Found Set Question: How do I script FileMaker to capture a found set, and then go back to that found set when required? Answer: Create a number field called foundSet and have a script that stores the set. The button simply calls: Replace Fiel...
Knowing what Table Occurrence you're on using the Data Viewer Quick TIP: When working on a complex solution with a fair amount of TO's and layouts, I have found that I would like to know the exact TO of the layout I'm working on. Many times I want to know this when I'm browsing and creating scripts. I ...
Record Open Count Quick TIP: "Record Open Count" is equal to the number of records in the current window that have not been committed. "Record Open State" is the state of the current record in the current window. If the state is "0" it means that the rec...
Cool Trick! Send IM messages through iChat from FileMaker (Mac Only) Quick TIP: Now FileMaker can send instant messages to any user via iChat on a Macintosh. This basic apple script was created by Damian Kelly, and is posted here with permission. This apple script requires the user that is being set a messag...
Finding the FileMaker Version via a Script Question: How can I have a script determine if it is IWP or FM client? Answer: Use this ... If [PatternCount (Get ( ApplicationVersion ) ;"web" )=1]    Go to Layout ..... Else    Go to Layout ..... End If Thanks, Steven Knight
How to integrate iSight Cameras into FMP 7/8 (Mac Only) Quick TIP: iSight can be integrated into FileMaker 7/8. The can be very useful for tasks like On-The-Go ID badge printing.
Quickly Search Relationships Question: I can quickly search the scripts and table/field definitions by printing them to PDF, then searching the PDF. How do I quickly search the relationships? For example, I want to find out if a field is used as a predicate in a relation...
Trouble Shooting
FileMaker Pro Help File Question: "FMP 8 Help File" - I have installed FMP 8 on MAC G4 with OS 10.3.9. When looking at the built in "Help" System, one or more of the screens come up blank. Answer: Check the Console, you might see an entry similar to this: ...
Reset "Publishing Engine Authentification" User And Password Question: I installed FileMaker 7 server advance with Web publishing Engine on a Windows 2003 server that was previously installed with the same setup but further uninstalled. I can now access the web publishing Administration Console, but wh...
FYI
Creating PDFs in the FileMaker Runtime Fact: FileMaker Runtime will not allow you to create PDFs (though the new PDF capabilities of FM8). This is not a bug. We know that FMI licensed (i.e. Paid) Adobe for the PDF code that is in FMP8. That's why it works so well. :-) However...
FileMaker Pro 8 Aggregate Functions Fact: In FileMaker Pro 8, aggregate functions evaluated from within a portal operate from the portal context. This allows you to select a portal row and perform a count to a table farther away and receive the count only for that portal row's ...
Cause of the Size Issue Question: Some PDFs created by FileMaker 8, specially those which graphics, and list views are bigger than when printing to PDF. Answer: FileMaker has not fully optimized the Acrobat encoding routines within FMP8. This is generally ...
IsEmpty() Question: why to use IsEmpty on a related key field that will never be empty (such as a serial number) verus IsValid?
Detail Discussion