Filemaker Pro 9 (32)

Question 1

1. p 244. When printing, you may have something on a layout you don’t want printed. How do you achieve this?

Answer 1

a. Select object
b. FORMAT–>SLIDING/PRINTING
c. Click on the checkbox for DO NOT PRINT SELECTED OBJECTS.

Question 2

2. On what page are instructions for printing columns?

Answer 2

p 244

Question 3

3. How do you format what’s inside a FIELD, say, a CURRENCY?

Answer 3

FileMaker has a special FORMATTING dialog box for TEXT, NUMBER, DATE, TIME, and CONTAINER.
TIMESTAMP is a DATE and a TIME together, so it is formatted with those options.

Question 4

4. How do you format a NUMBER?

Answer 4

Select the NUMBER FIELD and

FORMAT–>
NUMBER.

Question 5

5. NUMBER FORMAT: When should you choose to FORMAT AS BOOLEAN?

Answer 5

Use it when the field will have two choices only, like YES and NO.

Question 6

6. What are the choices for FORMAT AS BOOLEAN?

Answer 6

a. SHOW NON ZERO AS, which shows up if the field has a NON ZERO VALUE, such as 1 or 5 or 34. This may be designated as a YES.
b. SHOW ZERO AS shows only when there’s a 0 in the field. This may be designated as a NO.

Question 7

7. Where is the DO NOT DISPLAY IF ZERO option?

Answer 7

FORMAT–>
NUMBER:
FORMAT AS DECIMAL–>
DO NOT DISPLAY NUMBER IF ZERO.

Question 8

8. What are the limitations of the CURRENCY SYMBOL option?

Answer 8

It is limited to five characters, BUT YOU CAN TYPE ANYTHING YOU WANT INTO IT, i.e., “boxes” so what is displayed is ‘100 boxes.”

Question 9

9. What are your choices for FORMATTING DATES?

Answer 9

Practically limitless. You can have a spelled out date in the Header and a shortened date in the Body.

Question 10

10. How do you format TIMESTAMPS?

Answer 10

There is NOT TIMESTAMP option, you format the DATE with the FORMAT–>DATE and the TIME with the FORMAT–>TIME command.

Question 11

11. In order for a TIMESTAMP field to show your settings, you HAVE TO:

Answer 11

FORMAT BOTH THE DATE AND THE TIME PARTS.

If either is set to “LEAVE DATA FORMATTED AS ENTERED,” FileMaker will NOT FORMAT THE FIELD.

Question 12

12. TIMESTAMP formats are a bit hard to read because the date and time are scrunched together. You solve this by:

Answer 12

Making a CUSTOM FORMAT with 
"    at"  (space-a-t)
 in the LAST PLACEHOLDER, so you get:
Fri, May 6, 2005     at 12:30pm
and NOT
Fri, ay 6, 2005at12:30pm