tforbes

I need to calulate the mileage costs based on various rates within ranges of dates. For example, if the date of travel falls between July 1, 2012 and December 31, 2012 the travel cost value = .555, and if the travel date falls between January 1, 2013 and June 30, 2013 the travel cost value = .565 I have tried the following case function for the field <<mileage_cost>> with 2 records that contain the dates "12/12/2012" and 1/31/2013" respectively. The function returns the value ".555" for both cases, but should return ".565" for the second case. Case( travel_date > 6/30/2012; .555; travel_date > 12/31/2012; .565 )

So, I need to make the selection in the individual FMP file before uploading it to the server? I am at a remote site right now and opened the file via FMP. I can select the IWP radio button, but the check box to suppress the file name in IWP is not available.

Using FMP Server 10 Advanced and would like to suppress some file names on the IWP home page. I know how to do it using FMP client and IWP, but not when the files are hosted on the server.

I have now used it several times. Awesome! Here is the syntax where is the field: ValueCount(FilterValues((Grade);"7"))

I found that Explorer, Firefox, and Safari all have right-click options that allow for printing a single frame. Cool.

I found the answer to my question...at least in Firefox. In Firefox, in the print dialog box, the user needs to select "Frame > Each Frame Separately" then print to PDF. Open the PDF file and print only the frame with the desired data.

How do users print user defined reports from a URL in Instant Web Publishing? Printing in browsers includes the status box on the left of the layout.

Be sure that the entire tab panel and all its fields are in the body part and not overlapping into the header part. If a portion is in the header, you will get the behavior you described.

Thank you!

I want to create a function that works like "Countif" in Excel. For example, to count only the text value "7" in a series of cells in Excel I use: =COUNTIF(A2:Z2,7) which ignores any other text value and counts the occurrences of the value "7". In FMP how do I get the same result?

I am running FMP 5.5 in Classic environment with OS X.2. In the layout mode using a single mouse click/hold to select an element causes the selected element to duplicate, which makes trying to move an element with the mouse a very frustrating experience. The problem is occuring on 3 Macs: 2 desktop G4s and a laptop G3. Never had this problem in OS 9.2 before OS X.2.

Thank you. That makes sense. So what about the issue of not having access to the menu command to change the layour order? With full access privileges I had assumed that I would be able to control that function on served files.

I created a set of related files in FMP 5.5 and established access privileges and passwords for various level of access giving myself full administrtor privileges. When the files were moved to a server running FMP 5.5 server my administrator password is now treated as a guest and I cannot see the menu option for changing access privileges and passwords. Also, the "change layout order" is grey not allowing me to make chages. I called FMP tech support and was told that I must remove the files from the server to access adminsitrator privileges, make the changes, and replace the files on teh server. This seems rather crude for such an otherwise robust DB. Help.