- p 244. When printing, you may have something on a layout you don’t want printed. How do you achieve this?
a. Select object
b. FORMAT–>SLIDING/PRINTING
c. Click on the checkbox for DO NOT PRINT SELECTED OBJECTS.
- On what page are instructions for printing columns?
p 244
- How do you format what’s inside a FIELD, say, a CURRENCY?
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.
- How do you format a NUMBER?
Select the NUMBER FIELD and
FORMAT–>
NUMBER.
- NUMBER FORMAT: When should you choose to FORMAT AS BOOLEAN?
Use it when the field will have two choices only, like YES and NO.
- What are the choices for FORMAT AS BOOLEAN?
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.
- Where is the DO NOT DISPLAY IF ZERO option?
FORMAT–>
NUMBER:
FORMAT AS DECIMAL–>
DO NOT DISPLAY NUMBER IF ZERO.
- What are the limitations of the CURRENCY SYMBOL option?
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.”
- What are your choices for FORMATTING DATES?
Practically limitless. You can have a spelled out date in the Header and a shortened date in the Body.
- How do you format TIMESTAMPS?
There is NOT TIMESTAMP option, you format the DATE with the FORMAT–>DATE and the TIME with the FORMAT–>TIME command.
- In order for a TIMESTAMP field to show your settings, you HAVE TO:
FORMAT BOTH THE DATE AND THE TIME PARTS.
If either is set to “LEAVE DATA FORMATTED AS ENTERED,” FileMaker will NOT FORMAT THE FIELD.
- TIMESTAMP formats are a bit hard to read because the date and time are scrunched together. You solve this by:
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
