Index
Symbols
“ (quotation marks), 414
& (concatenation) operator, 219
+ (plus signs), 420
+ (addition) operator, 219
. (periods), 232
A
About tabs, 527
Abs function, 237
Accessibility Inspector, 402-403
accessing. See also security
administration, removing, 631
controlling data access, 348-349
databases, 39, 522. See also ODBC
drivers, 523
files, 357
Full Access Privileges, 259, 347
GetNthRecord function, 438
Manage Database dialog box, 80-81
multiple files, 205
mobile devices, 28
passwords, 586
privilege databases, 515
Script Debugger, 507
sessions, testing, 333
accounts
Admin Console, 651
managing, 344
multiple files, 365
multiuser deployment, 326
Actual Open Source Databases driver, 527
Add Expression button, 509
Add Field button, 150
Add Fields dialog box, 180
Add Newly Defined Fields to Current Layout, 149
calculations, 509
external data sources, 206-207, 538-541
comments, 86
layouts, 149
objects to layouts, 144
pause states, 476
relationships, 175-176, 195-197
returns, 222
script logs, 329
spaces, 222
summary fields, 292
tab control objects, 148
TasksAfterDate relationship, 200
Web Viewer, 369
widgets, 183
addresses
hosts, specifying, 533
modifying, 372
multiple, eliminating, 166
static IP, 643
Web Viewer, 368
Adjust Window script step, 472
configuring, 667
administration, 527. See also managing
access, removing, 631
automatic layout management, 116
layouts, 112
passwords, retrieving, 364
administrator groups, configuring, 667
Advanced Options, recovery, 503
advanced scripting, 443
overview of, 443
Advanced Web Publishing Options dialog box, 580
auto-aligning, 549
fields, 546
objects, 143
Allow User Abort script, 265
Alternate Background Fill feature, 134
alternating colors in rows, 304
Always Lock Layout Tools preference, 144
analyzing
relational databases, 154
relationships, 160
structures, 154
Any Go To Layout script, 513
APIs (application programming interfaces), 519
Appearance tab, 386
application programming interfaces. See APIs
applications
force-quits, 327
IWP, 578, 593-597. See also IWP
ODBC, 520
rapid application development, 10-11
registration, 24
technical specifications, 21
updating, 24
Apply Theme Style command, 389
applying
arrays, troubleshooting, 440
Bento data sources, 562
conditional formatting, 389-391
constant global values, 202-204
Custom Menus feature, 490
Data Viewer, 509
DDR (Database Design Report), 504-507
dynamic guides, 393
Evaluate function, 414
formulas to calculations, 218-219
grids, 391
guides, 392
Layout bars, 134
lists, 289
Manage Database dialog box, 172
multiple files in relationships, 205-210
multitiered sorts, 74
Object Grid, 147
progressive backups, 670
Quick Find, 58
related parent data in child files, 186-187
Revert Record command, 44
Set Error Capture script, 491
states, 387
subscripts, 261
tab control objects to layouts, 147-149
timestamps, 240
tooltips, 141
triggers, 461
variables, 456
windows to documents, 474
files, 520
ODBC, 520
arranging
objects, 142
parts, 301
RAID, 644
text, parsing, 446
troubleshooting, 440
art Definition dialog box, 133, 299
ASCII characters, 373
value rules, 102
Assets Starter Solution, 56
atomicity, 327
attaching
sort scripts, 68
attributes
GetLayoutObjectAttribute function, 396-422
join entities, 165
states, 387
audit trails, 329
Authenticate/Deauthenticate scripts, 509
authentication
user, 362
authorizations, 359. See also security
auto-aligning fields, 549
editing, 333
Filter function, 425
serial values, 329
layout management, 116
recurring imports, 547, 559-560. See also importing
updates, configuring, 511
Avg function, 241
avoiding unclear code, 486-489
B
backgrounds, parts, 133
backups, 334
open files, 641
progressive, 670
scheduling, 673
base tables, 178. See also tables
batch imports, 556. See also importing
behavior
buttons, 278
fields, 139
summary fields, 96
Bento data sources, applying, 562
best practices checklists
fields, 102
bind keys, 629
Blank Layout, 120
body parts, 130
bound runtime solutions, 627
branching scripts, 252
breakpoints, placing, 509
dependencies, 499
reports, 289
browsers. See interfaces
bugs, tracking, 334
building. See also design; formatting
conversion solutions, 514
many-to-many relationships, 187
modal states, 475
built-in keys, 163. See also keys
Button Definition dialog box, 150
Button Setup dialog box, 184
scripts, 278
triggers, 462
C
Calculated Value option, 100
adding, 509
conditional functions, 240-241
context dependencies, 498
device identification functions, 245-246
expressions, 216
formulas
creating custom libraries, 441-442
GetNthRecord function, 438-439
mismatching, 109
mobile functions, 246
padding data, 572
Self function, 469
Specify Calculation dialog box, 219-229
timers, 468
triggers, 461
troubleshooting, 247-250, 440-441, 490-492
calendars
Gregorian, 49
pop-up, 45,
capturing
errors, 589
Set Error Capture script, 265-266, 491
cardinality, 159
Relationships Graph, 177
Cascading Style Sheets. See CSSs
case
functions, 234
managing, 266
statements, 222
Case() statement, 241
case studies, attributes/entities, 156-158
categories, Choose function, 410-412
Ceiling function, 236
characters, 82. See also naming
ASCII, 373
converting, 469
filters, 425
functions, 238
value rules, 102
charting, 283
reports, 283. See also reports
check boxes, 45
checklists, best practices, 102
child data
clients, 524. See also FileMaker Pro
functionality, 522
managing, 660
closing
files, 365
HTML sections, 610
splash screens, 630
code
errors, 491. See also troubleshooting
modular, 489
colors
background parts, 133
rows, alternating, 304
flat-file data sources, importing, 546-553
viewing, 499
width, 127
comma-separated text. See CSV
commands, 397
Apply Theme Style, 389
Copy, 499
Copy Object Style, 388
Customize Status Toolbar, 135-137
Delete Record, 37
Export Field Contents, 572
File Options, 467
Find, 490
-find, 616
Manage Scripts, 252
menu, accessing shortcuts, 78
New Record, 37
Paste Object Style, 388
Recover, 501
Resource Center, 26
Save, 378
Undo, 44
Undo Styles, 386
comments, 335
fields, adding, 86
PHP, 607
committing records, 590
comparison
equality, 210
operators, 616
compatibility, 522
Web Compatibility pop-up, 589
complex many-to-many relationships, 166-168
compliance, ACID tests, 327
components
ACID tests, 327
triggers, 462
concurrency, multiuser deployment, 327-332
conditional formatting, 389-391, 468
multiple layouts, 419
conditional functions, 240-241
conditional logic
errors, 280
conditional privileges, 349
conditions
nonequality, 198
OR, troubleshooting, 211
searching, 491
Admin Console, 667
administrator groups, 667
CWP, 603
databases, 666
fields, 171
FileMaker Server, 646, 665-672
FileMaker Server Advanced, 582-584
Layout Setup dialog box, 124-127
many-to-many relationships, 187-190
objects, 309
one-to-many relationships, 170-178
PHP
privileges, 604
security, 604
plug-ins, 636
relationships, 163
Specify Calculation dialog box, 223-226
updates, 511
variables, 454
Web Viewer, 369
options, 373
Set Web Viewer script step, 373-374
windows styles, 473
connecting. See also sessions
databases, 526
external SQL data sources, 519
FileMaker Server Advanced, 523
networks, 644
ODBC (Open Database Connectivity), 519-520
servers, troubleshooting, 496
specifying, 529
SQL, 544
Connection Pooling tabs, 527
constants
URLs, opening, 371
constraints
requests, 62
system, 429
contacts
one-to-many relationships, 160
tables, 170
Web Viewer, 368
Contacts Starter Solution, 115, 127
layouts, 116
containers, fields, 49-50, 89-93, 605
IWP, 593
context
calculations, 226
dependencies, troubleshooting, 497-500
explicit table, 247
scripts, 268
controlling
controls, 378
IWP, hiding, 595
conventions
naming
fields, 84
layouts, 129
programming, 432
characters, 469
previous versions, 511
files, 516
migrating to new file formats, 512-513
themes, 513
Copy command, 499
Copy File Blocks As-Is button, 503
Copy Object Style command, 388
fields, 152
found sets, 564
layout objects, 144
corruption, databases, 501. See also troubleshooting
Count function, 241
crashes, 327, 500. See also troubleshooting
Create Field Press Tab, 171
criteria, multiple match, 197-201
cross-product relationships, formatting, 204-205
crosstalk, troubleshooting, 497
CSSs (Cascading Style Sheets), 591
CSV (comma-separated text), 569
Current Script option, 477
current table context, viewing, 546
custom dialogs, applying, 275-276
Custom Menus feature, applying, 490
Custom Web Publishing. See CWP
Customize Status Toolbar command, 135-137
customizing
automatic recurring imports, 559-560
buttons, 278
colors, rows, 304
development software, 14
extended privileges, 356
fields, 171
functions, 334, 427-429, 441-442, 489
images, 630
interfaces
IWP, 578
lists, 289
many-to-many relationships, 187-190
menu elements, 398
modal dialogs, script pause state, 475-478
objects, sliding, 309
one-to-many relationships, 170-178
printing, 126
relationships, 163
sorting, 67
Web Viewer
options, 373
Set Web Viewer script step, 373-374
window styles, 473
CWP (Custom Web Publishing), 258, 512, 575, 599, 626
FileMaker Server, preparing, 604-605
technology, selecting, 603
triggers, 464
D
data
centers, external, 645
loss, troubleshooting, 71
source names. See DSNs
types, 223
mismatching, 109
troubleshooting, 247
Data Viewer, 509
Database Design Reports. See DDRs
Database Homepage, 586
database management systems. See DBMSs
Database Server, 669
DatabaseNames function, 245
accessing, 39, 522. See also ODBC
bugs, tracking, 334
configuring, 666
connecting, 526
corruption, 501. See also troubleshooting
deployment, 673
elements, 487
FileMaker
Database Server, 600
Server hosts, 657
identifying, 529
interactions, 520
MySQL. See MySQL
naming, 486
navigating, 40
planning, 154
privilege, 515
relational, 153. See also relational database design
servers, 646
sharing, 42
SQL. See SQL
databases administrators. See DBAs
dates
DBAs (database administrators), 522
DBMSs (database management systems), 522
DDRs (Database Design Reports), 18, 504-507, 515, 637
debugging, 485
tools, 18
declarative languages, 519
declaring variables, 407
dedicated find layouts, 480-482
defaults
extended privileges, 355
scripts, 257. See also scripts
themes, 386
timers, 468
Define File References dialog box, 637
defining
calculation fields, 217
layouts, 122
multiple match criteria, 197-201
noncalculation fields, 98
Delete Record command, 37
deleting
parts, 132
restrictions, troubleshooting, 192
styles, 389
tables, 83
text, formatting, 420
delimited values, 241
dependencies
context, troubleshooting, 497-500
keys, eliminating fields, 166
modes, 499
deployment
customizing, 632
databases, 673
peer-to-peer hosting, 19
design. See also configuring
DDRs (Database Design Reports), 504-507
iterations, 158
multiple tables, 169
relational databases, 153
analyzing, 154
overview of, 153
Developer Utilities dialog box, 626
developers,
fields, 488
plug-ins, 634
third-party plug-ins, 21
tools, 10
development
rapid multitable, 192
software, customizing, 14
device identification functions, 245-246
ER, 515
relationships, 159
dialog boxes
Add Fields, 180
Advanced Web Publishing Options, 580
Button Definition, 150
Button Setup, 184
Define File References, 637
Developer Utilities, 626
Edit Account, 346
Edit Custom Function, 431
Edit Find Request, 270
Edit Privilege Set, 348
Field Options, 105
Format Button, 468
Import Field Mapping, 547-550, 561
Manage Custom Functions, 430
Manage Database, 80-81, 171, 195, 519
Manage External Data Sources, 206
Manage Security, 340
Manage Value Lists, 188
Network Settings, 496
New Layout Report, 289-295, 541
Open File, 26
Open Remote File, 42
Portal Setup, 179
Sort Records, 67
Specify Calculation, 217, 219-229, 226, 509
Specify Field Order, 570
Specify Fields, 188
Specify Solution Options, 628
Storage Options, 224
Tab Control Setup, 148
Table View Properties, 126
Use Manage Database, 76
disconnected table occurrences, 480
distant data, summarizing, 295
Div function, 237
Do Not Evaluate If All Referenced Fields Are Empty box, 223
documents, 18. See also diagrams
ERDs, 154
Excel
importing from, 553
saving, 70
PDF, saving as, 70
PHP, 607
plug-ins, 634
solutions, 515
windows, applying, 474
dragging files, 546. See also importing
drivers
accessing, 523
selecting, 528
drop-down fields, 45. See also fields
dropping files, 546. See also importing
DSNs (data source names), 522, 525-526
duplicating. See copying
found sets, 564
between tables, 564
dynamic file paths, 457
dynamic guides, applying, 393
dynamic reporting, 298
E
ease of use, 9
Edit Account dialog box, 346
Edit boxes, 45
Edit Custom Function dialog box, 431
Edit Find Request dialog box, 270
Edit Privilege Set dialog box, 348
Edit Relationship dialog box, 182, 194
Edit Script window, 257
Edit Value List dialog box, 47, 188
editing
auto-entry options, 333
external data sources, 207
IWP, 577
layouts, 136
records, 330
spell-checking, 139
value lists, 188
elements
arrays, 424
databases, 487
interfaces, 30
menus, customizing, 398
naming, 488
sessions, 325
sort scripts, attaching, 68
structures, passing, 449
eliminating
fields, 166
redundant data, 166
repeating data, 166
notifications, 642
reports, 315
SMTP, 642
Email Notifications tab, 667
enabling
CWP, 602
Maintain Original Proportions, 483
ODBC/JDBC privileges, 521
plug-ins, 636
XML publishing, 610
encryption, troubleshooting, 494
enforcing fields, 470
entering
data in portals, 183
layouts, 112
join, attributes, 165
one-to-many relationships, 160
one-to-one relationships, 160
relationships, notation, 159
entity-relationship diagrams. See ERDs
envelopes, 120
equality comparisons, 210
ER diagrams, 515
ERDs (entity-relationship diagrams), 154-155, 193
many-to-many relationships, 164
multiple tables, 170
notation, 159
errors
calculations, 247
capturing, 589
layouts, 139
logs, 632
messages, 279
reproducing, 492
scripts, 581
managing, 264
searching, 492
Set Error Capture script, 265-266, 491
traps, 333
troubleshooting, 485. See also troubleshooting
Web publishing, 581
Evaluate function, 413-415, 447
evaluating
Do Not Evaluate If All Referenced Fields Are Empty box, 223
formulas, 93
EvaluationError function, 415
events
scheduling, 662
Exact function, 233
character transformations, 569
documents, saving, 70
files, importing from, 553
reports, saving as, 311
executing scripts, 479
Exit Script script, 451
exiting
layouts, 112
scripts, 260
explicit record commits, 594
explicit table context, 247
Export Field Contents command, 572
Export Records feature, 568, 573
fields
to fixed-width formats, 571-572
formatted data, 570
grouped data, 571
records, 498
related fields, 570
scripts, 573
expressions
calculations, 216
parameter, 413
extend requests, 62
extending
functionality, 21
Extensible Markup Language. See XML
extensions
folders, 635
runtime, 629
external authentication, 362-363, 642
external data centers, 645
external data sources, 206-208
external files
importing, 545
tables, 517
external ODBC data sources, 537-539
connecting, 519
ODBC (Open Data Connectivity), 519-520
F
failures, planning, 490
Favorite Files, 26
features
Custom Menus, applying, 490
Modify Last Find, 62
presentation, 499
Self function, 468
feedback, 389
Field Options dialog box, 105
fields, 75
aligning, 546
behavior, 139
calculations, 49, 93, 166, 215. See also calculations
IWP, 593
copying, 152
definitions, 515
developers, 488
eliminating, 166
enforcing, 470
Furigana option, 108
global
storage, 51
troubleshooting, 500
highlighting, troubleshooting, 483
Import Field Mapping dialog box, 547-550, 561
managing, 304
match, 59
updating records, 550
modifying, 470
pasting, 152
portals, managing, 181
radio buttons, modifying, 383
related, exporting, 570
selecting, 220
settings, 139
sizing, 384
subtotals, 292
supplemental, applying, 541-543
TaskDisplay, 420
validation, 102-104, 109, 218, 550
Fields category, 266
file-level access security, 359-364
File Options command, 467
FileMaker
Database Server, 600
Developer Subscription, 335
Pro
character transformations, 569
sessions, multiuser deployment, 324-326
Pro Advanced, 28
Server, 28
best practices checklists, 671-674
hosting, 20
Server Advanced, 523
hosting, 20
modifying, 375
files
accessing, 357
adding, 17
architectures, 520
backing up, 641
closing, 365
converting, 516. See also converting
data between, passing, 451
Excel (Microsoft), importing from, 553
extensions, 512
external, importing, 545
fields, copying/pasting between, 152
flat-file data sources, importing, 546-553
global storage, 51
launching, 332
lists, filtering, 364
local, opening, 40
moving, 546. See also importing
navigating, 43
output, formatting, 566
paths, dynamic, 457
PHP, placing, 605
recovery, 502
references, troubleshooting, 637
remote, navigating, 40
restoring, 326
security, 358. See also security
types, 556
Web Viewer, applying, 375
filters
files, lists, 364
FilterValues function, 426-427
Find command, 490
-find command, 616
Firefox, 611
firewalls
CWP, 622
troubleshooting, 497
fixed-width formats, exporting to, 571-572
data sources, importing, 546-553
flexibility, 9
Floor function, 236
folders
extensions, 635
multiple files, importing, 554-558
footers, 131. See also headers
force-quits, 327
forgotten admin passwords, 364
Format Button dialog box, 468
auto-entry options, 98
automatic recurring imports, 559-560
buttons, 278
conditional, 389-391, 419, 468
data, exporting, 570
external data sources, 206-208
files
output, 566
fixed-width, exporting to, 571-572
flat files, 546
IWP, 578
Layout Setup dialog box, 124-127
links, IWP, 596
lists, 289
managing, 140
many-to-many relationships, 187-190
objects, sliding, 309
one-to-many relationships, 170-178
panes, 148
parts, 132
records, 77
related records with nonequijoins, 210-211
relationships, 163
serial key fields, 99
sorting, 67
Specify Calculation dialog box, 223-226
Status value lists, 203
summary fields, 295
text
deleting, 420
troubleshooting, 440
tools, managing relationship graphs, 212
variables, 454
Web Viewer, 369
options, 373
Set Web Viewer script step, 373-374
window styles, 473
XML, 611
Formatting bars, 36
forms
fields, eliminating, 166
layouts, 111
normalizing, 166
redundant data, eliminating, 166
Standard Form, 119
views, 125
formulas
calculations, 215. See also calculations
debugging, 409
Evaluate function, 413
evaluating, 93
Excel, importing, 553
Let function, 408
scripts, troubleshooting, 247
Specify Calculation dialog box, 219-222
forums, support, 511
copying, 564
troubleshooting, 482
free trial software, 24. See also software
Full Access Privileges, 259, 347
clients, 522
extending, 21
FileMaker Pro, 39
modular, 452
Abs, 237
Avg, 241
calculations, 229-240, 441-442
Ceiling, 236
characters, 238
Code, 238
Code(), 469
Count, 241
customizing, 334, 427-429, 489
DatabaseNames, 245
device identification, 245-246
Div, 237
EvaluationError, 415
Exact, 233
Floor, 236
Get ( LastError ), 491
Get (TriggerKeystroke), 469
Get (TriggerModifierKeys), 469
GetFieldName, 469
GetLayoutObjectAttribute, 395
GetParam, 449
GetValue, 422
If(), 240
Int, 236
Last Visited Record, 100
LeftValues, 422
LeftWords, 232
Length, 232
Let, 407-409, 414, 440, 447-449
Location, 246
LookupNext, 416
Max, 241
MiddleValues, 422
MiddleWords, 232
Min, 241
mobile, 246
Mod, 237
PadCharacters, 435
PatternCount, 232
PersistentID, 245
Position, 232
private, 432
Quote, 414
Random, 238
RepeatText, 434
RightValues, 422
RightWords, 232
Round, 236
selecting, 220
Sum, 241
summary fields, 96
TestStyleAdd(), 266
TextColor, 419
TextFont, 419
TextSize, 419
TextStyleAdd, 420
TextStyleRemove, 420
Truncate, 237
ValueCount, 422
WordCount, 232
Furigana options, fields, 108
G
General Settings, 667
general slowness, troubleshooting, 493-494
Get ( LastError ) function, 491
Get (TriggerKeystroke) function, 469
Get (TriggerModifierKeys) function, 469
GetFieldName function, 469
GetLayoutObjectAttribute function, 395
GetNthRecord function, 438-439
GetParam function, 449
GetValue function, 422
global
fields, 489
troubleshooting, 500
positioning system. See GPS
storage, 51
variables, 456
Go to Related Record. See GTRR
Google, Web Viewer templates, 372
GPS (global positioning system), 246
gradients, 386
graphics. See images
graphs, 479
Gregorian calendars, 49
grids, applying, 391
groups
administrator, configuring, 667
exporting, 571
fields, selecting, 292
layouts, 136
objects, 142
records, searching, 57
repeating, eliminating, 166
GTRR (Go to Related Record), 478
guides
applying, 392
dynamic, applying, 393
H
hard-coding requests, 269
hardware
purchasing, 672
sharing, troubleshooting, 493
PHP, 607
titles, 130
Help menu, 26
heuristics, interfaces, 405
hiding
IWP controls, 595
highlighting troubleshooting, 483
HIPAA (the Health Insurance Portability and Accountability Act of 1996), 339
history of multiple files, 205
home pages, IWP, 596
hosts, 524
addresses, specifying, 533
FileMaker Server Advanced, 20
managing, 43
HTML (Hypertext Markup Language), 575
sections, closing, 610
tables, 569
HTTP (Hypertext Transfer Protocol), 10, 575
Human Interface Guidelines (Apple), 377-378, 471
hyperlinks, DDRs, 506
Hypertext Markup Language. See HTML
Hypertext Transfer Protocol. See HTTP
I
identifying databases, 529
If() function, 240
customizing, 630
implementing triggers, 468-470
Import Action, selecting, 548
Import Field Mapping dialog box, 547-550, 561
Import Records command, 547, 561
automatic recurring imports, 559-560
Bento data sources, 562
Excel (Microsoft) documents, 553
external files, 545
FileMaker-to-FileMaker, 564
flat-file data sources, 546-553
layouts, 120
troubleshooting, 563
validation, 563
inability to contact servers, troubleshooting, 496
incomplete highlighting rectangles, 483
incorporating reports into workflow, 320-321
incremental evolution, planning, 513
re-creating, 110
troubleshooting, 494
Indexing Service, 644
indicators, 548
infrastructure, networks, 671
Insert menu, 144
inserting. See adding
files, 50
specific information, 73
Install On Timer Script, 468
installing
plug-ins, 635
software, 672
Instant Web Publishing. See IWP
Int function, 236
integration, SQL, 522
security, 339
troubleshooting, 71
interactions. See also buttons
databases, 520
drivers, 338
triggers, 470
interfaces, 377
APIs, 519
databases, 153. See also databases
design, 190
elements, attaching sort scripts, 68
heuristics, 405
Human Interface Guidelines (Apple), 471
layouts, 111
menus
tools, layouts, 112
triggers, 470
View menu, 35
XML, viewing, 611
internal data-level security, 338
internal navigation, scripts, 268
Internet Explorer, 611
interoperability, 9
Inventory Summary Report, 288
IP (Internet Protocol) addresses, 643
iPad, 377
iPhone, 377
isolation, 327-329, 492. See also troubleshooting
items
menus, 397
Status toolbars, 137
iterations, design, 158
IWP (Instant Web Publishing), 258, 512, 575, 626
container fields, 593
controls, hiding, 595
FileMaker
Server Advanced, configuring, 582-584
testing, 591
triggers, 464
troubleshooting, 597
J
Japanese, 108
Java
caches, 673
Database Connectivity. See JDBC
Runtime Environment. See JRE
JDBC (Java Database Connectivity), 10, 519, 575, 671
enabling, 653
privileges, 521
joins
self-joins, viewing, 202
JRE (Java Runtime Environment), 645
K
keyboards
fields, navigating, 45
optimizing, 72
bind, 629
dependence, eliminating fields, 166
foreign, 163
numeric values of modifier, 470
selecting, 539
table references, 163
unique. See unique keys
L
labels
layouts, 120
printing, 126
vertical, 120
languages, 519
large fields, exporting, 572-573
Last Visited Record function, 100
launching files, 332
layers, objects, 142
Layout bars, applying, 134
Layout Setup dialog box, 464
automatic layout management, 116
documentation, 515
importing, 120
Layout Setup dialog box, 124-127
modal dialogs, building, 475
multicolumn, 126
multiple
conditional formatting, 419
searching, 62
New Layout/Report assistant, 119
Object Grid, 147
objects, 395
naming, 140
resizing, 141
opening, 118
records, viewing, 152
reports, 284
tab control objects, applying, 147-149
tables
associating, 121
context, 498
tools, 136
troubleshooting, 152
viewing, 286
width, formatting, 391
LDAP (Lightweight Directory Access Protocol), 42
leading grand summary, 130
LeftValues function, 422
LeftWords function, 232
legible formulas, writing, 221
Length function, 232
Let function, 407-409, 414, 440, 447-449
libraries
Bento data sources, 562
functions, customizing, 441-442
Lightweight Directory Access Protocol. See LDAP
links
DDRs, 506
IWP, 596
Manage Favorites, 26
List view, 33
List View Report, 120
lists
applying, 289
databases, 13
files, filtering, 364
layouts, 111
pop-up, 479
values
context dependencies, 499
controlling access, 351
modifying, 47
views, 125
local files, opening, 40
local variables, overview of, 454-455
Location function, 246
locations
container folders, 606
hosts, specifying, 534
locking
objects, 142
Log Viewer
monitoring, 674
troubleshooting, 665
logic
conditional, applying, 272-273
logs
errors, 632
Looked-Up Value option, 100-102
LookupNext function, 416
lookups
slowness, 495
triggers, 461
loops, 436
debugging, 509
scripts, applying, 274
testing, 280
troubleshooting, 495
lost data, troubleshooting, 504. See also troubleshooting
lost found sets, troubleshooting, 482
M
Mac OS X
files, 556
Status toolbars, customizing, 36-37, 136
Maintain Original Proportions, enabling, 483
Kiosk mode, 634
Manage Custom Functions dialog box, 430
Manage Database Design, 492
Manage Database dialog box, 80-81, 171, 195, 519
Manage Extended Privileges, 585
Manage External Data Sources dialog box, 206
Manage Favorites link, 26
Manage Scripts command, 252
Manage Scripts window, 252, 256
Manage Security dialog box, 340
Manage Value Lists dialog box, 188
accounts, 344
architectures, 471
automatic layout management, 116
cases, 266
clients, 660
concurrency, 327
CWP sessions, 621
dates, 48
DBMSs, 522
drives, 520
formatting, 140
hosts, 43
layouts, 112
multiwindow interfaces, 473-475
portals, 181
routines, 51
script errors, 264
sessions, 324
settings, 253
thumbnails, 93
Tiny Task Management, 113
many-to-many relationships, 161, 163-165. See also relationships
many-to-one relationships, 159-160
mapping, Import Field Mapping dialog box, 547-550, 561
master files, applying, 630-631
match fields, 59
records, updating, 550
matching
exact matches, specifying, 615
multiple values, 441
matrices, security, 341. See also security
Max function, 241
memory, RAM, 644
menus, 377
commands, accessing shortcuts, 78
Custom Menus feature, applying, 490
elements, customizing, 398
Help, 26
Insert, 144
interfaces, customizing, 395-402
IWP, 577
Show Compatibility, 258
View, 35
Merge format, 569
messages
errors, troubleshooting, 279
recovery, 504
reports, 315
validation, 52
metadata, 556
Microsoft Excel. See Excel (Microsoft)
MiddleValues function, 422
MiddleWords function, 232
migrating to new file formats, 512-513
Min function, 241
mismatching
calculations, 109
data types, troubleshooting, 109
mobile functions, 246
Mod function, 237
modal dialogs
dependencies, 499
reports, 289
dependence, 499
Preview, 32
reports, troubleshooting, 319
Modify Last Find feature, 62
modifying
addresses, 372
auto-entry options, 98
case functions, 234
colors, rows, 304
fields, 470
filenames, 375
found sets, 58
images, 558
layouts, width, 391
names, 627
passwords, 345
sorting, 67
states, 385
structures, calculation fields, 166
styles, 385
Table view, 303
tables, 83
text, strings, 231
value lists, 47
windows, 472
modularizing
code, writing, 489
functionality, 452
scripts, 450
monitoring
Log Viewer, 674
performance, 341
statistics, 673
moving
files, 546. See also importing
objects, 146
parts, 301
scripts, 263
windows, 472
MS SQL Server, 524
multicolumn layouts, 126
multihop GTRR yields, 480
multiple addresses, eliminating, 166
multiple columns, viewing, 499
multiple criteria, searching, 617
multiple files
relationships, applying, 205-210
multiple find requests, 62
multiple match criteria
troubleshooting, 211
multiple layouts
conditional formatting, 419
searching, 62
multiple operators, 199
multiple portals, 54, 178. See also portals
multiple relationships, 54
many-to-many relationships, 187-190
one-to-many relationships, creating, 170-178
rapid multitable development, 192
related parent data in child files, 186-187
relationships, adding, 175-176
troubleshooting, 192
multiple values, matching, 441
multiple windows, 74
multitiered pause states, 477. See also pause states
multitiered sorts, applying, 74
multiuser deployment, 323
files, launching, 332
sessions in FileMaker Pro, 324-326
multivalued parameters, passing, 446-450
multiwindows
locking, 331
N
accounts, 326
custom functions, 431
data sources, 341
objects, 140
recovered files, 502
runtime, 628
servers, 652
variables, Let functions, 440
navigating
files, 43
GTRR (Go to Related Record), 478
Layout bars, 134
lists, 289
Manage Database dialog box, 80
multiwindow interfaces, 473-475
portals, 55
remote files, 40
tables, 29
Network Settings dialog box, 496
networks
access, 338
connecting, 644
defining, 640
infrastructure, 671
new features, interfaces, 377-378
New Layout/Report assistant, 119
New Layout Report dialog box, 289-295, 541
New Record command, 37
noncalculation fields, defining, 98
nonequality conditions, 198
nontext calculations, troubleshooting, 440
notation
entity-relationships, 159
ERDs, 159
notifications, email, 642
numbers
comparison searches, 617
ports, IWP, 581
of repetitions, 223
serial, 554
values of modifier keys, 470
numeric codes, converting, 469
O
Object Grid, 147
objects
aligning, 143
arranging, 142
layouts, 395. See also layouts
resizing, 141
moving, 146
naming, 140
resizing, 146
storage, 608
occurrences, adding table, 195-197, 209, 212-213
ODBC (Open Database Connectivity), 10, 519-520, 575, 671
architecture, 520
databases, configuring, 520-521
drivers, 526
enabling, 653
one-to-many relationships, 160
tools, 524
off-the-shelf software, 13
omitting records, 62
one-to-many relationships, 159-160. See also relationships
keys, 163
one-to-one relationships, 159-160, 178. See also relationships
OnObjectModify trigger, 470
Open button, 40
Open Database Connectivity. See ODBC
Open File dialog box, 26
open files, backing up, 641
Open Remote File dialog box, 42
opening
constant URLs, 371
layouts, 118
operating systems, support, 645
operators
addition (+), 219
comparison, 616
concatenation (&), 219
multiple, 199
selecting, 220
optimizing keyboards, 72
options
editing, 333
Filter function, 425
automatic recurring imports, 559-560
buttons, 278
Calculated Value, 100
Current Script, 477
Export Field Contents, 572
Furigana, 108
interface accessibility, 402-404
IWP, 578
Layout Setup dialog box, 124-127
lists, 289
many-to-many relationships, 187-190
one-to-many relationships, 170-178
Other, 48
relationships, 163
Serial Number, 99
Specify Calculation dialog box, 223-226
Update Matching Records, 563
views, 125
Web Viewer, 373
OR conditions, troubleshooting, 211
ordering
sorting, specifying, 618
systems, 122
OS X
ODBC Administrator, 525
Other option, 48
output
files, formatting, 566
summary data, 571
P
PadCharacters function, 435
padding data, 572
Page Break Before Each Occurrence option, 133
panes, formatting, 148
parameters
expression, 413
functions, 229
GetField function, 412
Let function, 408
naming, 431
parent data in child files, 186-187
Part Setup dialog box, 132-133, 301
parts
CWP, 600
formatting, 132
moving, 301
subsummary, 130
passing
data between files, 451
multivalued parameters, 446-450
structured elements, 449
passwords
accessing, 586
Manage Extended Privileges, 585
managing, 527
modifying, 345
retrieving, 364
Paste Object Style command, 388
pasting
fields, 152
files, 50
paths
dynamic file, 457
external data sources, 208
PatternCount function, 232
PDF documents
reports, 310
saving, 70
peer-to-peer hosting, 19, 493, 641
Perform Find script, 491
performance. See also troubleshooting
monitoring, 341
rechecking, 673
SQL, 544
unique keys, 538
periods (.), 232
permissions
Admin Console, 658
troubleshooting, 496
PersistentID function, 245
photographs. See images
PHP. See also CWP
extended privileges, configuring, 604
files, placing, 605
security, configuring, 604
physical access, 337
placing
breakpoints, 509
PHP files, 605
planning
converting previous versions, 513-514
databases, 154
for failures, 490
configuring, 636
enabling, 636
installing, 635
overview of, 635
plus signs (+), 420
pointers, records, 500
pop-ups
calendars, 45,
windows, 482
Portal Setup dialog box, 179
portals, 53
IWP, 595
multiple, 54
navigating, 55
records
locking, 330
related child data, viewing, 178-181
relationship queries, 194
repeating, 192
sliding, 309
sorting, 55
ports, numbers, 581
positioning
objects on layouts, 145
parts, 301
post-conversion tasks, 516. See also converting
preconversion tasks, 514-515. See also converting
predicting found sets, 479-480
presentation features, 499
preventative measures, 485-489. See also maintenance
previewing themes, 381
previous versions, converting, 511
files, 516
migrating to new file formats, 512-513
customizing, 126
labels, 126
reports, 452
private functions, 432
privileges
databases, 515
Full Access Privileges, 259, 347
groups, 667
Manage Extended Privileges, 585
multiple files, 365
ODBC/JDBC, enabling, 521
PHP, configuring, 604
Script Debugger, 509
user accounts, 346
processors, 644
programming
conventions, 432
progressive backups, 670
projects, tables, 170
protocols
LDAP, 42
publishing XML, overview of, 610-613
purchasing hardware, 672
Q
queries
Quick Find, applying, 58
Quick Start screen, applying, 24-26
quotation marks (“), 414
Quote function, 414
quoting systems, 122
R
RAID (Redundant Array of Inexpensive Disks), 644, 672
RAM (random access memory), 644, 672
random access memory. See RAM
Random function, 238
rapid application development, 10-11
rapid multitable development, 192
reactive troubleshooting, 485. See also troubleshooting
rechecking performance, 673
records
adding, 77
committing, 590
editing, 330
explicit record commits, 594
Export Records feature, 573
exporting, 498
formatting, 77
Last Visited Record function, 100
layouts, viewing, 152
match fields, updating, 550
navigating, 44
nonequijoins, troubleshooting, 210-211
omitting, 62
PHP, 609
pointers, 500
reverting, 72
security, 218
viewing, 62
re-creating
indexes, 110
recursion
Redundant Array of Inexpensive Disks. See RAID
redundant data, eliminating, 166
references
calculations, troubleshooting, 494-495
external data sources, creating, 206-208
images, 557
keys, tables, 163
registration, 24
related data, navigating, 53-55
related fields, exporting, 570
relational database design, 153
analyzing, 154
overview of, 153
relationships, 193
cross-product, formatting, 204-205
diagrams, 159
editing, 182
GetNthRecord function, 438
global values, formatting, 202-204
layouts, 122
multiple, 54
multiple match criteria, 197-201
nonequijoins, troubleshooting, 210-211
self-relationships, 201-202, 204
types, 159
Relationships Graph, 479
tables, naming, 82
re-login scripts, 324
Relookup, 499
Remote button, 40
remote connections, navigating, 41-42
remote files, navigating, 40
removing administration access, 631
renaming
triggers, 467
rendering IWP, 577
repeating
data, eliminating, 166
portals, 192
RepeatText function, 434
repetitions, number of, 223
replacing
calculations, 219
charting, 283
DDR (Database Design Report), 504-507
deriving meaning from data, 284-286
errors, 632
Inventory Summary Report, 288
layouts, 120
List View Report, 120
lists, 289
New Layout/Report assistant, 119
New Layout Report dialog box, 289-295
requirements, 285
Table view, modifying, 303
workflow, incorporating, 320-321
reproducing errors, 492
requests
constrain, 62
extend, 62
hard-coding, 269
multiple find, 62
searching, 617
requirements
software, troubleshooting, 485-486
resizing
images, 558
windows, 472
Resource Center command, 26
restoring files, 326
restrictions, deleting, 192
results
calculations, mismatching, 109
triggers, 462
Retina Display, 145
retrieving
files, 50
passwords, 364
script parameters, 445
return-delimited data arrays, 422-423. See also arrays
returns, adding, 222
reverting records, 72
reviewing
charts, 319
statistics, 664
RightValues function, 422
RightWords function, 232
risks, security, 338-339. See also security
rollbacks, 475
rotating objects, 143
Round function, 236
rounded corners, 386
routines
managing, 51
scripts, 269
colors, alternating, 304
flat-file data sources, importing, 546-553
portals, creating, 55
rules, 30
scripts, naming, 279
running FileMaker Servers, 656-657
runtime, 626
solutions, 628
S
Safari, 611
Sarbanes-Oxley Act, 339
Save command, 378
Save Logical Structure button, 503
saving
Excel documents, 70
files, 50
find requests, 62
global storage, 51
PDF documents, 70
Scan Blocks and Rebuild File button, 503
scanning
data before importing, 549
files, 556
scheduling, 642
backups, 673
events, 662
screens
splash, closing, 630
Script Triggers tab, 117
ScriptMaker, 471
scripts, 251
access, controlling, 352
Adjust Window, 472
advanced scripting, 443. See also advanced scripting
Allow User Abort, 265
Any Go To Layout, 513
Authenticate/Deauthenticate, 509
buttons, 278
conditional logic, applying, 272-273
context, 268
controlling/setting data, 266-268
custom dialogs, applying, 275-276
developer tools, 10
documentation, 515
executing, 479
Exit Script, 451
exiting, 260
exporting, 573
FileMaker
Go, 251
Find mode, 481
formulas, troubleshooting, 247
Install On Timer Script, 468
layouts, 278
loops
applying, 274
debugging, 509
modularizing, 450
Move/Resize Window, 472
pause state, creating modal dialogs, 475-478
Perform Find, 491
records, locking, 330
Set Error Capture, 265-266, 491
Set Variable, 455
Show Custom Dialog, 474
shutdown, 591
sorting, attaching, 68
starting, 277
steps, 218
Submit, 476
subscripts, 261
table context, 499
templates, 261
triggers, 277, 465, 468. See also triggers
troubleshooting, 279-280, 490-492
windows, managing, 472
writing, 253
Scripts menu, managing, 263-264
conditions, 491
errors, 492
Modify Last Find feature, 62
multiple criteria, 617
multiple find requests, 62
multiple layouts, 62
records, 615
requests, 617
slowness, 494
URLs (Uniform Resource Locators), 371
sections, HTML, 610
Secure Sockets Layer. See SSL
security, 337
files
accessing, 357
firewalls
CWP, 622
Kiosk mode, 633
PHP, configuring, 604
records, 218
transferring data, 642
Select button, 501
selecting
CWP technology, 603
data
sources, 536
types, troubleshooting, 247
drivers, 528
FileMaker Server configurations, 648
functions, 220
keys, 539
objects
on layouts, 145
by type, 143
operators, 220
sockets, 530
source tables, 566
summary fields, 292
target tables, 546
themes, 293
web servers, 654
self-relationships, 201-202, 204
serialization, 329
serial key fields, creating, 99
Serial Number option, 99
serial numbers, 554
servers. See also FileMaker Pro
Database Server, 669
databases, 646
defining, 640
FileMaker
Database Server, 600
Server, 28
applying Admin Console, 657-671
best practices checklists, 671-674
MS SQL Server, 524
naming, 652
troubleshooting, 493
accessing, testing, 333
elements, 325
FileMaker Pro, multiuser deployment, 324-326
global fields, 501
IWP
ending, 582
troubleshooting, 597
managing, 324
user accounts, multiuser deployment, 326
Set Error Capture script, 265-266, 491
Set Variable script, 455
Set Web Viewer script step, 373-374
sets
settings
automatic recurring imports, 559-560
CWP, 603
fields, 139
Inspector
viewing, 140
interfaces, accessibility, 402-404
IWP, 578
Layout Setup dialog box, 124-127
managing, 253
Specify Calculation dialog box, 223-226
variables, 454
sharing
databases, 42
hardware, troubleshooting, 493
shortcuts
menu commands, accessing, 78
Show Compatibility menu, 258
Show Custom Dialog scripts, 474
Show Field Frames When Record Is Active check box, 124
shutdown scripts, 591
simplifying complex formulas, 428-429
computer configurations, 647
sizing
fields, 384
images, 558
objects, 146
windows, 472
slowness
lookups, 495
searching, 494
sorting, 494
SMTP email, 642
sockets, selecting, 530
development, customizing, 14
installing, 672
off-the-shelf, 13
plug-ins. See plug-ins
registration, 24
technical specifications, 21
troubleshooting, 490. See also troubleshooting
updating/upgrading, 24, 511-512, 674
solutions
architectures, 471
documentation, 515
Sort Records dialog box, 67
ERDs, 156. See also ERDs (entity-relationship diagrams)
multitiered sorts, 74
orders, specifying, 618
scripts, 270
slowness, 494
summary fields, 302
source fields
aligning, 546
auto-aligning, 549
source tables, selecting, 566
spaces
adding, 222
specific information, inserting, 73
Specify Calculation dialog box, 217, 219-229, 509
Specify Field dialog box, 186, 291
Specify Field Order dialog box, 570
Specify Fields dialog box, 188
Specify Solution Options dialog box, 628
specifying
connecting, 529
script parameters, 445
tables, 614
splash screens, closing, 630
Spotlight, 644
spreadsheets, importing, 553
SQL (Structured Query Language), 10
external data sources, connecting, 519
integration, 522
ODBC (Open Database Connectivity), 519-520
queries, 536
troubleshooting, translating to FileMaker, 544
SSL (Secure Sockets Layer), 642
Standard Form, 119
Starter Solutions, 513
starting
Admin Console, 650
FileMaker Server, 656
IWP, 578
scripts, 277
startup scripts, 117, 255, 591
static IP addresses, 643
statistics
monitoring, 673
reviewing, 664
Status toolbars, 125
customizing, 136
Status value lists, creating, 203
stepping through arrays, 423-424. See also arrays
steps, scripts, 218
stopping FileMaker Servers, 656
storage
global, 51
objects, 608
Storage Options dialog box, 224
strategies, converting, 513. See also converting
strings
text, modifying, 231
Structured Query Language. See SQL
structures, 378. See also design
analyzing, 154
calculation fields, 166
elements, passing, 449
fields, 175
many-to-many relationships, 187
one-to-many relationships, 160
styles
windows, 473
subcategories, Get functions, 243
subexpressions, 407
Submit script, 476
subroutines, 407
subscripts, 261, 366, 591. See also scripts
subsidiary tables, 166
subsummary parts, 95, 130, 297-301. See also summary fields
subtotals, summary fields, 292
Sum function, 241
summary data output, 571
summary fields, 49, 57, 95, 489
printing, 68
subtotals, 292
supplemental fields, applying, 541-543
support. See also troubleshooting
forums, 511
operating systems, 645
system constraints, 429
T
Tab Control Setup dialog box, 148
Tab keys, navigating fields, 45
Table view, 34, 72, 76, 120, 174, 303
Table View Properties dialog box, 126
tables, 75
deleting, 83
disconnected table occurrences, 480
duplicating between, 564
explicit table context, 247
external files, 517
formatting, 83-84, 170-173, 541
HTML, 569
key references, 163
modifying, 83
relationships, adding, 195-197
renaming, 173
source, selecting, 566
specifying, 614
subsidiary, 166
summary fields, 295
targets, selecting, 546
views, 125
Appearance, 386
controls (Web Viewer), 367
tab-separated
files, importing, 546
text, 569
targets
fields
aligning, 546
auto-aligning, 549
tables, selecting, 546
TaskDisplay field, 420
tasks, 53
tables, 170
Tiny Task Management, 113
Tasks Starter Solution, 53, 255
TasksAfterDate relationship, adding, 200
TCO (total cost of ownership), 11
teams, multiuser deployment, 334-335
TechNet, 335
technical specifications, 21
technology, CWP, 603
templates
layouts, 121
scripts, 261
testing
FileMaker Server, 656
files, 365
formulas, 409
IWP, 591
loops, 280
sessions, accessing, 333
TestStyleAdd() function, 266
arrays, parsing, 446
formatting
deleting, 420
troubleshooting, 440
Formatting bars, 36
parsing, 234
styles, 74
tab-separated, 569
TextColor function, 419
TextFont function, 419
TextSize function, 419
TextStyleAdd function, 420
TextStyleRemove function, 420
themes
converting, 513
layouts, 115
selecting, 293
third-party plug-ins, 21, 634-636
three computer configurations, 647
thumbnails
managing, 93
time
triggers, 462
Time Billing Start Solution, 221
timers
default, 468
triggers, 468
Tiny Task Management, 113
titles
footers, 131
headers, 130
toolbars
IWP, 577
Status, 125
customizing, 136
tools
buttons, 278
charting, 283
Data Viewer, 509
debugging, 18
developers, 10
formatting, managing relationship graphs, 212
interfaces
layouts, 112
layouts, 136
ODBC, 524
Web Viewer, 369
tooltips, applying, 141
total cost of ownership. See TCO
Tracing tabs, 527
tracking
bugs, 334
entities, 155. See also entities
trailing grand summary, 131
trails, audit, 329
transferring data, 642
transforming characters, 568-570
translating SQL to FileMaker, 544
traps
errors, 333
records, locking, 330
validation, 109
interactive interfaces, 470
OnObjectModify, 470
parameters, 444
Script Debugger, 508
timers, 468
windows, 467
troubleshooting, 485
arrays, 440
calculations, 247-250, 440-441, 490-492
crosstalk, 497
Data Viewer, 509
delete restrictions, 192
encryption, 494
failures, planning for, 490
files
references, 637
firewalls, 497
found sets, 482
global fields, 500
highlighting, 483
importing, 563
IWP, 597
layouts, 152
multiple tables, 192
OR conditions, 211
overview of, 485
permissions, 496
pop-up windows, 482
preventative measures, 485-489
scripts, 247, 279-280, 490-492
software requirements, 485-486
SQL, translating to FileMaker, 544
windows, 482
Truncate function, 237
two computer configurations, 647
of charts, 318
of data, 223
of DSNs, 526
of events, 662
configuring, 172
of files, 556
of layouts, 119
of relationships, 159
of reports, 290
of views, 125
U
underlying data, triggers, 464
Undo command, 44
Undo Styles command, 386
unfinished scripts, troubleshooting, 279
Uniform Resource Locators. See URLs
uninterruptible power supply. See UPS
universal serial bus. See USB
Universally Unique Identifier. See UUID
unpredictable global default values, 332
unsupported scripts, IWP, 589
Update Matching Records option, 563
updating
import topics, 548
records
importing, 550
match fields, 550
UPS (uninterruptible power supply), 328, 501
URLs (Uniform Resource Locators)
files, applying Web Viewer, 375
searching, 371
usage statistics, monitoring, 673
USB (universal serial bus), 501
Use Manage Database dialog box, 76
users
accounts, multiuser deployment, 326
authentication, 362
interfaces. See interfaces
multiuser deployment. See multiuser deployment
user-level internal security, 343-359
UUID (Universally Unique Identifier), 245
V
importing, 563
traps, 109
ValueCount function, 422
values
arrays, 421
Calculated Value option, 100
delimited, 241
FilterValues function, 426-427
indexes, 106
lists
context dependencies, 499
controlling access, 351
modifying, 47
Looked-Up Value option, 100-102
multiple, matching, 441
numeric values of modifier keys, 470
relationships, 194
unpredictable global default, 332
variables
applying, 456
declaring, 407
global, 456
names, Let functions, 440
scope, 455
viewing, 457
verifying versions, 523
versions
previous. See previous versions
verifying, 523
vertical labels, 120
View menu, 35
viewing
files, 375
GetLayoutObjectAttribute function, 395
Inspector, 140
layout records, 152
Log Viewer
monitoring, 674
troubleshooting, 665
multiple columns, 499
one-to-one relationships, 178
records, 62
scripts, 264
self-joins, 202
variables, 457
Web Viewer, 367-368. See also Web Viewer
XML, 611
options, 125
Tables, 174
types of, 125
volatility, 501
W
Watch tab, 509
Web Compatibility pop-up, 589
Web pages, IWP links, 596
Web Publishing Engine. See WPE
web servers, 600, 643, 646, 654
files, 375
formatting, 369
GetLayoutObjectAttribute function, 395
options, 373
Set Web Viewer script step, 373-374
widgets, adding, 183
width
columns, 127
fixed-width formats, exporting to, 571-572
layouts, formatting, 391
WindowNames function, 245, 472
Windows
files, 556
ODBC drivers, 526
pop-up windows, troubleshooting, 482
Status toolbars, customizing, 37-39, 136
windows
documents, applying, 474
Edit Script, 257
multiple, 74
multiwindows
locking, 331
styles, 473
timers, 468
triggers, 467
troubleshooting, 482
WordCount function, 232
workflow reports, incorporating, 320-321
worksheets, 569. See also Excel
WPE (Web Publishing Engine), 600, 610, 646
writing
code, FileMaker PHP APIs, 607-610
formulas
Specify Calculation dialog box, 219-222
functions, 431. See also functions
modular code, 489
X
Xcode, 634
XML (Extensible Markup Language), 10. See also CWP
character transformations, 569
elements, passing structured data, 449
importing, 545
viewing, 611
Z
zzCreationTS, 170
zzCreator, 170
zzModificationTS, 170
zzModifier, 170