& (ampersand) operators, 254
* (asterisk) wildcards, 694
+ (plus sign) operators, 254
- (hyphens), layout names, 132
abbreviations, decoding, 438-439
Abs functions, 272
absolute paths, 587-588
abstraction (scripts), 294
access logs, IWP, 695
access privileges, troubleshooting, 399
Access via FileMaker Mobile extended privilege, 391
Access via FileMaker Network extended privilege, 391
Access via Instant Web Publishing extended privilege, 391
Access via ODBC/JDBC extended privilege, 391
Access via XML Web Publishing extended privilege, 391
Access via XSLT Web Publishing extended privilege, 392
accessing
Amazon.com Web services, 681
custom functions, restricting, 466
plug-in names/version numbers, 824-825
Accounts and Privileges menu
Extended Privileges tab, 698
Privilege Sets tab, 698
Accounts tab (Define Accounts & Privileges dialog)
user account security, 378
user accounts, reviewing privilege sets, 380
ACID tests, 355-356
atomicity, 356
consistency, 356
durability, 356
isolation, 356
Actions option (Synchronization button), 847
Active Directory servers
FileMaker Server registration, 814-817
registration, troubleshooting, 827
Add Account script step, 399
Add Table Occurrence icon (Relationships Graph), 237
adding
external ODBC data sources to Relationships Graph, 620
fields to layouts, 152-153
files to runtime applications, 773
layout objects to layouts, 137-138
merge fields to layouts, 157
pictures to layouts, 139
portals to layouts, 498-499
related records to master records, 207
search paths to file references, 236
tables to multitable systems, 199
Admin access, removing via Developer Utilities (FileMaker Developer), 775
Admin accounts, user-level internal security, 379
Admin Console, 802
Administration section, 804-805, 808
scheduling feature, 806-808
statistics, monitoring, 808-809
Configuration section, 810
database cache, RAM allocation, 812
web publishing settings, 812
CWP URL requests, troubleshooting, 746
FileMaker Server, 804
access, troubleshooting, 746
launching, 802
passwords, troubleshooting, 398
WPE access, troubleshooting, 746
Advanced Web Publishing Options dialog (IWP Database Homepage), 693
aesthetics (report design), 322
aggregate functions, 276
Align command (Arrange menu), 147
aligning layout objects, 147
All Modifiable setting (Edit Privileges dialog), 387
All No Access setting (Edit Privileges dialog), 386
All View Only setting (Edit Privileges dialog), 386
Allow Creation of Records in This Table via This Relationship option
Edit Relationships dialog, 207, 501
Portal Setup dialog, 503
Allow Deletion of Portal Records option (Portal Setup dialog), 500
Allow Exporting dialog (Edit Privileges dialog), 389
Allow Printing dialog (Edit Privileges dialog), 389
Allow User Abort scripts, 298
Allow User Abort setting (IWP), 704
Allow User to Modify Their Own Password option (Edit Privileges dialog), 390
Allow User to Override Data Validation Warnings option (Edit Privileges dialog), 390
Also Reduce the Size of the Enclosing Part option (Set Sliding/Printing dialog), 149
Alternate Background Fill option (Part Definition dialog), 137
alternating row color in reports, 321
Always During Data Entry option (Validation dialog), 109
Always Lock Layout tools option (Layout mode), 138
Amazon.com, Web services
accessing, 681
HTTP requests, 681
importing data to FileMaker, 682-685
ampersand (&) operators, 254
And filtered portals, 508
and operators, 254
Apple iPhone, specifying style sheet, 848
application flow, IWP, 708
creating file links, 710-711
explicit record commits, 709
hiding status area, 709-710
portals, 710
session management, 708
application logs, IWP, 694
script errors, 695
Web publishing errors, 695
applications, ODBC, 604-605
Arrange menu (Layout mode)
Align command, 147
Bring Forward command, 148
Bring to Front command, 148
Distribute command, 147
Move to Back command, Tab Control objects, 152
Object Grids command, 143
Resize To alignment tools, 142
Resize To command, 147
Send Backward command, 148
Send to Back command, 148
array functions, 455
GetValue functions, 456
LeftValue functions, 456
troubleshooting, 474
MiddleValues functions, 456
troubleshooting, 474
RightValues functions, 456
troubleshooting, 474
stepping through, 457
usage examples, 456
ValueCount functions, 456
troubleshooting, 474
arrays
elements, navigating, 457
text arrays, passing multivalued script parameters, 481
Asian-language double-byte language support, 115
asterisk (*) wildcards, 694
atomicity (ACID tests), 356
attributes (database design), 165-166
join entities, 182
process analysis, 190
versus entities, 167-169
audit trails, 362
auto-entry techniques, 363-366
troubleshooting, 368
blank rows, troubleshooting, 365
meta data, 362
rollbacks, 366
script-controlled editing, 362
timestamps, 362
authentication
external authentication security, 396-397
IWP accounts/privileges, 700
user authentication security, 395
Auto Update feature (FileMaker Server), 820
auto-entry options (fields), 102-103
Calculated Value option, 105
calculation formulas, 253
Creation option, 103
Data option, 105
Looked-Up Value option, 105-106
Modification option, 103
Serial Number option, 104-105
Value from Last Visited Record option, 105
Auto-Entry Options dialog, Do Not Evaluate If All Fields Are Empty option, 365
automatic logins, user-level internal security, 379
Automatically Create Indexes as Needed check box (Indexing option), 259
AutoUpdate directories
building, 821
folder naming structures, 822
AutoUpdate plug-in
enabling, 822
FMSUAC_FindPlugin function, 823
accessing plug-in names/version numbers, 824
FMSUAC_UpdatePlugin function
downloading plug-ins, 825-826
error codes, 823
FMSUAC_Version function, 823
Available Menu Commands option (Edit Privileges dialog), 390
Average of function (summary fields), 101
background colors, layout parts, 135
Backup at HotSync option (FileMaker Mobile), 841
backups
open files, 788
scheduling, 808
FileMaker Server maintenance, 829
BASIC file format (exporting data), 655
bidirectional relationships, 224-225
binary search technique (debugging scripts), 578
bind keys, adding/replacing files in runtime applications, 773
Bindkey option (Solution Options), 773
Blank Layouts, 123
blank rows (audit logs), troubleshooting, 365
Book icon
Layout mode, 138
Status Area, 42
Boolean formulas, 252
Choose functions, 438
bound runtime applications, adding/replacing files, 773
branching scripts, conditional script steps, 305-306
break fields, 330
subsummary reports, 333
breakpoints (scripts), 578
Bring Forward command (Arrange menu), 148
Bring to Front command (Arrange menu), 148
Browse mode
dependencies, table context, 568
list reports, 318
Status Area, 41
Browse mode, 43
IWP, 711
building
AutoUpdate directory, 821
buttons, 311
custom function libraries, 475
customizable list reports, 440-448
field matches, 221
HTML-formatted search result stylesheets, 738
URL format, 738-739
many-to-many relationship structures, 212
multiple find requests, 728-729
one-to-many relationships, adding tables to multitable systems, 199
relationships with global values, 229, 232
script libraries, 313
web site with XSLT Site Assistant, 733-734
xslt-template files, modifying, 737-738
windows, troubleshooting, 547
Button Definition dialog, accessing, 153
Button Setup dialog, Current Script option, 528
buttons, 46
building, 311
fields as, 153
calculated replaces
fields, calculation formulas, 253
scripts, 563
Calculated Value option (field auto-entry options), 105
Calculation Context section (Specify Calculation dialog), 260-261
calculation fields, 60, 98-100, 250
data types, 257
troubleshooting, 280
global storage, 259
indexing, 259-260
number of repetitions, 257
calculation formulas, 250
auto-entry options (fields), 253
calculated replaces (fields), 253
context, specifying, 260-261
debugging, 436
field names, troubleshooting, 279
field validation, 252
record-level security, 253
script steps, 252
legibility, 255
selecting fields, 254
selecting functions, 255
selecting operators, 254
calculation functions
Exact function, 267
Length function, 266
PatternCount function, 266
Position function, 266
Substitute function, 268
Trim function, 267-268
WordCount function, 267
Calculation Result Is feature (Specify Calculation dialog), 99-100
calculations
comments, 556
debugging, 560
nontext, troubleshooting text formatting functions, 473
slowness (performance), 562
table context, 567
writing tips, 280-282
calendars
Drop-Down Calendar option (Field/Control Setup dialog), 154
portals, creating via, 505
camel case, 555
Cancel buttons, designing dialog windows, 527
candidate entities, 168
capturing
errors, troubleshooting, 368
record locking in scripts, 359-360
cardinality
entity relationships, 174
Relationships Graph, 201
in fields, 155
transformations (exporting data), 653
Cartesian product relationships. See cross-product relationships
cascading deletions (portal records), 502
case altering functions, 268
Case statements, conditional functions, 275
CDML (Claris Dynamic Markup Language) configurations, converting, 599
Ceiling functions, 271
centering layout objects, 147
change Password script step, 400
changing FileMaker 9 modes, 44
character transformations (exporting data)
BASIC file format, 655
carriage returns, 653
CSV format, 654
DBF file format, 654-656
DIF, 654-656
Excel file format, 655
FileMaker Pro file format, 655
HTML Table format, 655
Merge format, 655
repeating fields, 653
SYLK format, 654
Tab character, 653
tab-separated text format, 654
WKS file format, 654-656
XML file format, 655
charting subsummary reports, 341
Checkbox Set formats (fields), 56
Checkbox Set option (Field/Control Setup dialog), 154
child entities, 173
child records, 67
related parent data, 210
Choose functions, 437-439
Closing Splash Screen option (Solution Options), 774
closing/opening files, troubleshooting, 399
code, writing
comments, 555-556
naming database files, 553
naming fields, 554
naming functions, 555
naming layouts, 554
naming parameters, 555
collection lists
employee tables, example of, 17
flat files, 19
phone directory flat files, example of, 18
relational databases, 18-19
color
background colors, layout parts, 135
reports, alternating row color, 321
Columnar List/Report layouts, 122
columns
highlights, repeatable fields for, 327
multi-column layouts, 128
subsummaries, 130
trailing grand summaries, 130
viewing, 130
sortable headers, 324-327
ascending/descending logic, 328-329
commands (custom menu components), 422
Comment dialog (field definition dialog), 555
Comment text box (Define Database dialog), 89
comments
fields,
adding to, 95
viewing in, 89
proactive troubleshooting, 555-556
scripts, 292-293
viewing, 555
Commit button (IWP status area), 709
Commit Record/Request script step, 360
Commit Record/Request step (IWP), 704
committed data
records, 54
versus created data, 357
comparison operators, find command, 727
completing scripts, Allow User Abort scripts, 298
concurrency, 355
ACID tests, 355-356
atomicity, 356
consistency, 356
durability, 356
isolation, 356
conditional formatting, 429
conditional functions, 274
Case statements, 275
conditional privileges, 385-386
conditional script steps, 305-306
loops, 308
troubleshooting, 312
conditional tests, Choose functions, 437
Configuration section (Admin Console), 810
database cache, RAM allocation, 812
web publishing settings, 812
Configure button (FileMaker Mobile), 847
configuring
custom function accessability, 466
custom function availability, 466
databases for CWP, 719-721
external authentication services for FileMaker Server, 820
field access, 154
field data entry guidelines, 155
FileMaker databases for ODBC, 605, 607
FileMaker Server for automatically updating plug-ins, 822
IWP, 695
plug-ins, 781
portals, 203
Conflict Resolution option (Synchronization button), 846
connecting to FileMaker Server with PHP Site Assistant, 755-756
connectivity, troubleshooting
Crosstalk, 564-565
server connections, 563-564
consistency (ACID tests), 356
Consistency Checker (FileMaker Server), 788
constrain requests, 74
Constraint Found Sets, 74
constructors, Time/Date/TimeStamp functions, 273
Export Field Contents option, 61
exporting data, 659
Import option, 61
Insert option, 61
IWP restrictions, 707
OLE support, 61
Paste option, 61
preparing for Web Publishing Engine, 752-753
saving/retrieving information in, 61
context, troubleshooting, 566
layout dependencies, 566
record pointers, 569
table context, 566-568
Continue buttons, designing dialog windows, 526
controls, adding to Web Viewer, 411
converted files, building databases, 239-240
converted passwords, troubleshooting, 398
converting web-enabled databases, 599
CDML configurations, 599
IWP configurations, 599
Copy command (Preview mode), 568
Copy script steps, 301
copying/pasting
fields, troubleshooting, 159
layouts, 124
objects, 140-141
open files, 788
corrupted files, troubleshooting, 81
Count functions, 276
Count of function (summary fields), 101
Create setting (Custom Privileges dialog), 384
created data versus committed data, 357
Creation Account Names fields, 107
Creation option (field autoentry options), 103
Creation Timestamp fields, 107
cross-platform layouts, building, 160
cross-product operators (x), portals, 496
cross-product relationships, building, 232-233
CrossProduct functions, 470-471
crosstalk
troubleshooting, 564-565
multiple files, 235
CSV (comma-separated text) format (exporting data), 654
Current Record Numbers (Status Area), 42
Current Script option (Button Setup dialog), 528
custom development software, 16
custom dialogs, scripts, 309-310
custom functions, 461
access, restricting, 466
automatic updates, 463
availbility, configuring, 466
comments, proactive troubleshooting, 556
complex formulas, simplifying, 462
CrossProduct functions, 470-471
Hypotenuse functions, 467
libraries, building, 475
NthRoot functions, 467
PadCharacters functions, 469
parameters, naming, 555
Quarter functions, 467
recursive functions, 464
refactoring, 463
RepeatText functions, 468
system constants, defining, 463
TrimChar functions, 470
WeekEndingFriday functions, 467
Custom Image option (Solution Options), 774
Custom Menus feature
scripts, error handling, 558
security, 376
Custom Menus tab (Define Custom Menus dialog), 424
Custom Privileges dialog (Define Accounts & Privileges dialog), 383
Create setting, 384
Delete setting, 384
Edit setting, 384
Field Access setting, 384
View setting, 384
Custom Privileges setting (Edit Privileges dialog), 387
Custom Script Privileges dialog (Edit Privileges dialog), 388-389
Custom Value List Privileges dialog (Edit Privileges dialog), 387-388
Custom Web Publishing (CWP). See CWP
customizable list reports, building, 440-443, 445-446, 448
customizing
extended privileges, user-level internal security, 392-393
privilege sets, 383-384
solutions via Developer Utilities (FileMaker Developer), 777
Cut script steps, 301
CWP (Custom Web Publishing), 716
commands
dbnames, 741
delete, 741
dup, 741
edit, 741
find, 742
findall, 742
findany, 742
layoutnames, 742
new, 742
process, 742
scriptnames, 742
view, 742
databases, configuring for, 719
extended privileges, 719-721
naming scripts, 290
operators, 727
PHP, 750
extended privleges, configuring, 751
layouts, reviewing, 752
placing files on Web server, 752-753
preparing FileMaker Server for, 752
selecting, 750
session management, 745-746
stylesheets, sharing data between, 740-741
URL
exact match searches, 726-727
multiple criteria searches, 728
multiple find requests, 728-729
numerical comparison searches, 727
parameters, 742-744
requests, troubleshooting, 746
specific record searches, 725-726
specifying search result sort order, 729
table searches, 725
versus IWP, 718
versus XML export, 719
WPE, troubleshooting access, 746
query strings, 724
XSLT, 730
building HTML-formatted search result stylesheets, 738-739
embedding query parameters in stylesheets, 739-740
query strings, 739
stylesheet placement, 730
URL formats, 738-739
XSL extensions, 745
XSLT processors, 744
data, exporting. See also data
character transformations
carriage returns, 653
repeating fields, 653
Tab character, 653
container fields, 659
file formats
BASIC file format, 655
choosing, 651
CSV format, 654
Excel file format, 655
FileMaker Pro File format, 655
HTML Table format, 655
Merge format, 655
SYLK file format, 654
tab-separated text format, 654
XML file format, 655
file privileges, 652
fixed-width formats, padding data, 658-659
formatting, 656
from all records, 653
grouped data, 657-658
large fields, 659
reasons for, 650
related fields, 657
scripts, 660
SSL data transfer, 789
source tables, choosing, 650
data. See also data, exporting
editing
audit trails, 362-368
meta data, 362
script-controlled editing, 362
fields, inserting into, 83-84
globally replacing, 82-83
importing
field validation, troubleshooting, 646
troubleshooting, 645
integrity, troubleshooting, 81
lost data, troubleshooting, 80
multitiered sorting, 84
timestamps, 362
validating, 63
override privileges, security, 390
Data Access and Design dialog (Edit Privileges dialog), 388-389
data configuration scripts, 299
Copy script steps, 301
Cut script steps, 301
Go to Field script steps, 300
Paste script steps, 301
Set Field script steps, 300-301
data control scripts, 299
Copy script steps, 301
Cut script steps, 301
Go to Field script steps, 300
Paste script steps, 301
Set Field script steps, 300-301
data entry, carriage returns, 155
Data Field elements, 365
Data option (field auto-entry options), 105
data source names, managing ODBC, 610
Data Type option (Specify Calculation dialog), 257
Data Viewer (Tools menu)
Debug Scripts feature, 580
expressions, defining, 579
values, inspecting, 578
database design
as iterative process, 170
attributes, 165-166
ERD, 166
versus entities, 167-169
entities, 165-166
ERD, 166
keys, 179-180
relationships, 170-180
versus attributes, 167-169
ERD, 164-165
attributes, 191
many-to-many relationships, 182
notation, 170-171
many-to-many optionality relationships, 175-176
one-to-one optionality relationships, 178
one-to-one relationships, 171
process analysis, 186, 188-189, 192
process analysis, 186
adding attributes, 190
determining entities, 187-189
database extensions, runtime applications, 773
database files, naming, 553
Database Homepage (IWP), 699
Database Options (FileMaker Mobile), 841-842
Backup at HotSync option, 841
Include in Global Find option, 841
Login option, 841
Synchronize Database option, 841
database software
advantages of, 14
as custom development software, 16
as off-the-shelf software, 16
functions of, 14
employee table example, 17
phone directory flat file example, 18
relational database example, 18
DatabaseNames functions, 278
databases
building
Define Database dialog, 88-89
from converted files, 239-240
concurrency, 355
ACID tests, 355-356
committed data versus created data, 357
multi-context locking, 361
multi-window locking, 360
record locking, 358-360
script logs, 357
serial IDs, 358
CWP, configuring for, 719
extended privileges, 719-721
data validation, 63
deploying
FileMaker Server Advanced hosting, 22
Kiosk mode (FileMaker Pro Advanced), 22
peer-to-peer hosting, 21
server hosting, 22
single-user deployment, 21
single-user runtime deployments (FileMaker Pro Advanced), 22
directory structures, FileMaker Server maintenance, 829
fields, indexing, 111-114
FileMaker Pro, opening in, 48
local files, 48
remote files, 50
files, naming, 553
LAN, opening on, 51
multi-file structures, 240
data/application logic separation, 242-243
file maintenance, 241
reusability, 244
shared development, 240
navigating, 84
team development, 368-369
tracking sessions, 354
transactions, 355
date fields, 59. See also time fields
timestamp fields, 96
Date functions, 272-274
db URL parameters, 742
DBF file format (exporting data), 654-656
dbnames command, 741
DDR (Database Design Reports), 572
creating, 573
HTML, 574
Word (MS) documents, formatting as, 573
Debug Scripts feature (Data Viewer), 580
debugging
processes, script logs, 357
inspecting values, 578
looping scripts, 578
placing breakpoints, 578
declarations (XML), XSL stylesheets, 670
declarative programming, 604
decoding abbreviations, 438-439
dedicated find layouts, 545
Find mode layouts, 546
script-driven finds, 546
Define Accounts & Privileges dialog
Accounts tab
user account privilege sets, reviewing, 380
user account security, 378
Edit Account dialog security, 381
Privilege Sets tab, 382
Custom Privileges dialog, 383-384
Edit Privilege Set dialog, 383
Full Access privilege set option, 382
Define Custom Menus dialog, 423
Custom Menus tab, 424
Menu Sets tab, 424
Define Database dialog, 88-89
Comment text box, 89
Fields tab, 88
Relationships Graph, Specify Table dialog, 222
Relationships tab, 89
Table menu, Table Name box, 199
Define Scripts dialog (ScriptMaker Interface), 287-289
defining
field behaviors, 154
layout parts, 136
Delete Account script step, 400
Delete All Records option (FileMaker Mobile), 838
delete command, 741
Delete Record option (FileMaker Mobile), 838
Delete Related Records in This Table when a Record Is Deleted in the Other Table option (Edit Relationships dialog), 502
Delete setting (Custom Privileges dialog), 384
deleting
parts of layouts, 135
portal records, 500
related records, cascading deletions, 502
portal rows, 67
records from FileMaker, 54
restricted deletes, troubleshooting, 216
deploying
databases
FileMaker Server Advanced hosting, 22
Kiosk mode (FileMaker Pro Advanced), 22
peer-to-peer hosting, 21
server hosting, 22
single-user deployment, 21
single-user runtime deployments (FileMaker Pro Advanced), 22
plug-ins via FileMaker Server, 781
solutions, runtime solutions, 768
Design functions, 278
DatabaseNames functions, 278
ValueListItems functions, 279
WindowNames functions, 279
designing
databases
as iterative process, 170
attributes, 165-169
entities, 165-169
entity keys, 179-180
entity relationships, 170-180
process analysis, 186
process analysis, adding attributes, 190
process analysis, determining entities, 187-189
reports
alternating row color, 321
horizontal/vertical dividers, 322-324
sortable column headers, 324-329
trailing summaries, 320
user interfaces, design guidelines, 432
desktops, window desktops, 519-520
detail records (reports), displaying, 329
developer fields, 93
naming, 554
Developer Utilities (FileMaker Developer), 768
Admin access, removing, 775
creating runtime applications, 771, 774-775
customizing solutions, 777
error logs, 778
files, renaming, 769
Kiosk mode
enabling, 776-777
securing, 776
removing Admin access, 775
renaming files, 769
runtime applications, creating, 771, 774-775
Solution Options, 771
Bindkey option, 773
Closing Splash Screen option, 774
Custom Image option, 774
Extension option, 773
Runtime Name option, 773
solutions, customizing, 777
dialog windows
designing, 526-529
troubleshooting, 548-549
pause states, 528-529
DIF (Data Interchange Format), exporting data, 654-656
digital cameras, photo imports, 642-644
directories
AutoUpdate directory
building, 821
folder naming structures, 822
FileMaker Server maintenance, 829
phone directory flat files, example of, 18
directory servers, FileMaker Server registration, 813
Disconnect User from FileMaker Server When Idle option (Edit Privileges dialog), 390
displaying
detail records (reports), 329
portal rows, troubleshooting, 515
records in layouts, troubleshooting, 159
Distribute command (Arrange menu), 147
Div functions, 272
dividers (reports), 322-324
Do Not Evaluate If All Fields Are Empty option (Auto-Entry Options dialog), 365
Do Not Evaluate If All Referenced Fields Are Empty check box (Specify Calculation dialog), 257-258
Do Not Store Calculation Results check box (Indexing option), 259
documentation
creating for pre-FileMaker 7 software migration, 586-587
DDR, 572
creating, 573
HTML, 574
Word (MS) documents, formatting as, 573
downloading plug-ins, 825-826
drivers, ODBC, 604-605
installing, 607-608
managing, 611
Drop-Down Calendar option (Field/Control Setup dialog), 154
Drop-down list formats (fields), 56
Drop-Down List option (Field/Control Setup dialog), 154
DSN, configuring
on Windows OS, 616-617
dup command, 741
Duplicate command (Edit menu), 140
duplicating
found record sets during imports, 646
layouts, 124
durability (ACID tests), 356
dynamic portal sorting, 511
ascending/descending sorting, 513-514
multiple field type sorting, 512-513
screen refresh, managing, 512
sort buttons, establishing, 512
Edit Account dialog (Define Accounts & Privileges dialog), security, 381
Edit Box format option (Field/Control Setup dialog), 153
Edit box formats (fields), 56
edit command, 741
Edit Custom Function dialog, 464-465
Availability section, 466
Edit menu (FileMaker Mobile), 840
Edit menu (Layout mode)
Duplicate command, 140
Select All command, 142
Edit Menu Set dialog, 425
Edit mode (IWP), 713
Edit Privilege Set dialog (Define Accounts & Privileges dialog), 383
Edit Privileges dialog (Define Accounts & Privileges dialog)
Allow Exporting dialog, 389
Allow Printing dialog, 389
Allow User to Modify Their Own Password option, 390
Allow User to Override Data Validation Warnings option, 390
Available Menu Commands option, 390
Custom Value List Privileges dialog, 387-388
Data Access and Design dialog, 388-389
Disconnect User from FileMaker Server When Idle option, 390
Layouts drop-down list, 386
All Modifiable setting, 387
All No Access setting, 386
All View Only setting, 386
Custom Privileges setting, 387
Manage Extended Privileges option, 392-393
Records setting, 385-386
Edit Relationship dialog, 206, 220
Allow Creation of Records in This Table via This Relationship check box, 207, 501
Delete Related Records in This Table when a Record Is Deleted in the Other Table option, 502
field matches, building, 221
Sort Records option, 502
Edit Script dialog, 290
Edit setting (Custom Privileges dialog), 384
editing
custom menus (user interfaces), 426
menu sets, assigning, 428
menu sets, loading/activating, 427-428
data
audit trails, 362-368
meta data, 362
script-controlled editing, 362
fields, 55
scripts, 290
value lists (fields), 57-58
Else If script steps, 305-306
Else script steps, 305-306
email, sending as reports, 345
embedding query parameters in stylesheets, 739-740
employee tables, example of, 17
Enable Account script step, 400
enabling
AutoUpdate plug-in, 822
Kiosk mode via Developer Utilities (FileMaker Developer), 776-777
plug-ins, 781
encoding URL parameters, 742
End If script steps, 305-306
ending IWP sessions
FileMaker Pro 8 configuration, 695
troubleshooting, 714
entities (database design), 165-166
candidate entities, 168
child entities, 173
ERD, 166
join entities, attributes, 182
keys, 179
primary keys, 179-180, 190, 201
parent entities, 173
process analysis, 187-189
relationships, 170
cardinality, 174
many-to-many relationships, 173-176, 181-184, 192-194
many-to-one relationships, 173
notation, 170-171
one-to-many relationships, 170, 173, 177-180, 197-199
one-to-one relationships, 172, 178
optionality, 174-178
versus attributes, 167-169
Envelope layouts, 123
ERD (entity-relationship diagrams), 164-165
attributes/entities, 166, 169, 191
many-to-many relationships, 182
notation, 170-171
many-to-many optionality relationships, 175-176
one-to-one optionality relationships, 178
one-to-one relationships, 171
process analysis, 186-189, 192
Relationship Graphs, 218
error capturing
troubleshooting, 368
unsupported script steps (IWP), 704
error codes, FMSAUC_UpdatePlugin (AutoUpdate plug-in), 823
error handling scripts, 557
Get(LastError) function, 558
reproducing errors, 559
Set Error Capture scripts, 558
error logs, Developer Utilities (FileMaker Developer), 778
error management scripts, 298
Allow User Abort scripts, 298
Get (LastError) functions, 299
Set Error Capture scripts, 298-299
error messages
locked records, 359-360
no records found, 726
scripts, troubleshooting, 312
Evaluate functions, 443
audit trail auto-entry techniques, 363
customizable list reports, 445-446, 448
multi-valued script parameters, passing, 482
subsummary reports, 337
uses of, 444
EvaluationError functions, 445
event logs, FileMaker Server maintenance, 830
Exact functions, 267
exact match searches (CWP URL searches), 726-727
Excel file format (exporting data), 655
saving/sending as reports, 344
exclude-result-namespaces statements (xsl:stylesheet statements), 670
exit conditions (loops), 308
Exit script, 293
exiting
IWP sessions, 695
loops, 308
expanding windows (multi-window interfaces), 529
exploring PHP site, 761-763
Export Field Contents option (container fields), 61
Export Field Contents script step, 660
Export Records script step, 660
exporting data
character transformations
carriage returns, 653
repeating fields, 653
Tab character, 653
container fields, 659
file formats
BASIC file format, 655
choosing, 651
CSV format, 654
DBF file format, 654-656
Excel file format, 655
FileMaker Pro file format, 655
HTML Table format, 655
Merge format, 655
SYLK file format, 654
tab-separated text format, 654
WKS file format, 654-656
XML file format, 655
file privileges, 652
FileMaker data as XML, 673
FMPDSORESULT grammar, 665
FMPXMLRESULT grammar, 665
fixed-width formats, padding data, 658-659
formatting, 656
from all records, 653
grouped data, 657-658
large fields, 659
privileges, security, 389
reasons for, 650
related fields, 657
scripts, 660
source tables, choosing, 650
Extend Found Sets, 75
Extend function, 257
extend requests, 75
extended priveleges (IWP security), 698
Access via FileMaker Mobile privilege, 391
Access via FileMaker Network privilege, 391
Access via Instant Web Publishing privilege, 391
Access via ODBC/JDBC privilege, 391
Access via XML Web Publishing privilege, 391
Access via XSLT Web Publishing privilege, 392
configuring for PHP, 751
CWP, database configuration, 719-721
user-level internal security
custom privileges, 392-393
default privileges, 391-392
Extended Privileges tab (Accounts and Privileges menu), 698
Extension option (Solution Options), 773
external authentication feature (FileMaker Server), 396-397, 788
external data sources
flat-file sources, importing, 628
Import Field Mapping dialog, 629-633
target, selecting, 628
in multifile table systems, 234
Microsoft Excel file, importing data, 636-638
ODBC
adding to Relationships Graph, 620
specifying, 618-622
fact tables, 194
Field Access setting (Custom Privileges dialog), 384
Field Behavior dialog
accessing, 154
field access, configuring, 154
Go to Next Object Using option, 155
field definition dialog, Comment dialog, 555
Field List (Specify Calculation dialog) ), 98, 254
field list filtering, 651
Field Options (FileMaker Mobile), 841
field steps (scripts), 299
conditional script steps, 305-306
loops, 308
Copy, 301
Cut, 301
Else If script steps, 305-306
Else script steps, 305-306
End If script steps, 305-306
Find, 303
Go to Field, 300
Go to Layout, user navigation scripts, 301
If script steps, 305-306
My Set Field, troubleshooting, 312
Open Record/Request, 359
Paste, 301
Set Field, 300-301
Show Custom Dialog script steps, 309
Sort, 304
field URL parameters, 742
field validation errors, troubleshooting, 646
Field/Control Setup dialog
accessing, 153
Checkbox Set option, 154
Drop-Down Calendar option, 154
Drop-Down List option, 154
Edit Box format option, 153
Pop-Up Menu option, 154
fieldname URL parameters, 742
Fieldname.op URL parameters, 743
fields
access, configuring, 154
appearance of, 55
as buttons, 153
AuditLog fields, 363-365
auto-entry options, 102-103
Calculated Value option, 105
calculation formulas, 253
Creation option, 103
Data option, 105
Looked-Up Value option, 105-106
Modification option, 103
Serial Number option, 104-105
Value from Last Visited Record option, 105
behaviors, defining, 154
break fields, 330
subsummary reports, 333
calculated replaces, 253
calculation fields, 60, 98-100, 250
data types, 257
data types, troubleshooting, 280
global storage, 259
indexing, 259-260
number of repetitions, 257
comments
adding, 95
proactive troubleshooting, 555
viewing, 89
Export Field Contents option, 61
exporting data, 659
Import option, 61
Insert option, 61
OLE support, 61
Paste option, 61
saving/retrieving information in, 61
copying/pasting, troubleshooting, 159
creating, 95
Creation Account Names fields, 107
Creation Timestamp fields, 107
developer fields, 93
naming, 554
editing, 55
exporting data, selecting for, 651-653
formatting
Check box set formats, 56
data in, 57
Drop-down list formats, 56
Edit box formats, 56
Pop-up calendar formats, 56
Pop-up menu formats, 56
Radio button set formats, 56
Furigana, 115
login accounts, 354
troubleshooting, 367
indexing, 111
in FileMaker 8, 117
unindexable fields, 114
value indexes, 113-114
word indexes, 113
large fields, exporting data, 659
layouts, adding to, 152-153
layouts, formatting in, 153-154
matches, building, 221
merge fields, adding to layouts, 157
misspellings, 55
Modification Account Names fields, 107
Modification Timestamp fields, 107
naming, 554
numerical fields, numerical comparison searches (CWP URL searches), 727
post-conversion fixes, 595-597
primary key fields, configuring, 201
related fields, exporting, 657
repeating fields, 111
character transformations (exporting data), 653
selecting in calculation formulas, 254
serial key fields, creating, 104
Average of function, 101
Count of function, 101
Fraction of Total of function, 101
Maximum function, 101
Minimum function, 101
reordering in subsummary reports, 339
Standard Deviation of function, 101
subsummary reports, 335-337
Total of function, 101
tab order, 155-156
Creation Account Names fields, 107
Modification Account Names fields, 107
Creation Timestamp fields, 107
Modification Timestamp fields, 107
troubleshooting
field validation, 116
mismatched calculations, 115
mismatched data types, 115
naming conventions, 115
unindexed fields, searches/sorts, 561
user fields, naming, 554
calculation formulas, 252
condition failures, 108-109
troubleshooting, 116
value lists
editing, 57-58
other values, 58
sorting, 76
Fields tab (Define Database dialog), 88
file lists, filtering, 398
file maintenance, multi-file database structures, 241
File Maintenance feature, 572
File Options dialog, creating default accounts, 379
file paths, script variables, 492
file recovery, 571
troubleshooting, 81
file references
errors, 783
fixing for pre-FileMaker 7 software migration, 587-588
naming conventions, 238
search paths, adding, 236
file requests on multiple layouts, 75
file sharing, IWP, 699
file-level access security, 393
external authentication, 396-397
file list filtering, 398
networks, 394
server administration, 393
user authentication, 395
FileMaker 8, indexing in, 117
FileMaker Developer
Developer Utilities, 768
creating runtime applications, 771, 774-775
customizing solutions, 777
enabling Kiosk mode, 776-777
error logs, 778
removing Admin access, 775
renaming files, 769
securing Kiosk mode, 776
Solution Options, 771-773
sample plug-in, functions of, 780
FileMaker Mobile
Access via FileMaker Mobile extended privilege, 391
components of, 832
Edit menu, 840
FileMaker database synchronization, 842
adding/removing files, 842
configure settings, 847
field configuration settings, 844-845
permission settings, 843-844
synchronization settings, 845-847
user settings, 847
Find Records dialog, 839
Go to Record option, 839
Show All option, 839
Form view, 835-836
handheld devices, installing on, 833-834
List view, 835
Mobile Settings dialog
Specifying Fields button, 844
Synchronization button, 845-846
Options menu, 840
Database Options, 841-842
Field Options, 841
Form View Options, 841
List View Options, 841
overview of, 20
Record Functions menu
Delete All Records option, 838
Delete Record option, 838
New Record option, 838
Sort Records option, 839
related data, publishing, 849
Settings button, 843
system requirements, 833
troubleshooting
found sets/sessions, 848
missing index values, 848-849
missing records, 849
FileMaker Network, Access via FileMaker Network extended privilege, 391
FileMaker Pro 6, FileMaker Pro 9 feature comparison, 28
FileMaker Pro 8
IWP configuration, 692
access logs, 695
application logs, 694-695
ending sessions, 695
port numbers, 693
security, 694
FileMaker Pro 9
architectural changes
file formats, 25
files with multiple windows, 27
privilege sets, 27
relationship functionality, 26
Relationships Graph, 25
development of, 13
FileMaker Pro 6 feature comparison, 28
functionality, extending, 23
new features, overview of, 23-24
security, 27
FileMaker Pro 9 Advanced
overview of, 19
Kiosk mode, 22
single-user runtime deployments, 22
FileMaker Pro file format (exporting data), 655
FileMaker Server, 786
access, troubleshooting, 746
Active Directory server registration, 814-817
Auto Update feature, 820
Consistency Checker, 788
database hosting, 801
directory server registration, 813
disconnecting from, 390
external authentication feature, 788
external authentication services, configuring, 820
LDAP Server registration, 813-814
viewing registered servers, 818
maintenance tips
database directory structures, 829
file maintenance, 830
hardware requirements, 828
monitoring event logs, 830
monitoring usage statistics, 829
network infrastructures, 828
scheduling backups, 829
server configuration, 829
software installation, 828
software updates, 830
performance, troubleshooting
general slowness, 561
script slowness, 562
plug-in management feature, 788
plug-ins
automatically updating, 820-822, 824-827
deploying, 781
requirements of, 789
data center environments, 791
hard drives, 790
network connections, 791
processors, 790
RAM, 790
supported operating systems, 791
SAT, 788
troubleshooting server registration, 827
SSL data transfer feature, 789
starting/stopping, 801
versus peer-to-peer database hosting, 787
FileMaker Server 8 Advanced
IWP configuration, 696
WPAC
FileMaker Server Published Databases page, 696
Publishing Engine Configuration page, 696
FileMaker Server 9, 20
FileMaker Server 9 Advanced, 20
FileMaker Server Advanced hosting, 22
FileMaker Server Published Databases page (WPAC), 696
FileMaker-to-FileMaker imports, 646-647
files
converted files, building databases, 239-240
corrupted files, troubleshooting, 81
multiple files, building databases, 239-240
multiple windows, FileMaker Pro 9 changes, 27
open files, backups, 788
renaming
Developer Utilities (FileMaker Developer), 769
file reference errors, 783
runtime applications, adding/replacing, 773
viewing in Web Viewer, 413
filtered portals, 505
And filtered portals, 508
Or filters, 509-510
filtering
field lists, 651
file lists, 398
filtering functions
FilterValues functions, 460
FilterValues functions, 460
comparison operators, 727
find layouts, 545
Find mode layouts, 546
script-driven finds, 546
Find mode, 43
dedicated layouts, 546
find requests, 69
constrain requests, 74
extend requests, 75
multiple find requests, 73
on multiple layouts, 75
search symbols, 72
wildcard searches, 72
Modify Last Find feature, 75
Find mode (IWP), 713
Find Records dialog (FileMaker Mobile), 839
Go to Record option, 839
Show All option, 839
find requests, 69
Modify Last Find feature (FileMaker Pro Find mode), 75
multiple find requests, 73
search symbols, 72
wildcard searches, 72
Find script step, 303
findall command, 742
findany command, 742
finding
records, CWP URL searches, 725-726
registered FileMaker Servers via LDAP Server, 818
tables, CWP URL searches, 725
firewalls
CWP URL requests, 746
server connections, troubleshooting, 564
fixed-width formats, exporting to, 658-659
flat file databases, 15
flat files, 18-19
data sources, importing, 628-633
Floor functions, 271
FMPDSORESULT grammar (XML), 665
FMPXMLRESULT grammar (XML), 665
Amazon.com XML data importing to FileMaker, 682-684
importing XML files, troubleshooting, 685
XML data importing to FileMaker, 674, 677, 679-680
FMSAUC_FindPlugin function (AutoUpdate plug-in), 823
plug-in names/version numbers, accessing, 824
FMSAUC_UpdatePlugin function (AutoUpdate plug-in)
error codes, 823
plug-ins, downloading, 825-826
FMSAUC_Version function (AutoUpdate plug-in), 823
folder imports, 638
image file imports, 640-641
thumbnail imports, 641-642
text file imports, 638-640
folders, naming AutoUpdate directory folders, 822
footers, 134
IWP layout design restrictions, 707
user interfaces, 431
foreign keys (entities), 180
process analysis, 191
Form view (FileMaker Mobile), 835-836, 841
Form view (FileMaker Pro), 44
Format Painter tool, 139
formatting
conditional formatting, 429
exported data, 656
fields
Check box set formats, 56
data in, 57
Drop-down list formats, 56
Edit box formats, 56
Pop-up calendar formats, 56
Pop-up menu formats, 56
Radio button set formats, 56
files, FileMaker Pro 9 changes, 25
layout fields, 153-154
layout parts, 135
reports, 319
text functions, 452
RGB, 453
TextColor, 453
TextColorRemove, 454
TextFont, 453
TextFontRemove, 454
TextFormatRemove, 454
TextSize, 453
TextSizeRemove, 454
TextStyleAdd, 453-454
TextStyleRemove, 453-454
forms, viewing as layouts, 127
Formula text box feature (Specify Calculation dialog), 99, 253
formulas
boolean formulas, 252
calculation formulas, 250
auto-entry options (fields), 253
calculated replaces (fields), 253
debugging, 436
field names, troubleshooting, 279
field validation, 252
record-level security, 253
script steps, 252
specifying context, 260-261
writing, legibility, 255
writing, selecting fields, 254
writing, selecting functions, 255
writing, selecting operators, 254
complex formulas, simplifying, 462
post-conversion fixes, 595-597
Found Record Numbers (Status Area), 43
found sets, 68-69
printing, 77
window construction, troubleshooting, 547
Fraction of Total of function (summary fields), 101
full access privileges (scripts), 291
[Full Access] privilege set option (Define Accounts & Privileges dialog), 382
Function List (Specify Calculation dialog), 98, 255
function palettes (multi-window interfaces), 526
functions
Abs, 272
aggregate functions, 276
array functions, 455
GetValue functions, 456
MiddleValues functions, 456, 474
RightValues functions, 456, 474
stepping through, 457
usage examples, 456
ValueCount functions, 456, 474
calculation functions
Exact functions, 267
Length functions, 266
PatternCount functions, 266
Position functions, 266
Substitute functions, 268
Trim functions, 267-268
WordCount functions, 267
case altering, 268
Ceiling, 271
components of, 264
conditional functions, 274
Case statements, 275
count functions, 276
custom functions, 461
automatic updates, 463
building, 464-466
building custom function libraries, 475
comments, 556
configuring availability, 466
CrossProduct functions, 470-471
defining system constants, 463
Hypotenuse functions, 467
naming, 555
naming conventions, 465
naming parameters, 555
NthRoot functions, 467
PadCharacters functions, 469
Quarter functions, 467
recursive functions, 464
refactoring, 463
RepeatText functions, 468
restricting access, 466
simplifying complex formulas, 462
TrimChar functions, 470
WeekEndingFriday functions, 467
DatabaseNames functions, 278
Date functions, 272-274
Design functions, 278
DatabaseNames functions, 278
ValueListItems functions, 279
WindowNames functions, 279
Div, 272
Evaluate
passing multi-valued script parameters, 482
subsummary reports, 337
EvaluationError functions, 445
Exact, 267
Extend, 257
filtering functions
FilterValues functions, 460
Floor, 271
Get, 277-278
Get (ContentHeight), 521
Get (ContentWidth), 521
Get (Height), 520-521
Get (LastError), 558
Get (ScreenHeight), 519
Get (ScreenWidth), 519
Get (ScriptParameter), retrieving script parameter values, 480
Get (ScriptResult), 486
Get (Width), 520-521
Get (WindowDesktopHeight), 519
Get (WindowDesktopWidth), 519
GetAsBoolean, 252
GetLayoutObjectAttribute, identifying current Web Viewer page, 412-413
GetNthRecord functions, 472-473
GetParam, passing multi-valued script parameters, 483
GetSummary, subsummary reports, 337
Int, 271
IsValidExpression functions, 445
Length, 265-266
Let, passing multi-valued script parameters, 481-482
logical functions
Choose functions, 437-439
Evaluate functions, 443-446, 448
GetField functions, 439-443
Lookup functions, 449
LookupNext functions, 449-452
Self function, 434
Mod, 272
naming, 555
nesting functions, 265, 269-270
number functions, 270
Abs functions, 272
Ceiling functions, 271
Div functions, 272
Floor functions, 271
Int functions, 271
Mod functions, 272
Random functions, 272
Round functions, 271
Truncate functions, 271
parameters, 264
naming, 555
PatternCount, 266
plug-in functions, 779
Position, 266
private, naming conventions, 466
public, 466
Random, 272
Round, 271
selecting in calculation formulas, 255
Substitute, 268
text formatting functions, 452
nontext calculations, troubleshooting in, 473
RGB functions, 453
TextColor functions, 453
TextColorRemove functions, 454
TextFont functions, 453
TextFontRemove functions, 454
TextFormatRemove functions, 454
TextSize functions, 453
TextSizeRemove functions, 454
TextStyleAdd functions, 453-454
TextStyleRemove functions, 453-454
text functions, 265
case altering functions, 268
Exact functions, 267
Length functions, 266
PatternCount functions, 266
Position functions, 266
Substitute functions, 268
text parsing functions, 269
Trim functions, 267-268
WordCount functions, 267
text parsing, 269
Time functions, 272-274
TimeStamp, 273-274
Trim, 267-268
Truncate, 271
ValueListItems functions, 279
WindowNames functions, 279, 518
WordCount, 267
XMpl-Add, 780
XMpl-Append, 780
XMpl-NumToWords, 780
XMpl-StartScript, 780
XMpl-UserFormatNumber, 780
Furigana, 115
general slowness (performance), troubleshooting, 561
generic report structures versus specific report structures, 318
Get (ActiveFieldContents) function, audit trail auto-entry techniques, 365
Get (ActiveFieldName) function, audit trail auto-entry techniques, 365
Get (ApplicationVersion) function, IWP execution tests, 705
Get (ContentHeight) functions, 521
Get (ContentWidth) functions, 521
Get (CurrentAccount) function, audit trail auto-entry techniques, 365
Get (CurrentTimeStamp) function, audit trail auto-entry techniques, 365
Get (Height) functions, 520-521
Get (LastError) functions, 299, 558
Get (LastMessageChoice) function, 309
Get (ScreenHeight) functions, 519
Get (ScreenWidth) functions, 519
Get (ScriptParameter) functions, retrieving script parameter values, 480
Get (ScriptResult) function, 486
Get (Width) functions, 520-521
Get (WindowDesktopHeight) functions, 519
Get (WindowDesktopWidth) functions, 519
Get functions, 277-278
GetAsBoolean function, 252
GetField functions, 439-440
customizable list reports, building, 440-443
GetLayoutObjectAttribute function, identifying current Web Viewer page, 412-413
GetNthRecord functions, 472-473
GetParam functions, multi-valued script parameters, passing, 483
GetSummary function, subsummary reports, 337
GetValue functions, 456
global fields, 62
Global Storage option (Storage Options dialog), 259
global variables
globally stored fields versus, 491
naming, 490
scope, 490
user session data, 491
uses for, 491
globally replacing data, 82-83
globally stored fields
global variables versus, 491
uses for, 491
calculation fields, 259
default values, troubleshooting, 367
login accounts, 354
troubleshooting, 570
Go to Field script steps, 300
Go to Layout script step, user navigation scripts, 301
Go to Next Object Using option (Field Behavior dialog), 155
Go to Record option (FileMaker Mobile), 839
Go to Related Record Options dialog
Show in New Window option, 539-540
Show Only Related Records option, 539-540
Go to Related Record scripts, 537-538
disconnected table occurrences, jumping to, 543
found sets, predicting, 541-542
usage examples, 539
versus searches, 563
Grammar section (URL), 724
grammar URL parameters, 743
Graphic menu command (Insert menu), 139
graphics
IWP layout design restrictions, 705
layouts, adding to, 139
grouped data, exporting, 657-658
grouping/ungrouping layout objects, 146
gSelectedRowID field
selection portal rows, highlighting, 534
selection portal rows, selecting, 537
GTRR scripts. See Go to Related Record scripts, 537
Guest accounts, user-level internal security, 379
handheld devices
FileMaker Mobile Edit menu, 840
FileMaker database synchronization, adding/removing files, 842
FileMaker database synchronization, configure settings, 847
FileMaker database synchronization, field configuration settings, 844-845
FileMaker database synchronization, permission settings, 843-844
FileMaker database synchronization, synchronization settings, 845-847
FileMaker database synchronization, user settings, 847
Find Records dialog, Go to Record option, 839
Find Records dialog, Show All option, 839
Form view, 835-836
installing on, 833-834
List view, 835
Mobile Settings dialog, Specifying Fields button, 844
Mobile Settings dialog, Synchronization button, 845-846
Options menu, 840
Options menu, Database Options, 841-842
Options menu, Field Options, 841
Options menu, Form View Options, 841
Options menu, List View Options, 841
Record Functions menu, Delete All Records option, 838
Record Functions menu, Delete Record option, 838
Record Functions menu, New Record option, 838
Record Functions menu, Sort Records option, 839
related data, publishing, 849
Settings button, 843
troubleshooting, 848-849
hard drives, FileMaker Server requirements, 790
hardware requirements, FileMaker Server, 828
headers, 133
IWP layout design restrictions, 707
sortable headers, 324-327
ascending/descending logic, 328-329
user interfaces, 431
hiding
layout elements in user interfaces, 543-545, 548
layouts, 130
report elements prior to printing, 319
scripts, 296
status area (IWP), application flow, 709-710
windows (multi-window interfaces), 530
highlighting
portal rows, troubleshooting, 547
selection portal rows, 533-534
establishing relationships, 535
navigation in, 535
HighlightRow field, selection portal rows
highlighting, 534
selecting, 537
home pages, building IWP home pages, 711
horizontal dividers (reports), 322-324
horizontal portals, 504
house icon (IWP status area), 696
HTML (HyperText Markup Language)
DDR, 574
search result stylesheets, building, 738
URL format, 738-739
HTML Table format (exporting data), 655
HTTP (HyperText Transfer Protocol) Web services, 675
hyphens (-), layout names, 132
Hypotenuse functions, 467
identifying
current page in Web Viewer, 412-413
unsupported script steps, 703
identity functions (plug-ins), 824-825
If - Else If script step, 360
If script steps, 305-306
image files
importing, 640-641
references, importing, 641
thumbnails, importing, 641-642
imperative programming, 604
Import option (container fields), 61
importing
Amazon.com XML data to FileMaker
FMPXMLRESULT grammar, 682-684
source URL, 684-685
data imports, troubleshooting, 645
existing records, updating with imported data, 633-635
field validation, troubleshooting, 646
found record sets, 647
found record sets, duplicating, 646
from FileMaker Pro file, 635
from flat-file sources, 628
Import Field Mapping dialog, 629-633
target, selecting, 628
from Microsoft Excel file, 636
new table, creating, 637-638
image files, 640-641
thumbnails, 641-642
layouts, 124
ODBC data into FileMaker, 617
photos from digital cameras, 642-644
scripted imports, 644-645
table records, table context, 567
text files, 638-640
XML data to FileMaker, 674-675, 678-679
FMPXMLRESULT grammar, 674, 677-680
troubleshooting, 685
XML stylesheets, 676-677
XSL stylesheets, 678-680
Include in Global Find option (FileMaker Mobile), 841
incomplete scripts, troubleshooting, 312
indexing
calculation fields, 259-260
fields, 111
unindexable fields, 114
value indexes, 113-114
word indexes, 113
in FileMaker 8, 117
portals, 497
Indexing option (Storage Options dialog), 259-260
Automatically Create Indexes as Needed check box, 259
Do Not Store Calculation Results check box, 259
Indicate Web Compatibility check box (ScriptMaker), 703
InitializeGlobals scripts, 313
initiating scripts, 310
Insert menu (Layout mode), 83, 139
Graphic menu command, 139
Insert option (container fields), 61
Insert, From Index command (FileMaker Pro), 83
inserting data into fields, 83-84
installing
FileMaker Mobile on handheld devices, 833-834
ODBC drivers, 607-608
plug-ins, 780
software, FileMaker Server maintenance tips, 828
Instant Web Publishing, Access via Instant Web Publishing extended privilege, 391
Instant Web Publishing setup screen
accessing, 693
database files, extended privileges, 699
Int functions, 271
integrity (data), troubleshooting, 81
interfaces
building, 417-418
custom menus
components of, 422
editing, 426
FileMaker control of, 423
menu sets, assigning, 428
menu sets, loading/activating, 427-428
scratch-building, 428
uses of, 422
creating for many-to-many relationships, 214-215
dedicated find layouts, 545
Find mode layouts, 546
script driven finds, 546
design guidelines, 432
headers/footers, 431
layout elements, showing/hiding, 543-545, 548
look/feel, designing, 419-420
dialog windows, 526-529, 548-549
expanding windows, 529
hiding windows, 530
marquee titles, 529
tool/function palettes, 526
uses of, 526
native user interface, 417
optimizing, 418-419
prototype layouts/menus, 416
security plans, 376
Table view, 431
UI files, 420
internal security (user-level)
extended privileges
custom privileges, 392-393
default privileges, 391-392
privilege sets, 381-382
conditional privileges, 385-386
data access, controlling, 383-384
data validation warning override privileges, 390
export privileges, 389
FileMaker Server disconnects, 390
layout use/development, 386-387
menu commands access, 390
passwords, setting, 390
printing privileges, 389
run script privileges, 388-389
value list access, 388
user accounts, 378
Admin accounts, 379
automatic logins, 379
default accounts, 379
editing, 379-381
[Guest] accounts, 379
managing, 379-381
interrogating text strings, 266
IP addresses, wildcards, 694
iPhone, specifying style sheets, 848
isolation (ACID tests), 356
Issue Tracker, 402-404
IsValidExpression functions, 445
iterative process, database design as, 170
IWP (Instant Web Publishing), 690, 716
Allow User Abort setting, 704
application flow, 708
creating file links, 710-711
explicit record commits, 709
hiding status area, 709-710
portals, 710
session management, 708
Browse mode, 711
Commit Record/Request step, 704
configurations, converting, 599
constraints, 701-702
container field restrictions, 707
data, importing/exporting, 702
data-entry, 702
database development tools, 701
Database Homepage, 699
defining, 690
deploying
host machine requirements, 691
JavaScript, disabling of, 692
remote user requirements, 692
supported web browsers, 692
Edit mode, 713
ending sessions, troubleshooting, 714
file security, 701
authenticating accounts/privileges, 700
extended priveleges, 698
file sharing, 699
FileMaker Pro 8 configuration, 692
access logs, 695
application logs, 694-695
ending sessions, 695
port numbers, 693
security, 694
FileMaker Pro keyboard shortcuts, 702
FileMaker Pro toolbars, 702
FileMaker Server 8 Advanced configuration, 696
turning on/off, 696
Find mode, 713
goal of, 690
graphical layout elements, 702
home pages, building, 711
layout design restrictions, 705
graphical elements, 705
headers/footers, 707
layout part size, 706
View As options, 706
passwords, 702
Preview mode, 702
script support, 702
committing records, 704
IWP execution tests, 705
startup/shutdown scripts, 704
subscript calls, 705
Show/Hide Status Area script step, 709
Sort dialog, 713
spell-checking, 702
status area
Commit button, 709
house icon, 696
Log Out button, 695
turning on/off, 693
unsupported script steps
error capturing, 704
identifying, 703
value lists, 702
versus CWP, 718
window manipulation tools/techniques, 702
IWP Database Homepage, Advanced Web Publishing Options dialog, 693
JavaScript, disabling, 692
join tables, 182
naming, 553
joins
entity attributes, 182
equijoins, 26
join tables, naming, 553
key fields, 18
naming, 554
keyboard shortcuts
FileMaker Pro, 82
IWP, 702
keys (entities), 179
foreign keys, 180
process analysis, 191
match fields, 201
primary keys, 179-180
configuring fields, 201
process analysis, 190
Kiosk mode, 22
enabling via Developer Utilities (FileMaker Developer), 776-777
securing via Developer Utilities (FileMaker Developer), 776
kiosks, 768
Label layouts, 123
labels, subsummary reports, 334
LANs, opening databases on, 51
language support, Furigana, 115
large fields, exporting data, 659
launch files, 366
launching
Admin Console, 802
PHP Site Assistant, 754
XSLT Site Assistant, 732
lay URL parameters, 743
layout objects
layering, 148
naming, 145
resizing, 145-146
layout group, selecting, 756
Layout menu (Status Area), 42
Layout mode, 43
accessing, 120
Always Lock Layout tools option, 138
Arrange menu
Align command, 147
Bring Forward command, 148
Bring to Front command, 148
Distribute command, 147
Object Grids command, 143
Resize To alignment tools, 142
Resize To command, 147
Send Backward command, 148
Send to Back command, 148
book icon, 138
column boundaries, 128
dependencies, table context, 569
Edit menu
Duplicate command, 140
Select All command, 142
Insert menu, 139
Graphic menu command, 139
navigating between layouts, 138
Part Setup dialog, 331
Sub-Summary When Sorted By option, 332
Sliding/Printing dialog, 319
Status Area, 137-139
subsummary reports, labels, 334
Layout mode (Status Area), Portal Setup dialog, 498
Allow Deletion of Portal Records option, 500
row setup options, 500
sorting criteria, specifying, 499
layout objects
aligning, 147
attributes, specifying, 139
centering, 147
default format attributes, setting, 139-140
duplicating, 140-141
Format Painter tool, 139
grouping/ungrouping, 146
layering, 148
layouts, adding to, 137-138
locking/unlocking, 147
moving, 142
object grids, 143
positioning, 141-142
resizing, 142
selecting, 141
Size palette, 143-145
sliding, 148
stacking orders, 148
Layout Setup dialog
accessing, 126
Views tab, 128
layouts, 120
Blank Layouts, 123
bodies, 133
alternating background fills, 137
buttons, building, 311
Columnar List/Report layouts, 122
context of, 125
dependencies, troubleshooting, 566
cross-platform layouts, building, 160
dedicated find layouts, 545
Find mode layouts, 546
script-driven finds, 546
duplicating, 124
Envelope layouts, 123
fields
adding, 152-153
configuring access, 154
configuring data entry guidelines, 155
defining behaviors, 154
formatting, 153-154
navigating, 155
tab order, 155-156
FileMaker Pro layouts, 41-42
Footers, 134
Format Painter tool, 139
headers/footers, 133
IWP restrictions, 707
hiding, 130
importing, 124
IWP restrictions, 705
graphical elements, 705
headers/footers, 707
layout part size, 706
View As options, 706
Label layouts, 123
layout objects
adding, 137-138
aligning, 147
centering, 147
duplicating, 140-141
grouping/ungrouping, 146
layering, 148
locking/unlocking, 147
moving, 142
object grids, 143
positioning, 141-142
resizing, 142
selecting, 141
setting default format attributes, 139-140
Size palette, 143-145
sliding, 148
specifying attributes, 139
stacking orders, 148
Leading Grand Summaries, 133
list view layouts, 318-320
printing, hiding elements before, 319
viewing, 318
merge fields, adding to, 157
multi-column layouts, 128-130
multiple layouts find requests, 75
working with FileMaker Pro, 84
naming conventions, 132-133, 554
navigating between in Layout mode, 138
parts
adding, 134
defining, 136
deleting, 135
formatting, 135
setting background colors, 135
pictures, adding, 139
portals, adding to, 498-499
post-conversion fixes, 597
printing sliding layout objects, 148
records, displaying, 159
reviewing, 752
Standard Form layouts, 122
Tab Control objects, adding to, 150-152
table occurrences, 125
Table View layouts, 123
Title Footers, 134
Title Headers, 133
tooltips, 157
Trailing Grand Summaries, 133
usage/development privileges, security, 386-387
user access, restricting, 131-132
user interfaces
prototype layouts, 416
showing/hiding layout elements, 543-545, 548
viewing
forms view, 127
lists view, 127
retricting user access, 128
tables view, 128
Layouts drop-down list (Edit Privileges dialog), 386
All Modifiable setting, 387
All No Access setting, 386
All View Only setting, 386
Custom Privileges setting, 387
layoutnames command, 742
LDAP Servers, FileMaker Server
configuring external authentication services, 820
viewing registered servers, 818
Leading Grand Summaries, 133
Left to Right alignment option (Align command), 147
LeftValue functions, 456
troubleshooting, 474
Length function, 265
Length functions, 266
Let functions, 434-436
calculation formulas, debugging, 436
multi-valued script parameters, passing, 481-482
variable names, troubleshooting, 474
variables, using multiple instances of, 437
libraries, building script libraries, 313-314
linking Web pages to IWP files, 710-711
list reports
customizable list reports, building, 440-448
designing
alternating row color, 321
detail records, displaying, 329
horizontal/vertical dividers, 322-324
repeating fields for column highlights, 327
sortable column headers, 324-329
trailing summaries, 320
List view (FileMaker Mobile), 835
List view (FileMaker Pro), 44
list view layouts, 318-320
lists, viewing layouts as, 127
local files, opening in FileMaker Pro, 48
local variables, 488
scope, 490
uses for, 491
locating registered FileMaker Servers via LDAP Server, 818
locking
layout objects, 147
multiple contexts (scripts), 361
multiple windows, 360
portal records, 516
records, 358
trapping in scripts, 359-360
Log In Using option (File Options dialog), creating default accounts, 379
Log Out button (IWP status area), 695
logical functions
Choose functions, 437-439
Evaluate functions, 443
customizable list reports, 445-448
uses of, 444
GetField functions, 439-440
building customizable list reports, 440-443
Let functions, 434-436
debugging calculation formulas, 436
troubleshooting, 474
variables, using multiple instances of, 437
Lookup functions, 449
LookupNext functions, 449-452
Self function, 434
logical operators, 255
multiple find requests, 728
login accounts, globals, 354
Login option (FileMaker Mobile), 841
logins
automatic logins, user-level security, 379
testing, 367
troubleshooting, 367
Looked-Up Value option (field auto-entry options), 105-106
Lookup functions, 449
LookupNext functions, 449-452
loops, 307
calculated replaces, 563
conditional script steps, 308
exit conditions, 308
exiting, 308
testing, 313
lop command, 729
URL parameters, 743
lost data, troubleshooting, 80
Mac OS X, ODBC administration, 609
data source names, 610
drivers, 611
DSN configuration, 611-612, 615
Mac plug-ins, Windows servers, 821
maintenance
File Maintenance feature, 572
FileMaker Server
database directory structures, 829
file maintenance, 830
hardware requirements, 828
monitoring event logs, 830
monitoring usage statistics, 829
network infrastructures, 828
scheduling backups, 829
server configuration, 829
software installation, 828
software updates, 830
Manage Extended Privileges option (Edit Privileges dialog), 392-393
managing
branching scripts, conditional script steps, 305-306
custom menus (user interfaces), 423-425
errors
error management scripts, 298-299
Get (LastError) function, 299
Relationship Graphs, 246-247
scripts, 287-289
sessions, IWP, 708
windows, 518
positioning windows, 520-525
screen size, 519
window content, 521
window desktop size, 519-520
WindowNames functions, 518
many-to-many relationships, 173-174, 181-182, 192-194
examples of, 184
interface, designing, 214-215
optionality, 175-176
structure, building, 212
value lists, creating, 212-213
many-to-one relationships, 173
marquee titles (multi-window interfaces), 529
master records, adding to related records, 207
match fields, 201
mathematical operators, 255
matrixes (security), 374-376
max URL parameters, 743
Maximum function (summary fields), 101
memory, FileMaker Server requirements, 790
menu sets, interfaces, 423
Menu Sets tab (Define Custom Menus dialog), 424
menus
commands access, security, 390
custom menu components, 422
square-bracketed menus, 425
user interfaces
custom menus, assigning menu sets, 428
custom menus, components of, 422
custom menus, editing, 426
custom menus, FileMaker control of, 423
custom menus, loading/activating menu sets, 427-428
custom menus, managing, 423, 425
custom menus, menu sets interface, 423, 425
custom menus, scratch-building, 428
custom menus, uses of, 422
prototype menus, 416
Merge Field command (Insert menu), 157
merge fields, adding to layouts, 157
Merge format (exporting data), 655
meta data, 362
timestamps, 362
metadata, 14
Microsoft Excel file, importing data, 636-638
MiddleValues functions, 456
troubleshooting, 474
migrating pre-FileMaker 7 software, 582
file conversion process, 583-584
multi-file conversions, 585-586
post-conversion tasks, 589-597
pre-conversion tasks, 586-589
single-file conversions, 584-585
Minimum function (summary fields), 101
Mobile Settings dialog (FileMaker Mobile)
Configure button, 847
Specifying Fields button, 844
Synchronization button, 845
Actions option, 847
Conflict Resolution option, 846
Mode option, 845
Records option, 846
User button, 847
Mod functions, 272
modal dialog windows
designing, 526-529
troubleshooting, 548-549
pause states, 528-529
mode dependencies, table context, 568
Mode menu (Status Area), 43
Mode option (Synchronization button), 845
modid URL parameters, 743
Modification Account Names fields, 107
Modification option (field auto-entry options), 103
Modification Timestamp fields, 107
Modify Last Find feature (FileMaker Pro Find mode), 75
modular code, 556
modularizing scripts, 484-485
modules (multi-file databases), 240
data/application logic separation, 242-243
file maintenance, 241
reusability, 244
Move to Back option (Arrange menu), Tab Control objects, 152
Move/Resize Window script, 518
moving
layout objects, 142
scripts, 287
multi-column layouts, 128
subsummaries, 130
trailing grand summaries, 130
viewing, 130
multi-context locking, 361
multi-file conversion solutions, 585-586
multi-file databases structures, 240
data/application logic separation, 242-243
file maintenance, 241
reusability, 244
shared development, 240
multi-keys, multiple row selection in selection portals, 536-537
multi-user applications. See also multi-user databases
concurrency, 355
ACID tests, 355-356
committed data versus created data, 357
multi-context locking, 361
multi-window locking, 360
record locking, 358-360
script logs, 357
serial IDs, 358
sessions, 352-353
database tracking, 354
session-specific elements, 353
multi-user databases
audit trails, 362
auto-entry techniques, 363-368
meta data, 362
rollbacks, 366
script-controlled editing, 362
timestamps, 362
launch files, 366
meta data, 362
rollbacks, 366
multi-valued script parameters
passing, 480
Evaluate functions, 482
GetParam functions, 483
Let functions, 481-482
parsing text arrays, 481
structured data elements, 483
multi-window interfaces
dialog windows, 526-529
pause states, 528-529
troubleshooting, 548-549
expanding windows, 529
hiding windows, 530
marquee titles, 529
tool/function palettes, 526
uses of, 526
multi-window locking, 360
multifile table systems, 233-234
external data sources, 234
file references, building, 234-235, 237
multiple criteria, summarizing in subsummary reports, 338
multiple criteria searches (CWP URL searches), 728
multiple file windows, FileMaker Pro 9 changes, 27
multiple files
crosstalk, 235
databases, building, 239-240
multiple find requests, 73
building, 728-729
multiple layouts
file requests, 75
FileMaker Pro, working with, 84
multiple records, sorting, 76
multiple repetitions, calculation fields, 257
multiple row selections in selection portals, 535-537
multiple tables
match fields, 201
portals
adding related records to master records, 207
viewing related child data, 202-205
relationships, building, 199-201
multitable systems
first tables, building, 197
tables, adding to, 199
multitiered pause states, 528
multitiered sorting, 84
multiuser databases, team development, 368-369
multiple-match relationships
building, 223-226
OR conditions, troubleshooting, 246
My Set Field script step, troubleshooting, 312
Name First elements, 365
Name Last elements, 365
name-value pairs, 724
naming
AutoUpdate directory folders, 822
custom function parameters, 555
database files, 553
file references, 238
files
Developer Utilties (FileMaker Developer), 769
file reference errors, 783
functions, 555
join tables, 553
key fields, 554
layout objects, 145
parameters, 555
private functions, 466
scripts, 289
Custom Web Publishing, 290
tables, associating with, 290
subscripts, 289
table occurrences, 238
user fields, 554
native user interface, 417
navigating
array elements, 457
databases, 84
FileMaker Pro, 40
layouts, 41-42
navigation scripts, 301
internal navigation, 302
nesting functions, 265, 269-270
networks
connectivity, FileMaker Server requirements, 791
launch files, 366
security, 394
team development, 368-369
new command, 742
New Record option (FileMaker Mobile), 838
no records found error messages, 726
nonequijoins, 220-221
nonequijoins, troubleshooting, 245
nontext calculations, troubleshooting text formatting functions, 473
normalizing data, 184-185
first normal form, 184-185
second normal form, 185
NthRoot functions, 467
Number Field elements, 365
number functions, 270
Abs functions, 272
Ceiling functions, 271
Div functions, 272
Floor functions, 271
Int functions, 271
Mod functions, 272
Random functions, 272
Round functions, 271
Truncate functions, 271
Number of Repetitions option (Specify Calculation dialog), 257
numerical comparison searches (CWP URL searches), 727
Object Grids command (Arrange menu), 143
objects
layout objects
adding to layouts, 137-138
aligning, 147
centering, 147
duplicating, 140-141
Format Painter tool, 139
grouping/ungrouping, 146
layering, 148
locking/unlocking, 147
moving, 142
object grids, 143
positioning, 141-142
resizing, 142
selecting, 141
setting default format attributes, 139-140
Size palette, 143-145
sliding, 148
specifying attributes, 139
stacking orders, 148
Tab Control objects, adding to layouts, 150-152
ODBC (Open Database Connectivity), 604
applications, 604-605
database configuration, 605-607
drivers, installing, 607-608
DSN
configuring on Mac OS X, 611-612, 615
configuring on Windows OS, 616-617
external data sources
adding to Relationships Graph, 620
specifying, 618-622
importing data into FileMaker, 617
Mac OS X administration, 609
data source names, 610
drivers, 611
Windows administration, 609
data source names, 610
drivers, 611
ODBC/JDBC, Access via ODBC/JDBC extended privilege, 391
off-the-shelf software, 16
OLE support, container fields, 61
Omit check box, troubleshooting, 548
Omit Record command (FileMaker Pro), 75
one-to-many relationships (entities), 170, 173
building
adding tables to multitable systems, 199
building first tables in multitable systems, 197
foreign/primary keys, 180
optionality
loose binding, 177
tight binding, 177-178
one-to-one relationships (entities), 172
optionality, 178
Only During Data Entry option (Validation dialog), 109
open files, backups, 788
Open Record/Request script step, 359
Open Remote File dialog (FileMaker Pro), 51
opening
databases on LANs, 51
FileMaker Pro databases, 48
local files, 48
remote files, 50
files, troubleshooting, 399
operators
CWP operators, 727
relationship operators, portals, 496
selecting in calculation formulas, 254
Operators feature (Specify Calculation dialog), 98, 254
optimizing interfaces, 418-419
optionality (entity relationships), 174
many-to-many relationships, 175-176
one-to-many relationships
loose binding, 177
tight binding, 177-178
one-to-one relationships, 178
Options menu (FileMaker Mobile), 840
Database Options, 841-842
Backup at HotSync option, 841
Include in Global Find option, 841
Login option, 841
Synchronize Database option, 841
Field Options, 841
Form View Options, 841
List View Options, 841
OR conditions, troubleshooting multiple-match relationships, 246
Or filters (filtered portals), 509-510
organizing databases, multi-file structures, 240
data/application logic separation, 242-243
file maintenance, 241
reusability, 244
shared development, 240
other values (value lists), 58
PadCharacters functions, 469
padding data (fixed-width formats), 658-659
Page Break Before Each Occurrence option (Part Definition dialog), 137
fieldname, 742
Fieldname.op, 743
naming, 555
nesting functions, 265
script parameters
modularizing scripts, 484-485
passing, 480
passing data between files, 485
passing multi-valued parameters, 480-483
retrieving, 480
specifying, 479
parent entities, 173
in child files, 210
parse errors, troubleshooting, 685
Part Definition dialog, 136
Alternate Background Fill feature, 137
Page Break Before Each Occurrence option, 137
Part Setup dialog, 134
Part Setup dialog (Layout mode), 331
Sub-Summary When Sorted Bu option, 332
passwords
Allow User to Modify Their Own Password option (Edit Privileges dialog), 390
Change Password script step, 400
converted passwords, troubleshooting, 398
forgotten passwords, troubleshooting, 398
IWP, 702
Reset Account Password script step, 400
securing, 377-378
security, 390
Paste option (container fields), 61
Paste script steps, 301
PatternCount functions, 266
pause states, 528-529
PDAs (personal data assistants), FileMaker Mobile
Edit menu, 840
FileMaker database synchronization
adding/removing files, 842
configure settings, 847
field configuration settings, 844-845
permission settings, 843-844
synchronization settings, 845-847
user settings, 847
Find Records dialog, 839
Form view, 835-836
installing on, 833-834
List view, 835
Mobile Settings dialog
Specifying Fields button, 844
Synchronization button, 845-846
Options menu, 840
Database Options, 841-842
Field Options, 841
Form View Options, 841
List View Options, 841
Record Functions menu, 838-839
related data, publishing, 849
Settings button, 843
troubleshooting, 848-849
PDF documents
reports, saving/sending as, 342-344
saving, 79
peer-to-peer database hosting versus FileMaker Server, 787
peer-to-peer hosting, 21
Perform button (ScriptMaker Interface), 289
performance, troubleshooting, 560
calculation slowness, 562
general slowness, 561
script slowness, 562-563
searching/sorting slowness, 561
phone directory flat files, example of, 18
photos, importing from digital cameras, 642, 644
PHP, 750
extended privileges, configuring, 751
layouts, reviewing, 752
placing files on Web server, 752-753
preparing FileMaker Server for, 752
PHP Site Assistant, 753
FileMaker Server, connecting to, 755-756
launching, 754
layout group, selecting, 756
PHP files, specifying location for, 759
site profile
options, specifying, 757-759
visual style, specifying, 759
site profile, selecting, 756-757
pictures, adding to layouts, 139
plug-in functions, 779
plug-in management feature (FileMaker Server), 788
plug-ins, 778
automatically updating via FileMaker Server, 820, 822, 824-827
AutoUpdate plug-in enabling, 822
FMSUAC_FindPlugin function, 823-824
FMSUAC_UpdatePlugin function, 823, 825-826
FMSUAC_Version function, 823
configuring, 781
deploying via FileMaker Server, 781
downloading, 825-826
enabling, 781
identity functions, 824-825
installing, 780
Mac plug-ins for Windows servers, 821
names, accessing, 824-825
plug-in functions, 779
sample FileMaker Developer plug-in, functions of, 780
troubleshooting, 782
uses of, 780
version numbers, accessing, 824-825
writing, 779
plus sign (+) operators, 254
Pop-up menu formats (fields), 56
Pop-Up Menu option (Field/Control Setup dialog), 154
pop-up windows, troubleshooting, 547
port numbers, IWP configruation, 693
Port section (URL), 723
portal rows, deleting, 67
Portal Setup dialog, 204
Allow Creation of Records in This Table via This Relationship option, 503
Reset Scroll Bar When Exiting option, 503
setup options, 500
Show Related Records From list, 204
Portal Setup dialog (Status Area, Layout mode), 498
Allow Deletion of Portal Records option, 500
row setup options, 500
sorting criteria, specifying, 499
portals, 496
calendars, creating, 505
configuring, 203
display-only portals, 503
dynamic portal sorting, 511
ascending/descending sorting, 513-514
establishing sort buttons, 512
managing screen refresh, 512
multiple field type sorting, 512-513
filtered portals, 505
And filtered portals, 508
Or filters, 509-510
horizontal portals, 504
indexing, 497
IWP application flow, 710
layouts, adding to, 498-499
List View versus, 497
mechanics of, 67
multi-user selected data, troubleshooting, 515
records
deleting, 500
related records, cascading deletions, 502
related records, creating, 501, 503
related records, sorting, 503
related child data, viewing, 202-205
related records, adding to master records, 207
relationship operators, 496
relationships
related records, cascading deletions, 502
related records, creating, 501, 503
related records, sorting, 503
selection portals, 530-533
repeating portals, troubleshooting, 216
rows
creating related rows for nonequijoin relationships, 515
displaying, troubleshooting, 515
highlighting, troubleshooting, 547
setup options, 500
buttons, defining, 533
data structures, defining, 531
highlighted row relationships, 535
highlighting rows, 533-534
multiple row selections, 535-537
navigating in highlighted rows, 535
value lists versus, 531
sorting, 68
criteria, specifying, 499
sticky portals, 503
Table View versus, 497
x (cross-product operators), 496
[GT] operators, 496
Position functions, 266
positioning
layout objects, 141-142
windows, 520-525
pre-FileMaker 7 software, updating, 582
file conversion process, 583-584
multi-file conversions, 585-586
post-conversion tasks, 589-597
pre-conversion tasks, 589
creating documentation, 586-587
file references, fixing, 587-588
single-file conversions, 584-585
Preferences, differences between OS X and Windows platforms, 427
preparing FileMaker Server for PHP, 752
Preview mode
Copy command, 568
IWP, 702
multi-column layouts, 130
Set Sliding/Printing dialog, viewing effects in, 148
subsummary reports, 319
Preview mode (FileMaker Pro), 43
primary keys (entities), 179-180
fields, configuring, 201
process analysis, 190
Print button (ScriptMaker Interface), 289
printing
found sets, 77
layouts, sliding layout objects, 148
privileges, security, 389
records, 77
reports
formatting, setting, 319
troubleshooting, 345
scripts, 289
Printing tab (Layout Setup dialog), 128, 144
PrintSetUp_landscape scripts, 314
PrintSetUp_portrait scripts, 314
private functions, naming conventions, 466
privilege sets, 27. See also privileges
customizing, 383-384
multiple files, 399-400
reviewing, 380
user-level internal security, 381-382
conditional privileges, 385-386
data access, controlling, 383-384
data validation override privileges, 390
export privileges, 389
FileMaker Server disconnects, 390
layout use/development, 386-387
menu commands access, 390
passswords, setting, 390
printing privileges, 389
run script privileges, 388-389
value list access, 388
Privilege Sets tab (Accounts and Privileges menu), 698
privileges
data, exporting, 652
extended privileges
Access via FileMaker Mobile privilege, 391
Access via FileMaker Network privilege, 391
Access via Instant Web Publishing privilege, 391
Access via ODBC/JDBC privilege, 391
Access via XML Web Publishing privilege, 391
Access via XSLT Web Publishing privilege, 392
user-level internal security, 391-393
full access, 291
troubleshooting, 399
Privilege Sets tab (Define Accounts & Privileges dialog), 382
Custom Privileges dialog, 383
Create setting, 384
Delete setting, 384
Edit setting, 384
Field Access setting, 384
View setting, 384
Edit Privilege Set dialog, 383
Edit Privileges dialog
Allow Exporting dialog, 389
Allow Printing dialog, 389
Allow User to Modify Their Own Password option, 390
Allow User to Override Data Validation Warnings option, 390
Available Menu Commands option, 390
Custom Value List Privileges dialog, 387-388
Data Access and Design dialog, 388-389
Disconnect User from FileMaker Server When Idle option, 390
Layouts drop-down list, 386
Manage Extended Privileges option, 392-393
Records setting, 385-386
[Full Access] privilege set option, 382
proactive troubleshooting
calculations, debugging, 560
code, writing
comments, 555-556
naming database files, 553
naming fields, 554
naming functions, 555
naming layouts, 554
naming parameters, 555
failure, planning for, 557
file maintenance, 572
scripts,
debugging, 575-578
error handling, 557-559
process analysis, 186
attributes, adding, 190
entities, determining, 187-189
process command, 742
processing instructions
query parameters, embedding in stylesheets, 739-740
query strings, 740
processors, FileMaker Server requirements, 790
programming, writing code
comments, 555-556
naming database files, 553
naming fields, 554
naming functions, 555
naming layouts, 554
naming parameters, 555
Protocol section (URL), 723
public functions, 466
Publishing Engine Configuration page (WPAC), 696
Quarter functions, 467
queries
relationships as
multiple-match relationships, 223-226
multiple-match relationships, troubleshooting, 246
nonequijoins, troubleshooting, 245
table occurrences, 222-223
strings
name-value pairs, 724
processing instructions, 740
XML publishing, 724
XSLT, 739
Query-string section (URL), 724
Quote function, audit trail auto-entry techniques, 364
Radio button set formats (fields), 56
RAM (random access memory), FileMaker Server requirements, 790
Random functions, 272
Re-login script step, 400
recid URL parameters, 743
Record Functions menu (FileMaker Mobile)
Delete All Records option, 838
Delete Record option, 838
New Record option, 838
Sort Records option, 839
record pointers, table context, 569
records
child records, 67
committed records, 54
creating in FileMaker Pro, 54
CWP URL searches, 725-726
deleting from FileMaker Pro, 54
exporting data from all records, 653
found sets, 68-69
layouts, displaying in, 159
locking, 358
trapping in scripts, 359-360
multiple records, sorting, 76
Omit Record command (FileMaker Pro), 75
portals, 64
creating/deleting rows, 67
mechanics of, 67
sorting, 68
printing, 77
security, calculation formulas, 253
Show All Records command (FileMaker Pro), 75
timestamps, 362
Records option (Synchronization button), 846
Records setting (Edit Privileges dialog), 385-386
Recover command (FileMaker Pro), troubleshooting, 81
recovering files, 571
Recovery command, 571
recursive functions, 464
recursive scripts, 493, 549-550
redundant file references, eliminating before migration, 588
refactoring, 463
references, importing, 641
related fields, exporting, 657
related records (portals)
cascading deletions, 502
master records, adding to, 207
sorting, 503
troubleshooting, 312
related rows, creating for non-equijoin relationships, 515
relational databases, 15-16, 19
designing
as iterative process, 170
attributes, 165-169
entities, 165-169
entity keys, 179-180
entity relationships, 170-180
ERD notation, 170-171, 175-176, 178
ERD, one-to-one relationships, 171
process analysis, 186
process analysis, adding attributes, 190
process analysis, determining entities, 187-189
equijoins, 26
example of, 18
key fields, 18
Relationship Graphs
ERD, 218
external tables, adding to, 238
managing, 246-247
multiple-match relationships, 225-226
relationship operators, portals, 496
relationships (entities), 170. See also relationships (portals)
as queries
multiple-match relationships, 223-226
multiple-match relationships, troubleshooting, 246
nonequijoins, troubleshooting, 245
table occurrences, 222-223
bidirectional, 224-225
cardinality, 174
cross-product relationships, building, 232-233
file references, building, 234-237
FileMaker Pro 9 changes, 26
many-to-many relationships, 173-174, 181-182, 192-194
examples of, 184
optionality, 175-176
many-to-one relationships, 173
multiple-match relationships
building, 223-226
OR conditions, troubleshooting, 246
multiple tables, building in, 199-201
nonequijoins, 220-221
notation, 170-171
many-to-many optionality relationships, 175-176
one-to-one optionality relationships, 178
one-to-many relationships, 170, 173
building, 197-199
foreign/primary keys, 180
optionality, 177-178
one-to-one relationships, 172
optionality, 178
optionality, 174
many-to-many relationships, 175-176
one-to-many relationships, loose binding, 177
one-to-many relationships, tight binding, 177-178
one-to-one relationships, 178
selection portal highlighted row relationships, establishing, 535
with global values, building, 229, 232
relationships (portals)
related records, cascading deletions, 502
related records, creating, 501-503
related records, sorting, 503
buttons, defining, 533
data structures, defining, 531
value lists versus, 531
Relationships Graph
Add Table Occurrence icon, 237
cardinality, 201
Edit Relationship dialog, 206
Allow Creation of Records in This Table via This Relationship check box, 207
FileMaker Pro 9 changes, 25
shadow fields, 623-624
Specify Table dialog, 222
table occurrences, 199
Relationships tab (Define Database dialog), 89
relative paths, 588
remote files, opening in FileMaker Pro, 50
remote stylesheets (XSL), 673
removing
Admin access via Developer Utilities (FileMaker Developer), 775
records from FileMaker Pro, 54
renaming files
Developer Utilities (FileMaker Developer), 769
file reference errors, 783
reordering
script steps, 291
subsummary reports, 339
repeating fields, 111
character transformations (exporting data), 653
repeating portals, troubleshooting, 216
RepeatText functions, 468
repetitions, calculation fields, 257
replacing
data, globally replacing, 82-83
files in runtime applications, 773
reports
characteristics of, 316
creating
generic versus specific report structures, 318
requirements, determining, 317
workflows, incorporating into, 346-347
customizable list reports, building, 440-443, 445-446, 448
designing
aesthetics, 322
alternating row color, 321
detail records, displaying, 329
horizontal/vertical dividers, 322-324
repeating fields for column highlights, 327
sortable column headers, 324-329
trailing summaries, 320
email, sending as, 345
Excel (MS) documents, saving/sending as, 344
list view layouts, 318-320
printing, hiding elements before, 319
viewing, 318
PDF, saving/sending as, 342-344
printing, 319
charting, 341
creating without body parts, 341
labels, 334
reordering, 339
summarizing multiple criteria, 338
summary fields, 335-336
summary fields, calculations, 336-337
viewing, 318
troubleshooting printed reports, 345
reproducing errors (script error handling), 559
Reset Account Password script step, 400
Reset Scroll Bar When Exiting Record option (Portal Setup dialog), 503
Resize To alignment tools (Arrange menu), 142
Resize To command (Arrange menu), 147
resizing
layout parts, 135
restricted deletes, troubleshooting, 216
restricting
custom function access, 466
user access to layouts, 131-132
results (scripts), returning, 486
retrieving container field information, 61
Revert Record command
records, deleting from FileMaker Pro, 54
troubleshooting, 81
RGB functions, 453
RightValues functions, 456
troubleshooting, 474
rollbacks, 366
dialog windows, designing, 527
Round functions, 271
rows
color, alternating in reports, 321
multiple row selections in selection portals, 535-537
portal rows
creating/deleting, 67
displaying, troubleshooting, 515
highlighting, troubleshooting, 547
setup options, 500
related rows, creating for non-equijoin relationships, 515
selection portal rows
highlighted row relationships, 535
highlighting, 533-534
navigating in highlighted rows, 535
runtime applications
bind keys, adding/replacing files, 773
creating via Developer Utilities (FileMaker Developer), 771, 774-775
database extensions, 773
Runtime Name option (Solution Options), 773
runtime solutions, solution deployment, 768
SAT (Server Admin Tool). See Admin Console
Save As Excel scripts, 344
Save As option (FileMaker Pro), 54
Save Records as PDF scripts, 344
saved scripts, 302
Find script steps, 303
Sort script steps, 304
saving
container field information, 61
Excel documents, 79
PDF documents, 79
records. See committed records
reports
Excel (MS), 344
scheduling backups, 808
FileMaker Server maintenance, 829
scheduling feature (Admin Console), 806-808
schema imports (tables), 215-216
scope (variables), 490
scratch-building custom menus (user interfaces), 428
screen size, building windows, 519
script.prefind URL parameters, 743
script-presort URL parameters, 744
script completion, Allow User Abort scripts, 298
Script Debugger, 575-577
breakpoints, placing, 578
values, inspecting, 578
script libraries, building, 313
script logs, 357
script results, 478
script steps
Add Account, 399
calculation formulas, 252
Change Password, 400
Commit Record/Request, 360
Delete Account, 400
Enable Account, 400
If - Else If, 360
Open Record/Request, 359
Re-login, 400
Reset Account Password, 400
scripted imports, 644-645
ScriptMaker Interface, 289
Define Scripts dialog, 287
Indicate Web Compatibility check box, 703
Perform button, 289
Print button, 289
scriptnames command, 742
scripts, 284
abstraction, 294
Allow User Abort scripts, 298
branching, conditional script steps, 305-306
buttons
building, 311
objects, associating with, 297
calculated replaces, 563
comments, 292-293
proactive troubleshooting, 556
conditional scripts, troubleshooting, 312
creating, 285
custom dialogs, 309-310
data configuration scripts, 299
Copy script steps, 301
Cut script steps, 301
Go to Field script steps, 300
Paste script steps, 301
Set Field script steps, 300-301
data control scripts, 299
Copy script steps, 301
Cut script steps, 301
Go to Field script steps, 300
Paste script steps, 301
Set Field script steps, 300-301
data editing, 362
inspecting values, 578
looping scripts, 578
placing breakpoints, 578
Define Scripts dialog, 289
duties of, 284
editing, 290
Get(LastError) function, 558
reproducing errors, 559
Set Error Capture scripts, 558
error management scripts, 298
Allow User Abort scripts, 298
Set Error Capture scripts, 298-299
errors (IWP application logs), 695
executing, 289
exiting, 293
exporting data, 660
full access privileges, 291
Go to Related Record scripts, 537-538
disconnected table occurrences, jumping to, 543
predicting found sets, 541-542
usage examples, 539
Go To Related Records scripts versus searches, 563
hiding, 296
implementing, 287
InitializeGlobals scripts, 313
IWP, 702
committing records, 704
IWP execution tests, 705
startup/shutdown scripts, 704
subbscript calls, 705
unsupported script steps, error capturing, 704
unsupported script steps, identifying, 703
libraries, building, 314
loops, 307
calculated replaces, 563
conditional script steps, 308
debugging, 578
exit conditions, 308
exiting, 308
testing, 313
managing, 287-289
mode dependencies, table context, 568
modularizing, 484-485
Move/Resize Window, 518
moving, 287
multi-context locking, 361
multiple scripts, selecting, 289
naming, 289
Custom Web Publishing, 290
tables, associating with, 290
parameters
modularizing scripts, 484-485
passing, 480
passing data between files, 485
passing multi-valued parameters, 480-483
retrieving, 480
specifying, 479
printing, 289
PrintSetUp_landscape scripts, 314
PrintSetUp_portrait scripts, 314
record creation slowness, troubleshooting, 563
record locking, trapping, 359-360
troubleshooting, 368
record pointers, table context, 569
reordering script steps, 291
results
Get(ScriptResult) function, 486
returning, 486
usage examples, 486
run privileges, security, 388-389
Save As Excel, 344
Save Records as PDF, 344
saved scripts, 302
Find script steps, 303
Sort script steps, 304
script steps, 299
Commit Record/Request, 360
conditional script steps, 305-308
Copy script steps, 301
Cut script steps, 301
Else If script steps, 305-306
Else script steps, 305-306
End If script steps, 305-306
Find script steps, 303
Go to Field script steps, 300
Go to Layout script steps, 301
If - Else If, 360
If script steps, 305-306
My Set Field script steps, 312
Open Record/Request, 359
Paste script steps, 301
Set Field script steps, 300-301
Show Custom Dialog script steps, 309
Sort script steps, 304
ScriptMaker Interface
Define Scripts dialog, 287
Perform button, 289
Print button, 289
ScriptTEMPLATE scripts, 314
Send Mail, 345
Set Error Capture scripts, 298-299, 558
Set Variable script step, 489
ShutDown scripts, 313
shutdown scripts, IWP, 704
slowness (performance), 562-563
StartUp scripts, 313
startup scripts, IWP, 704
IWP, 705
naming, 289
table context, 568
templates, 293
ToggleAllStatusAreas scripts, 313
ToggleMultiUser scripts, 313
triggering, 310
unfinished scripts, troubleshooting, 312
user access, security, 377
user navigation scripts, 301
internal navigation, 302
variables
dynamic file paths, 492
global variables, 490-491
local variables, 488-491
naming, 488
scope, 490
Set Variable script step, 489
viewing, 492
Web Viewer, controlling, 411
ScriptTEMPLATE scripts, 314
searches
dedicated find layouts, 545
Find mode layouts, 546
script-driven finds, 546
HTML-formatted search result stylesheets, building, 738
URL format, 738-739
searching
slowness in, 561
unindexed fields, 561
versus Go To Related Records scripts, 563
securing Kiosk mode via Developer Utilities (FileMaker Developer), 776
security
access privileges, troubleshooting, 399
Custom Menus feature, 376
Edit Account dialog (Define Accounts & Privileges dialog), 381
file-level access security, 393
external authentication, 396-397
file list filtering, 398
networks, 394
server administration, 393
user authentication, 395
FileMaker Pro 8, 27
authenticating accounts/privileges, 700
extended priveleges, 698
passwords, 702
layouts, viewing, 128
multiple files, privilege sets, 399-400
opening/closing files, troubleshooting, 399
passwords, 377-378
post-conversion fixes, 591
troubleshooting, 398
planning
aesthetics, 376
implementation, 376
script access, 377
user access, 377
user interfaces, 376
post-conversion fixes, 590
primary concerns, 372
records, calculation formulas, 253
relationships, post-conversion fixes, 591-592
risks, identifying, 373
scripts, post-conversion fixes, 592-595
user-level internal security extended privileges, 391-393
privilege sets, 381-389
Select All command (Edit menu), 142
Select Arrange toolbar, Select Objects by Type button, 142
Select Objects by Type button (Select Arrange toolbar), 142
selecting
CWP technology, 750
fields in calculation formulas, 254
functions in calculation formulas, 255
layout objects, 141
multiple rows in selection portals, 535-537
multiple scripts, 289
operators in calculation formulas, 254
buttons, defining, 533
data structures, defining, 531
rows
highlighted row relationships, 535
highlighting, 533-534
multiple row selections, 535-537
navigating in highlighted rows, 535
value lists versus, 531
Self function, 434
Send Backward command (Arrange menu), 148
Send Mail scripts, 345
Send to Back command (Arrange menu), 148
serial IDs, 358
serial key fields, creating, 104
Serial Number option (field auto-entry options), 104-105
server administration, security, 393
server hosting, 22
Server-IP section (URL), 723
server-side XSLT, CWP, 730
building HTML-formatted search result stylesheets, 738-739
embedding query parameters in stylesheets, 739-740
stylesheet placement, 730
servers
Active Directory servers
FileMaker Server registration, 814-815, 817
troubleshooting registration, 827
connections, troubleshooting, 563-564
directory servers, FileMaker Server registration, 813
FileMaker Server, 786
access, troubleshooting, 746
Active Directory server registration, 814-815, 817
Auto Update feature, 820
automatically updating plug-ins, 820, 824-827
automatically updating plug-ins, FileMaker Pro configuration, 822
automatically updating plug-ins, FileMaker Server configuration, 822
configuring external authentication services, 820
Consistency Checker, 788
database hosting, 801
directory server registration, 813
external authentication feature, 788
LDAP Server registration, 813-814
maintenance, database directory structures, 829
maintenance, file maintenance, 830
maintenance, hardware requirements, 828
maintenance, monitoring event logs, 830
maintenance, monitoring usage statistics, 829
maintenance, network infrastructures, 828
maintenance, scheduling backups, 829
maintenance, server configuration, 829
maintenance, software installation, 828
maintenance, software updates, 830
plug-in management feature, 788
RAM, 790
requirements of, 789-791
SAT, 788
SAT, troubleshooting server registration, 827
SSL data transfer feature, 789
starting/stopping, 801
troubleshooting performance, 561
versus peer-to-peer database hosting, 787
viewing registered servers via LDAP Server, 818
LDAP Server
FileMaker Server registration, 813-814, 827
viewing registered FileMaker Servers, 818
Windows servers, Mac plug-ins, 821
session management, 745-746
IWP, 708
sessions, 352-353
database tracking, 354
globals, 353
login accounts, 354
troubleshooting, 367
logins
testing, 367
troubleshooting, 367
session-specific elements, 353
Set Error Capture scripts, 298-299, 558
Set Field script, 300-301
portal record creation, 503
Set Layout Order dialog, 130
Set Sliding/Printing dialog, 148
Also Reduce the Size of the Enclosing Part option, 149
layout objects, nonprinting option, 149
Preview mode, viewing effects in, 148
Set Tab Order dialog, 156-157
Set Variable script step, 489
Settings button (FileMaker Mobile), 843
shadow fields, 623-624
sharing IWP files, 699
sharing data between stylesheets, 740-741
Show All option (FileMaker Mobile), 839
Show All Records command (FileMaker Pro), 75
Show Custom Dialog script step, 309
Show in New Window option (Go to Related Record Options dialog), 539-540
Show Only Related Records option (Go to Related Record Options dialog), 539-540
Show Related Records From list (Portal Setup dialog), 204
Show/Hide Status Area script step (IWP), 709
shutdown scripts, 313
IWP, 704
simplifying complex formulas, 462
single-file conversion solutions, 584-585
single-user database deployment, 21
site profile
options, specifying, 757-759
selecting with PHP Site Assistant, 756-757
visual style, specifying, 759
Size palette, 143-145
layout parts, sizing, 135
sizing
layout parts, 135
IWP layout design restrictions, 706
table occurrences, 247
sizing handles, resizing layout objects, 142
skip URL parameters, 744
sliding layout objects, 148
Sliding/Printing dialog (Layout mode), 319
slowness (performance)
calculations, 562
general slowness, troubleshooting, 561
scripts, 562-563
calculated replaces, 563
Go To Related Records scripts, 563
record creation, 563
searching/sorting slowness, 561
SOAP, 681
software
custom development software, 16
database software
advantages of, 14
as custom development software, 16
as off-the-shelf software, 16
functions of, 14
functions of, employee table example, 17
functions of, phone directory flat file example, 18
functions of, relational database example, 18
installing, FileMaker Server maintenance tips, 828
off-the-shelf software, 16
updates, FileMaker Server maintenance, 830
Solution Options (Developer Utilities), 771
Bindkey option, 773
Closing Splash Screen option, 774
Custom Image option, 774
Extension option, 773
Runtime Name option, 773
solutions
customizing via Developer Utilities (FileMaker Developer), 777
deploying runtime solutions, 768
kiosks, 768
runtime solutions, solution deployment, 768
sortorder command, 729
sortorder URL parameters, 744
Sort Records option (Edit Relationship dialog), 502
Sort Records option (FileMaker Mobile), 839
Sort script step, 304
Sort Status (Status Area), 43
sortfield command, 729
URL parameters, 744
column headers (reports), 324-327
ascending/descending logic, 328-329
CWP URL search results, 729
dynamic portals, 511
ascending/descending sorting, 513-514
establishing sort buttons, 512
managing screen refresh, 512
multiple field type sorting, 512-513
IWP records, 713
multiple records, 76
multitiered sorting, 84
portal records, 503
portals, 68
specifying sorting criteria, 499
slowness in (performance), 561
unindexed fields, 561
value lists (fields), 76
source tables, exporting data, 650
spacing in CWP URL, troubleshooting, 747
specific report structures versus generic report structures, 318
Specify Calculation dialog, 98, 250, 253
Calculation Context section, 260-261
Calculation Result Is feature, 99-100
Data Type option, 257
Do Not Evaluate If All Referenced Fields Are Empty check box, 257-258
Field List, 254
Field list feature, 98
Formula box, 253
Formula text box feature, 99
Number of Repetitions option, 257
Operators feature, 98
Operators section, 254
Specify Table dialog (Relationships Graph), 222
specifying external ODBC data sources, 618-622
Specifying Fields button (FileMaker Mobile), 844
spell-checking, IWP, 702
SQL, 604
troubleshooting, 625
SSL data transfer feature (FileMaker Server), 789
stacking orders, layout objects, 148
Standard Deviation of function (summary fields), 101
Standard Form layouts, 122
star joins, 194
Starter Solutions, Issue Tracker, 402-404
starting/stopping FileMaker Server, 801
startup scripts, 313
IWP, 704
Status Area (FileMaker Pro), 41
Book icon, 42
Browse mode, 41
Current Record Numbers, 42
Found Record Numbers, 43
Layout menu, 42
Layout mode, 137-139
Portal Setup dialog, 498-500
Mode menu, 43
modes, changing, 44
Sort Status, 43
Status Area toggle, 43
Tab Control Setup dialog, 150-152
Total Record Numbers, 43
Zoom icons, 43
status area (IWP)
Commit button, 709
hiding application flow, 709-710
house icon, 696
Log Out button, 695
Status Area toggle, 43
sticky portals, 503
Storage Options dialog
Global Storage option, 259
Indexing option, 259-260
Automatically Create Indexes as Needed check box, 259
Do Not Store Calculation Results check box, 259
storing fields
globals, 110
repeating fields, 111
strings (text)
case altering functions, 268
concatenation, 266
defining, 265
Exact functions, 267
interrogating, 266
Length functions, 266
PatternCount functions, 266
Position functions, 266
Substitute functions, 268
text parsing functions, 269
Trim functions, 267-268
WordCount functions, 267
structured data elements, passing multi-valued script parameters, 483
stylehref URL parameters, 744
stylesheets (XSL), 668-669
Amazon XML data, transforming to FMPXMLRESULT XML, 682-684
FileMaker data, exporting as XML, 673
HTML-formatted search result stylesheets, building, 738
URL format, 738-739
query parameters, embedding in, 739-740
remote stylesheets, 673
sharing data, 740-741
specifying for iPhone, 848
WPE directories, placement in, 730
XML data, importing to FileMaker, 678-679
XML declarations, 670
xsl:choose statements, 672
xsl:output statements, 671
xsl:stylesheet statements, 670
xsl:template statements, 671
styletype URL parameters, 744
styling text, 84
Sub-Summary When Sorted By option (Part Setup dialog), 332
IWP, 705
naming, 289
Substitute functions, 268
mulit-column layouts, 130
charting, 341
creating, 331-333
without body parts, 341
labels, 334
multiple criteria, summarizing, 338
reordering, 339
summary fields, 335-336
calculations, 336-337
troubleshooting, 334
slow generation, 345-346
viewing, 318
summarizing multiple criteria in subsummary reports, 338
Average of function, 101
Count of function, 101
Fraction of Total of function, 101
Maximum function, 101
Minimum function, 101
Standard Deviation of function, 101
subsummary reports, 335-336
calculations, 336-337
reordering in, 339
Total of function, 101
summary reports, 320
SYLK (Symbolic Link) file format (exporting data), 654
Synchronization button (FileMaker Mobile), 845
Actions option, 847
Conflict Resolution option, 846
Mode option, 845
Records option, 846
Synchronize Database option (FileMaker Mobile), 841
synchronizing FileMaker Mobile and FileMaker databases, 842
adding/removing files, 842
configure settings, 847
field configuration settings, 844-845
permission settings, 843-844
synchronization settings, 845-847
user settings, 847
Tab character transformations (exporting data), 653
Tab Control object (FileMaker Pro), 47
Tab Control Setup dialog (Status Area), 150-152
accessing, 150
tab order, fields, 155-156
tab-separated text format (exporting data), 654
table context (layouts), 725
calculations, troubleshooting, 567
importing/exporting records, troubleshooting, 567
layouts, troubleshooting, 567
mode dependencies, troubleshooting, 568
record pointers, troubleshooting, 569
scripts, troubleshooting, 568
troubleshooting, 566
value lists, troubleshooting, 568
Table menu (Define Database dialog), Table Name box, 199
table occurrences, 25, 199, 222-223
Go to Related Record scripts, 543
layouts, 125
naming conventions, 238
sizing, 247
layouts, 123
user interfaces, 431
versus portals, 497
tables
CWP URL searches, 725
definitions
copying/pasting, 216
importing between files, 215
employee tables, example of, 17
external tables, adding to Relationship Graphs, 238
join tables, naming, 553
layouts, viewing as, 128
multifile table systems, 233-234
external data sources, 234
multiple tables, portals, 202-205, 207
multitable systems, building first tables in, 197
multitable systems, adding to, 199
portals, 64
creating/deleting rows, 67
mechanics of, 67
sorting, 68
schema imports, 215-216
tabs, text, applying to, 85
tar archives, Mac plug-ins, 821
templates
scripts, 293
Web Viewer, 410
testing
Boolean tests, Choose functions, 438
conditional tests, Choose functions, 437
logins, 367
loops, 313
text
formatting functions, troubleshooting in nontext calculations, 473
misspellings, fields, 55
styling, 84
tabs, applying, 85
text arrays, passing multi-valued script parameters, 481
Creation Account Names fields, 107
Modification Account Names fields, 107
text files, importing, 638-640
text formatting functions, 452
RGB functions, 453
TextColor functions, 453
TextColorRemove functions, 454
TextFont functions, 453
TextFontRemove functions, 454
TextFormatRemove functions, 454
TextSize functions, 453
TextSizeRemove functions, 454
TextStyleAdd functions, 453-454
TextStyleRemove functions, 453-454
text functions, 265
case altering functions, 268
Exact functions, 267
Length functions, 266
PatternCount functions, 266
Position functions, 266
Substitute functions, 268
text parsing functions, 269
Trim functions, 267-268
WordCount functions, 267
text parsing functions, 269
text strings
case altering functions, 268
concatenation, 266
defining, 265
Exact functions, 267
interrogating, 266
Length functions, 266
PatternCount functions, 266
Position functions, 266
Substitute functions, 268
text parsing functions, 269
Trim functions, 267-268
WordCount functions, 267
TextColor functions, 453
TextColorRemove functions, 454
TextFont functions, 453
TextFontRemove functions, 454
TextFormatRemove functions, 454
TextSize functions, 453
TextSizeRemove functions, 454
TextStyleAdd functions, 453-454
TextStyleRemove functions, 453-454
thumbnails, importing, 641-642
time fields, 59
Creation Timestamp fields, 107
Modification Timestamp fields, 107
time fields, 97
timestamp fields, 97
Time functions, 272-274
timestamp fields, 59
TimeStamp functions, 273-274
timestamps, 362
Title Footers, 134
Title Headers, 133
ToggleAllStatusAreas scripts, 313
ToggleMultiUser scripts, 313
token URL parameters, 744
tokens, sharing data between stylesheets, 740-741
tool palettes (multi-window interfaces), 526
Tools menu, Data Viewer
Debug Scripts feature, 580
expressions, defining, 579
values, inspecting, 578
tooltips, layouts, 157
Top to Bottom alignment option (Align command), 147
Total of function (summary fields), 101
Total Record Numbers (Status Area), 43
tracking database sessions, 354
Trailing Grand Summaries, 133
trailing grand summaries, multi-column layouts, 130
trailing summaries (reports), 320
transactions (databases), 355
transferring data, SSL data transfer, 789
transformations (XML), 667-668
Amazon XML data, transforming to FMPXMLRESULT XML, 682-684
FileMaker data, exporting as XML, 673
XML data, importintg to FileMaker, 678-679
XSL stylesheets, 668-669
XML declarations, 670
xsl:choose statements, 672
xsl:output statements, 671
xsl:stylesheet statements, 670
xsl:template statements, 671
trapping
errors, troubleshooting, 368
record locking in scripts, 359-360
triggering scripts, 310
Trim functions, 267-268
TrimChar functions, 470
troubleshooting
Active Directory server registration, 827
audit logs, blank rows, 365
audit trails, 368
conditional scripts, 312
connectivity
Crosstalk, 564-565
server connections, 563-564
context, 566
layout dependencies, 566
table context, 566-569
conversions, 598
corrupted files, 81
CWP
spacing in URL, 747
URL requests, 746
data imports, 645
field validation, 646
data integrity, 81
data loss, 80
data types in calculation fields, 280
dialog window design, 548-549
error trapping, 368
field names in calculation formulas, 279
fields
copying/pasting, 159
field validation, 116
mismatched calculations, 115
mismatched data types, 115
naming conventions, 115
file recovery, 81
file reference errors, 783
FileMaker Mobile
found sets/sessions, 848
missing index values, 848-849
missing records, 849
FileMaker Server access, 746
firewalls, CWP URL requests, 746
globals, 570
default values, 367
IWP, ending sessions, 714
LDAP Server registration (FileMaker Server), 827
LeftValue functions, 474
Let functions, 474
logins, 367
MiddleValues functions, 474
modal dialog windows, 548-549
multiple-match relationships, 246
nonequijoins, 245
Omit check box, 548
performance, 560
calculation slowness, 562
general slowness, 561
script slowness, 562-563
searching/sorting slowness, 561
plug-ins, 782
pop-up windows, 547
portal rows, highlighting, 547
portals
displaying rows, 515
multi-user selected data, 515
proactive troubleshooting
debugging calculations, 560
debugging scripts, 575-578
file maintenance, 572
planning for failure, 557
scripts, error handling, 557, 559
writing code, comments, 555-556
writing code, naming database files, 553
writing code, naming fields, 554
writing code, naming functions, 555
writing code, naming layouts, 554
writing code, naming parameters, 555
records, displaying in layouts, 159
Recover command (FileMaker Pro), 81
related records, 312
repeating portals, 216
reports, printed reports, 345
restricted deletes, 216
Revert Record command (FileMaker Pro), 81
RightValues functions, 474
script error messages, 312
script steps, 312
security
access privileges, 399
converted passwords, 398
forgotten Admin passwords, 398
opening/closing files, 399
SQL, 625
subsummary reports, 334
slow generation, 345-346
text formatting functions, nontext calculations, 473
unfinished scripts, 312
user interfaces, showing/hiding layout elements, 548
ValueCount functions, 474
window construction, lost found sets, 547
WPE access, 746
XML imports, 685
XML stylesheets, 685-686
Truncate functions, 271
Tufte, Dr, Edward, Visual Display of Quantitative Information, The, 322
UI files, 420
Undo command (FileMaker Pro), 54
Undo option (FileMaker Mobile), 840
unfinished scripts, troubleshooting, 312
unindexable fields, 114
unindexed fields, searches/sorts, 561
unsupported script steps, IWP
error capturing, 704
identifying, 703
updating
custom functions, 463
plug-ins via FileMaker Server, 820, 822, 824-827
pre-FileMaker 7 software, 582
file conversion process, 583-584
multi-file conversions, 585-586
post-conversion tasks, 589-597
pre-conversion tasks, 586-589
single-file conversions, 584-585
records with imported data, 633-635
software updates, FileMaker Server maintenance, 830
URL
Amazon.com, importing data to FileMaker, 684-685
CWP URL requests, 746
exact match searches, 726-727
multiple criteria searches, 728
multiple find requests, 728-729
numerical comparison searches, 727
specific record searches, 725-726
specifying search result sort order, 729
table searches, 725
parameters
-db, 742
-encoding, 742
-field, 742
-grammar, 743
-lay, 743
-lay.response, 743
-lop, 743
-max, 743
-modid, 743
-recid, 743
-script, 743
-script-presort, 744
-script.prefind, 743
-skip, 744
-sortfield, 744
-sortorder, 744
-stylehref, 744
-styletype, 744
-token, 744
fieldname, 742
Fieldname.op, 743
Port section, 723
Protocol section, 723
query strings, 724
Server-IP section, 723
spacing in, troubleshooting, 747
XSLT URL formats, 738-739
user access, restricting in layouts, 131-132
user accounts
access privleges, troubleshooting, 399
privilege sets, reviewing, 380
user-level internal security, 378
Admin accounts, 379
automatic logins, 379
default accounts, 379
[Guest] accounts, 379
managing, 379-381
user authentication, security, 395
User button (FileMaker Mobile), 847
user features (FileMaker Pro 9), overview of new features, 24
user fields, naming, 554
user IDs, securing, 377-378
user interfaces
building, 417-418
look/feel, designing, 419-420
custom menus
components of, 422
editing, 426
FileMaker control of, 423
menu sets, assigning, 428
menu sets, loading/activating, 427-428
scratch-building, 428
uses of, 422
dedicated find layouts, 545
Find mode layouts, 546
script-driven finds, 546
design guidelines, 432
headers/footers, 431
layout elements, showing/hiding, 543-545, 548
multi-window interfaces
dialog windows, 526-529, 548-549
expanding windows, 529
hiding windows, 530
marquee titles, 529
tool/function palettes, 526
uses of, 526
native user interface, 417
prototype layouts/menus, 416
security plans, 376
Table view, 431
UI files, 420
user navigation scripts, 301-302
user-level internal security
extended privileges
custom privileges, 392-393
default privileges, 391-392
privilege sets, 381-382
conditional privileges, 385-386
data access, controlling, 383-384
data validation warning override privileges, 390
export privileges, 389
FileMaker Server disconnects, 390
layout use/development, 386-387
menu commands access, 390
passwords, setting, 390
printing privileges, 389
run script privileges, 388-389
value list access, 388
user accounts, 378
Admin accounts, 379
automatic logins, 379
default accounts, 379
[Guest] accounts, 379
managing, 379-381
validating data
fields, 107-109
calculation formulas, 252
condition failures, 108-109
troubleshooting, 116
override privileges, security, 390
Validation dialog, 107
Always During Data Entry option, 109
Only During Data Entry option, 109
Value from Last Visited Record option (field auto-entry options), 105
value indexes, 113-114
value lists
access privileges, security, 388
creating for many-to-many relationships, 212-213
IWP, 702
selection portals versus, 531
table context, 568
value lists (fields)
editing, 57-58
other values, 58
sorting, 76
ValueCount functions, 456
troubleshooting, 474
ValueListItems functions, 279
variables (scripts)
dynamic file paths, 492
globally stored fields versus, 491
naming, 490
scope, 490
user session data, 491
uses for, 491
local variables, 488
scope, 490
uses for, 491
naming, 488
scope
global variables, 490
local variables, 490
Set Variable script step, 489
viewing, 492
verifying processes, script logs, 357
vertical dividers (reports), 322-324
View As options, IWP layout design restrictions, 706
view command, 742
View setting (Custom Privileges dialog), 384
viewing
layouts
forms view, 127
lists view, 127
restricting user access, 128
tables view, 128
list view layouts, 318
plug-in names/version numbers, 824-825
related child data in multiple tables, 202-205
subsummary reports, 318
Views tab, Layout Setup dialog, 128
Visual Display of Quantitative Information, The, 322
visual style for PHP site, selecting, 759
Web pages, linking IWP files to, 710-711
Web publishing
Access via Instant Web Publishing extended privilege, 391–392
errors (IWP application logs), 695
Web services, 675
Amazon.com
accessing, 681
HTTP requests, 681
importing data to FileMaker, 682-685
SOAP, 681
types of, 681
URL, 663
writing, 686-688
web site
building with XSLT Site Assistant, 733-734
xslt-template files, modifying, 737-738
Web Viewer, 402
controls, adding, 411
current page, identifying, 412-413
files, viewing, 413
templates, 410
web-enabled databases, converting, 599
WeekEndingFriday functions, 467
wildcards
IP addresses, 694
searches, 72
window desktops, 519-520
window management, 518. See also windows
positioning windows, 520-525
screen size, 519
window content, 521
window desktop size, 519-520
WindowNames functions, 518
WindowNames functions, 279, 518
windows
building
positioning windows, 520-525
screen size, 519
troubleshooting, 547
window content, 521
window desktop size, 519-520
positioning, 520-525
troubleshooting, 547
Windows OS
ODBC administration, 609
data source names, 610
drivers, 611
DSN, configuring, 616-617
pop-up windows, troubleshooting, 547
servers, Mac plug-ins, 821
windowshades, table occurrences, 247
WKS file format (exporting data), 654, 656
Word (MS), formatting DDR as, 573
word indexes, 113
word separators, 267
WordCount functions, 267
workflows, incorporating reports into, 346-347
WPAC (Web Publishing Administration Console)
FileMaker Server Published Databases page, 696
Publishing Engine Configuration page, 696
WPE (Web Publishing Engine)
access, troubleshooting, 746
URL, troubleshooting, 747
XSLT
building HTML-formatted search result stylesheets, 738-739
stylesheet placement, 730
WPE (Web Publishing Engines)
CWP URL searches
exact match searches, 726-727
multiple criteria searches, 728
numerical comparison searches, 727
specific record searches, 725-726
table searches, 725
multiple find requests, 728-729
search results, specifying sort order, 729
writing
calculation formulas, 250, 253-254
legibility, 255
selecting fields, 254
selecting functions, 255
selecting operators, 254
writing tips, 280-282
code
comments, 555-556
naming database files, 553
naming fields, 554
naming functions, 555
naming layouts, 554
naming parameters, 555
plug-ins, 779
Web services, 686-688
x (cross-product operators), portals, 496
XLST Site Assistant, modifying xslt-template-files, 737-738
XML (Extensible Markup Language)
Amazon XML data, transforming to FMPXMLRESULT XML, 682-684
query strings, 724
defining, 664
FileMaker data, exporting as, 673
comparison operators, 727
FMPDSORESULT grammar, 665
FMPXMLRESULT grammar, 665
importing Amazon.com XML data to FileMaker, 682-684
importing XML data to FileMaker, 677-680
troubleshooting XML imports, 685
XML data importing to FileMaker, 674-680
importing, troubleshooting, 685
processing instructions, 739
embedding query parameters in stylesheets, 739-740
query strings, 740
rules of, 664
stylesheets
remote stylesheets, 673
troubleshooting, 685-686
XML declarations, 670
transformations, 667-668
Amazon XML, transforming to FMPXMLRESULT XML, 682-684
FileMaker data, exporting as XML, 673
XML data, importing to FileMaker, 678-679
XSL stylesheets, 668-672
Web services, 675
XSL, 668-669
importing XML data to FileMaker, 678-680
parse errors, 685
xsl:choose statements, 672
xsl:output statements, 671
xsl:stylesheet statements, 670
xsl:template statements, 671
XML Web Publishing, Access via XML Web Publishing extended privilege, 391
XMpl_Add function, 780
XMpl_Append function, 780
XMpl_NumToWords function, 780
XMpl_StartScript function, 780
XMpl_UserFormatNumber function, 780
XSL (Extensible Stylesheet Language)
Amazon XML data, transforming to FMPXMLRESULT XML, 682-684
CWP extension, 745
FileMaker data, exporting as XML, 673
parse errors, troubleshooting, 685
stylesheets, 668
remote stylesheets, 673
XML data, importing to FileMaker, 678-680
XML declarations, 670
xsl:choose statements, 672
xsl:output statements, 671
xsl:stylesheet statements, 670
exclude-result-namespaces statements, 670
xsl:template statements, 671
XSLT (Extensible Stylesheet Language transformations), 668
building HTML-formatted search result stylesheets, 738
building HTML-formatted search result stylesheets, URL format, 738-739
embedding query parameters in stylesheets, 739-740
stylesheet placement, 730
XSL extensions, 745
XSLT processors, 744
query strings, 739
URL formats, 738-739
XSLT Site Assistant, 731
launching, 732
site features, selecting, 733-734
XSLT Web Publishing
Access via XSLT Web Publishing extended privilege, 392
xslt-template-files, modifying, 737-738
xsl:choose statements, 672
xsl:output statements, 671
xsl:stylesheet statements, 670
exclude-result-namespaces statements, 670
xsl:template statements, 671
Zoom icons (Status Area), 43
3.149.27.234