Development Standards

This is a method of finding the number of pages in a report for printing "Page 5 of 8". Create a global number field "gLastPage" Include the script following script steps in you print script: Enter Preview Mode () <-- uncheck Pause Goto Record/Request/Page (last) Set Field (gLastPage, Status(CurrentPageNumber) On your layout place the text: "Page ## of <<gLastPage>>" -bd

Okay, i know this is a pretty simple question, (it has to be if i understand it!!!) but it seems to me that a lot of posters sometimes have problems with getting there scripts to end in the right database. Maybe one of you guys should right a FAQ about the different reasons it may be. . . just a thought yafreax

Problem: clicking on the "submit" or "find" button works, but when people press the return key the form doesn't work and an error is returned. Answer: This issue is discussed in the FileMaker Inc TechInfo article No. 104764. To reads the complete article go to http://www.filemaker.com/support/techinfo.html and enter the article number 104764. An excerpt from the article is posted below, but it is recommended that you check the orginal source for the latest info. ----- From: FileMaker TechInfo Article 104764 Visitors submitting a form via browser often hit the Return or Enter key instead of clicking on a Submit or Search button. However, the two actions do not always …

The "Send Mail" script step in FileMaker Pro 4.x is extremely useful, but FMP does not send the mail itself: it passes the message onto the default mail client program on the machine that is running the script. Unfortunately for Macintosh users, the only mail client software FMP4.x works with is Eudora and Claris Emailer. However there is a work-around that uses the "Open URL" script step and the "mailto:" URL type. The mailto: string can contain subject and body information as well as the recipient address. The Open URL script step passes the data onto the computer's default web browser instead of the email client. It'll work as long as the web browser can send mailto…

Is there a way to print the total number of pages. I want a report to have, at the bottom of each page, "page ## of __".

CDML tags are used to create custom html format files which FileMaker Pro's Web Companion uses to share your databases over the WWW. The custom format files are used as "templates" to control how the web pages appear and much more. CDML was first introduced with FileMaker Pro version 4. The CDML codes used with FileMaker Pro 5 are identical to those of FMP4 but FMP5 includes several new codes to extend the functionality. The definitive information about CDML codes is probably FileMaker's own CDML Reference. The CDML Reference is a list of all of the codes with syntax and basic usage examples. It is not a tutorial, but a complete concise reference. The CDML Reference is…

FAQ: What does Lasso offer that Web Companion doesn't? Is there a good reason to use Lasso rather than Web Companion? A: See the the following web page, which is an article written by the president of Blue World Communications (the publishers of Lasso) regarding the differences between FileMaker's Web Companion and Lasso: http://www.blueworld.com/blueworld/products/lassovsfmp4.html Chuck

quote: Why does a field in the portal repeat itself all the way down. And if I change it it changes all of the values? This is because the field with in the portal is local to the current database or defined to another relationship. The relationship of the field and the portal should match. The only time you would put a field that does not match the portal (or not related) would be the portal trick of masking or making elements disappear.

There are three main options for sending an email using data from FileMaker. 1: Use the Send Mail script step. When a script is run with this step, the email is composed and ready to be sent from your email application's out box. This step has the advantage in that it's the most straight forward to use from within FileMaker. You add the step to your script and specify which fields have the email address, subject text, body text, etc. The downside to this solution is that it only works with some email clients. On Windows it works with Microsoft Exchange or another email program that is MAPI (don't ask, I don't know what that means) compliant. On the Mac, it works w…

FAQ: How can I track when individual fields have changed? A: Check out this file from databasepros.com: http://www.best.com/~jmo/Field_Mod.sit It demonstrates a technique where the date that a field is changed is tracked using lookups. Chuck

FAQ: I'm having a problem setting up a relationship using a repeating field as one of the match fields. A: Repeating fields are (in computer years) an ancient holdover from the days of FileMaker Pro 2, before FileMaker was relational. It was often used to simulate what we might currently use a line items file for, storing similar information (such as quantity, price and cost in an invoice solution) in a single record. They allowed much of the flexibility of a relational database without actually providing relationships. After FileMaker Pro 3, however, repeating fields were mostly rendered obsolete, but they have been kept around so that if you bring a flat-file (non…

Global Fields are static to the end users machine. Each user on the network has their own set of global fields. Upon exiting, the last users globals will be saved on the server. More later - SD