User manual FILEMAKER FILEMAKER PRO 7

[. . . ] FileMaker Pro 7 User's Guide TM © 1995-2004 FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker is a trademark of FileMaker, Inc. , registered in the U. S. and other countries, and ScriptMaker and the file folder logo are trademarks of FileMaker, Inc. You are not authorized to make additional copies or distribute this documentation without written permission from FileMaker. [. . . ] The formats you specify don't change the data as it's stored in the database, and you can specify different formats each time you place a field on a layout (whether it's on the same layout or a different layout). For example, if you enter ­5123 into a number field, you can format it in one place to display as ­$5, 123. 00 and in another place as <5123>. FileMaker Pro applies field formatting in the following precedence: If you don't specify formats, FileMaker Pro displays numbers, dates, and times based on the system formats set in Regional Options control panel (Windows) or the International pane in the System Preferences application (Mac OS) when the file was created. Choose text attributes Select one or more styles 1 Specifying formats for fields containing numbers You can control how FileMaker Pro displays the values in number fields, calculation fields with numeric results, and summary fields. 1. In Layout mode, select one or more fields that display numeric 1 In FileMaker Pro, you can specify display formats for text, number, date, time, timestamp, or container fields with no objects selected. FileMaker Pro applies these default formats to fields you place on layouts later. For number, date, time, and timestamp fields, these display formats override the system formats. values. 2. In the Number Format dialog box, select the formats you want to use. You see examples of the options you choose in the Sample area. Choose options for Boolean or decimal numbers and currency Set options for displaying different Japanese numeral types Specifying text formats for fields In Layout mode, you can specify a set of text character attributes for each field. All the characters in that instance of the field (including all repetitions of repeating fields) share the same font, size, style, color, line spacing, tab, and paragraph settings. Note You can also format characters in text fields in Browse mode (for example, italicize or underline a word for emphasis). Unlike text formatting specified in Layout mode, this formatting is stored with the data, and you see it in any layout that displays that field. 1. In Layout mode, select one or more fields, then choose Format Set options for negative values menu > Text. Or, to set text formats for fields you place later, start with no fields selected. 2. In the Text Format dialog box, select the formats you want to use. Click OK. Define the symbols for thousands, decimal, and Kanji separators Specify font, style, size, line spacing, alignment, and color You see examples of the options you choose in the Sample area. Creating databases 57 Specifying formats for date fields You can control how FileMaker Pro displays the values in date fields, and calculation fields with date results. Note To avoid confusion when using dates in fields, FileMaker recommends that you always format date fields to display four-digit years. 1. In Layout mode, select one or more date fields or calculation fields Specifying formats for time fields You can control how FileMaker Pro displays time values in fields. 1. In Layout mode, select one or more time fields, or calculation fields with a time result. 2. In the Time Format dialog box, select the formats you want to use. with a date result. 2. In the Date Format dialog box, select the formats you want to use. You see examples of the options you choose in the Sample area. 4. Click OK. You see examples of the options you choose in the Sample area. If you want to format the seconds component to display fractional seconds, continue with the next step. 5. In the Number Format dialog box, select the formats you want to use. Choose to display numbers either as entered, in a predetermined format, or in a format you specify Choose options for day, month, date, year, and separator characters Only two options affect the display of the seconds component: Fixed number of decimal digits and Decimal separator. [. . . ] See Columnar list/ report layout Extended privileges described 82 viewing 89 External Server account 82, 88 F False result 26, 40, 46, 56, 97 Field behavior 59 Field definitions copying 16 creating 39 Field labels 55 Field names 39 Field rights. See Accounts; Privilege sets Field tool 54 Field types and calculation results 43 described 40 Field values deleting 22 described 14 entering and editing 22 entering automatically 45 finding and replacing 30 prohibiting change 45 Fields See also Calculation fields; Container fields; Date fields; Match fields; Number fields; Related fields; Summary fields; Text; Time fields; Timestamp fields adding to a layout 54 defining 39 deleting from a layout 55 described 13 displaying 9, 48 empty or non-empty, finding 27 entry options 44 formatting 56 Furigana in 41 global 47 indexing 47 maximum characters in 22 merge 55 naming 39, 41 options 41 placing on a layout 54 removing from a layout 55 restricting data entry 59 selecting 21, 53 stored and unstored results 47 types 40 typing in 22 validation options 46 File options 34 preferences 34 File formats, import/export 76 File references 15, 75, 84, 98 File sharing, enabling 74 FileMaker Pro documentation information 7 file format 76 product overview 9 versions 1. x and 2. x 96 FileMaker Server 73, 79, 87 Filename extensions for converted files 92, 94 fp7 15 Files accounts 82 backing up 34 cloning 16 closing 15 converting 91 copying 16 creating 38 described 14 duplicating 16 exporting to 78 opening 14 opening across platforms 15 planning 35 privilege sets 82 protecting 81 remote 14 saving 16 shared 84 on web 79 templates creating files 38 described 38 Find mode, described 17 Find requests See also Finding records adding new 28 broadening criteria 28 deleting 29 described 23 editing 29 102 FileMaker Pro User's Guide mixing find and omit 28 multiple 28 narrowing criteria 27 operators in 23, 26 order of 29 repeating 29 reverting 29 Finding and replacing field values 30 Finding records See also Find requests adding new request 28 all records 24 Boolean numbers 26, 97 described 23 duplicate records 27 empty or non-empty fields 27 exact values 25 excluding records 28 invalid values 26 logical AND searches 27 logical OR searches 28 multiple criteria 27 omitting records 28 order of requests 29 partial or variable text 24 ranges of information 26 related fields and records 27 showing all records 24 symbols 24 today's date 26 Footers, described 60 Form letters 55 Formatting calculations 56 dates 57 export data 78 graphics 58 import data 76 numbers 56 text 56 times 57 timestamps 58 Forms See also Layouts Standard form layout 49 viewing records as 17 Formulas, calculation fields 41 Found set described 17, 23 switching with omitted set 29 fp7 filename extension 15 Fraction of Total for summary fields 44 Full Access privilege set, described 83 Functions 42 Furigana field option 41 into existing files 76 source file or table 76, 77 target file 76 updating existing records 76 updating matching records 77 Indexing fields 47 text field limitations 25 Instant Web Publishing described 73, 79 sharing files 79 Intranet 79 See also Web Invalid values, finding 26 IP addresses, limiting 79 G Global storage options 47 Grand summaries, described 60 Grand summary parts, described 60 Graphics, formatting fields for 58 Groups. See Accounts; Privilege sets Guest account 83 J JDBC field name considerations 39 using with FileMaker products 7 Join expressions. See Match fields K H Handicapped access 8 Headers, described 60 Hiding records 29 Host database on web 79 described 73 FileMaker Server 73 performing tasks 75 saving files 73 Key fields. [. . . ]