Klienditugi: 7440010 (E-R 10-18)

Abi | Registreeri | Logi sisse

E-raamat: Learn FileMaker Pro 16: The Comprehensive Guide to Building Custom Databases

4.00/5 (4 hinnangut Goodreads-ist)

Mark Munro

Formaat: EPUB+DRM
Ilmumisaeg: 06-Sep-2017
Kirjastus: APress
Keel: eng
ISBN-13: 9781484228630

Teised raamatud teemal:

FileMaker

Formaat - EPUB+DRM
Hind: 74,09 €*
* hind on lõplik, st. muud allahindlused enam ei rakendu
Lisa ostukorvi
Lisa soovinimekirja
See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.

Formaat: EPUB+DRM
Ilmumisaeg: 06-Sep-2017
Kirjastus: APress
Keel: eng
ISBN-13: 9781484228630

Teised raamatud teemal:

FileMaker

DRM piirangud

Kopeerimine (copy/paste):

ei ole lubatud
Printimine:

ei ole lubatud
Kasutamine:

Digitaalõiguste kaitse (DRM)
Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

Vajalik tarkvara
Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

Seda e-raamatut ei saa lugeda Amazon Kindle's.

Extend FileMaker's built-in functionality and totally customize your data management environment with specialized functions and menus to super-charge the results and create a truly unique and focused experience. This book includes everything a beginner needs to get started building databases with FileMaker and contains advanced tips and techniques that the most seasoned professionals will appreciate. Written by a long time FileMaker developer, this book contains material for developers of every skill level.

FileMaker Pro 16 is a powerful database development application used by millions of people in diverse industries to simplify data management tasks, leverage their business information in new ways and automate many mundane tasks. A custom solution built with FileMaker can quickly tap into a powerful set of capabilities and technologies to offer users an intuitive and pleasing environment in which to achieve new levels of efficiency and professionalism.

What Youll learn

Create SQL queries to build fast and efficient formulas

Discover new features of version 16 such as JSON functions, Cards, Layout Object window, SortValues, UniqueValues, using variables in Data Sources Write calculations using built-in and creating your own custom functions

Discover the importance of a good approach to interface and technical design

Apply best practices for naming conventions and usage standards Explore advanced topics about designing professional, open-ended solutions and using advanced techniques

Who This Book Is For Casual programmers, full time consultants and IT professionals.

About the Author

xxxvii

About the Technical Reviewer

xxxix

Foreword

xii

Acknowledgments

xliii

Introduction

xlv

Part I Using FileMaker

(116)

Chapter 1 Introducing FileMaker

(16)

The History of FileMaker in a Nutshell

(2)

Nashoba Nutshell

(1)

Early FileMaker

(1)

FileMaker 4

(1)

Claris

(1)

FileMaker Inc

(1)

Exploring Database Basics

(3)

Defining a Database

(1)

Database Structure

(1)

Relational Databases

(1)

User Interface

(1)

Scripted Procedures

(1)

Identifying Different Database Architectures

(3)

The Traditional Multitier Database Architecture

(1)

FileMaker's Integrated File Architecture

(1)

Taking a Bird's Eye Anatomical and Functional Overview

(3)

Application Resources

(1)

Database File Resources

(1)

The FileMaker Product Family

(3)

FileMaker Pro

(1)

FileMaker Pro Advanced

(1)

FileMaker Server

(1)

FileMaker Go

(1)

FileMaker WebDirect

(1)

Summary

(2)

Chapter 2 Exploring the Application

(26)

Installing and Launching FileMaker Pro

(2)

Launching the Installer

(1)

Running the Installation Process

(1)

Launching the Application

(1)

Default Windows

(2)

Get Started Screen

(1)

Launch Center

(1)

Application Preferences

(5)

General Settings

(2)

Layout Settings

(1)

Memory

(1)

Plug-Ins

(1)

Permitted Hosts

(1)

Default Menu Bar

(12)

The Application Menu

(1)

File Menu

(4)

Edit Menu

(1)

View Menu

(1)

Insert Menu

(1)

Format Menu

(1)

Records Menu

(1)

Scripts Menu

(1)

Tools Menu

(1)

Window Menu

(1)

Help Menu

(1)

Contextual Menus

(3)

Contextual Menus for Fields

(1)

Contextual Menus for Record Content Area

(1)

Contextual Menus for Web Viewers

(1)

Contextual Menus for Window Components

(1)

Contextual Menus for Calculation Formulas

(1)

Summary

(2)

Chapter 3 Exploring a Database Window

(16)

Using a Starter Solution

(2)

Listing FileMaker's Starter Solutions

(1)

Creating a Database from a Starter Solution

(1)

Defining the Database Window

(2)

Identifying Window Areas

(1)

Defining Window Modes

(1)

Defining Content Views

(1)

Exploring the Window Header

(7)

Status Toolbar (Browse Mode)

(4)

Formatting Bar

(1)

Window Ruler

(1)

Managing Multiple Windows

(2)

Creating a New Window

(1)

Closing a Window

(1)

Selecting a Window from the Menu

(1)

Hiding and Showing Windows

(1)

Opening an Existing Database

(2)

Opening a Database through the Launch Center

(1)

Managing Favorite Databases

(1)

Summary

(1)

Chapter 4 Working with Records

(38)

Entering Data

(4)

Opening a Record

(1)

Understanding Field Focus

(1)

Moving to Another Field with Tab Order

(1)

Modifying Field Contents

(1)

Formatting Field Contents

(1)

Closing a Record

(1)

Managing Records

(2)

Creating a New Record

(1)

Deleting a Record

(1)

Deleting All Records

(1)

Duplicating a Record

(1)

Searching for Records

(17)

Performing Fast Searches

(3)

Using Find Mode

(14)

Working with Found Sets

(9)

Defining a Found Set

(1)

Changing the Records in the Found Set

(1)

Sorting Records in the Found Set

(2)

Modifying Field Values for Records in the Found Set

(3)

Find and Replace

(1)

Spell Checking

(2)

Printing

(4)

Page Setup

(1)

Using Preview Mode

(3)

Print Dialog Options

(1)

Summary

(2)

Chapter 5 Transferring Data

(18)

Importing and Exporting Records

(17)

Supported File Types

100

(1)

Downloading Sample Data

100

(1)

Importing Records

101

(9)

Exporting Records

110

(5)

Exporting Field Contents

115

(1)

Summary

116

(1)

Part II Defining Data Structures

117

(138)

Chapter 6 Working with Database Files

119

(36)

Creating a New Database File

119

(1)

Configuring a Sandbox Table

120

(10)

Changing the Default Table Name

120

(1)

Creating Data Entry Fields

121

(2)

Creating a Calculation Field

123

(1)

Creating a Summary Field

123

(2)

Setting Up Layouts

125

(5)

Database File Options

130

(5)

Open Settings

131

(1)

Icon Settings

132

(1)

Spelling Settings

133

(1)

Text Settings

133

(2)

Script Triggers Settings

135

(1)

Maintaining Healthy Files

135

(12)

Database Maintenance Functions

135

(5)

Avoiding Design and Training Deficiencies

140

(3)

Restraining File Size

143

(1)

Understanding File Damage

144

(3)

Specifying File Paths

147

(6)

Formatting Paths

148

(4)

Building Dynamic Paths

152

(1)

Summary

153

(2)

Chapter 7 Working with Tables

155

(16)

Modeling Tables

155

(1)

Introducing the Manage Database Dialog (Tables)

156

(1)

Table Properties

157

(1)

Naming Tables

157

(2)

Managing Tables

159

(11)

Selecting Tables

159

(1)

Adding Tables

160

(9)

Modifying a Table Name

169

(1)

Deleting Tables

169

(1)

Summary

170

(1)

Chapter 8 Defining Fields

171

(32)

Defining Field Data Types

172

(4)

Entry Fields

172

(4)

Display Fields

176

(1)

Exploring Field Content Types

176

(1)

Introducing the Manage Database Dialog (Fields)

177

(1)

Naming Fields

178

(1)

Highlighting the Visibility of Field Names

178

(1)

Defining Standard Fields

179

(3)

Ideas for Standard Fields

179

(1)

Naming Standard Fields

180

(2)

Managing Fields

182

(4)

Selecting Fields

182

(1)

Adding Fields

183

(2)

Modifying a Field Name

185

(1)

Modifying a Field Type

185

(1)

Deleting Fields

186

(1)

Setting Field Options

186

(13)

Options for Entry Fields

187

(9)

Options for Display Fields

196

(3)

Expanding the Learn FileMaker Object Model

199

(2)

Defining Standard Fields

199

(1)

Defining Custom Fields

200

(1)

Summary

201

(2)

Chapter 9 Connecting Tables with Relationships

203

(30)

Introducing Relationships

203

(9)

Defining Relationships

203

(1)

Defining Uses for Relationships

204

(1)

Defining Connection Types

205

(4)

Organizing Relationships

209

(3)

Planning the Learn FileMaker Relational Object Model

212

(1)

Managing Data Sources

212

(3)

Introducing the Manage External Data Sources Dialog

212

(2)

Exploring the Edit Data Source Dialog

214

(1)

Introducing the Manage Database Dialog (Relationships)

215

(1)

Working with Table Occurrences

216

(8)

Selecting Table Occurrences

216

(1)

Interacting with Table Occurrences

217

(1)

Arranging Table Occurrences

218

(2)

Viewing Options

220

(1)

Formatting Table Occurrences

220

(1)

Editing Table Occurrences

221

(1)

Adding Table Occurrences

222

(1)

Deleting Occurrences

223

(1)

Printing the Relationship Graph

224

(1)

Building Relationships

224

(6)

Adding Relationships

224

(2)

Manipulating Relationships

226

(4)

Adding Notes to the Graph

230

(1)

Finalizing the Learn FileMaker Relational Model

231

(1)

Summary

232

(1)

Chapter 10 Managing Containers

233

(10)

Inserting Files into Containers

233

(2)

Insert Menu

234

(1)

Drag and Drop

234

(1)

Copy and Paste

235

(1)

Understanding Container Storage Options

235

(2)

Storing the Actual File

235

(1)

Storing a Reference to a File

235

(2)

Using Managed External Storage

237

(5)

Defining Base Directories

237

(3)

Defining a Field to Store Container Data Externally

240

(2)

Extracting Files from Containers

242

(1)

Summary

242

(1)

Chapter 11 Managing Value Lists

243

(12)

Using Value Lists

243

(1)

Exploring the Value List Interface

244

(2)

Introducing the Value Lists Dialog

244

(1)

Introducing the Editing Value List Dialog

245

(1)

Creating Value Lists

246

(8)

Using Custom Values

246

(1)

Using Values from Another File

246

(1)

Using Values from a Field

247

(2)

Building Value Lists from Field Values

249

(5)

Summary

254

(1)

Part III Writing Formulas and Using Functions

255

(244)

Chapter 12 Writing Formulas

257

(34)

Introducing Formulas

258

(2)

How Formulas Work

259

(1)

Defining Formula Components

260

(17)

Comments

260

(1)

Constants

261

(1)

Field References

262

(1)

Functions

263

(2)

Operators

265

(7)

Reserved Words

272

(2)

Variables

274

(3)

Exploring the Calculation Interface

277

(2)

Exploring the Specify Calculation Dialog

278

(1)

Writing Formulas

279

(10)

Getting Started with Simple Formulas

279

(3)

Inserting Components into Formulas

282

(4)

Creating Repeating Calculation Fields

286

(1)

Using Space to Your Advantage

287

(2)

Adding Calculations to the Learn FileMaker File

289

(1)

Company Contact Count

289

(1)

Contact Address Label

290

(1)

Summary

290

(1)

Chapter 13 Text Functions

291

(22)

Text Function Reference

291

(21)

Char

292

(1)

Code

293

(1)

Exact

293

(1)

Filter

294

(1)

FilterValues

294

(1)

Furigana

295

(1)

GetAsCSS

295

(1)

GetAsDate

295

(1)

GetAsNumber

296

(1)

GetAsSVG

297

(1)

GetAsText

297

(1)

GetAsTime

298

(1)

GetAsTimestamp

298

(1)

GetAsURLEncoded

299

(1)

GetValue

299

(1)

Hiragana

300

(1)

KanaHankaku

300

(1)

KanaZenkaku

300

(1)

KanjiNumeral

300

(1)

Katakana

300

(1)

Left

300

(1)

LeftValues

301

(1)

LeftWords

301

(1)

Length

302

(1)

Lower

302

(1)

Middle

302

(1)

MiddleValues

303

(1)

MiddleWords

303

(1)

NumToJText

303

(1)

PatternCount

303

(1)

Position

304

(1)

Proper

305

(1)

Quote

305

(1)

Replace

306

(1)

Right

306

(1)

RightValues

306

(1)

RightWords

307

(1)

RomanHankaku

307

(1)

RomanZenkaku

307

(1)

SerialIncrement

307

(1)

SortValues

308

(1)

Substitute

309

(1)

Trim

310

(1)

TrimAll

310

(1)

UniqueValues

311

(1)

Upper

311

(1)

ValueCount

311

(1)

WordCount

312

(1)

Summary

312

(1)

Chapter 14 Text Functions (JSON)

313

(8)

Introducing JSON

313

(4)

Defining the JSON Format

313

(2)

Referring to JSON Elements

315

(2)

JSON Function Reference

317

(3)

JSONDeleteElement

317

(1)

JSONFormatElements

317

(1)

JSONGetElement

318

(1)

JSONListKeys

318

(1)

JSONListValues

319

(1)

JSONSetElement

319

(1)

Summary

320

(1)

Chapter 15 Text Formatting Functions

321

(6)

Text Formatting Function Reference

321

(5)

RGB

322

(1)

TextColor

322

(1)

TextColorRemove

323

(1)

TextFont

323

(1)

TextFontRemove

324

(1)

TextFormatRemove

324

(1)

TextSize

325

(1)

TextSizeRemove

325

(1)

TextStyleAdd

326

(1)

TextStyleRemove

326

(1)

Summary

326

(1)

Chapter 16 Number Functions

327

(8)

Number Function Reference

327

(7)

AbS

328

(1)

Ceiling

328

(1)

Combination

328

(1)

Div

329

(1)

Exp

329

(1)

Factorial

330

(1)

Floor

330

(1)

Int

330

(1)

331

(1)

331

(1)

Log

331

(1)

Mod

332

(1)

Random

332

(1)

Round

333

(1)

SetPrecision

333

(1)

Sign

333

(1)

Sqrt

334

(1)

Truncate

334

(1)

Summary

334

(1)

Chapter 17 Date, Time, and Timestamp Functions

335

(8)

Date Function Reference

335

(5)

Date

336

(1)

Day

336

(1)

DayName

336

(1)

DayNameJ

337

(1)

DayOfWeek

337

(1)

DayOfYear

337

(1)

Month

337

(1)

MonthName

338

(1)

MonthNameJ

338

(1)

WeekOfYear

338

(1)

WeekOfYearFiscal

339

(1)

Year

339

(1)

YearName

339

(1)

Time Function Reference

340

(1)

Hour

340

(1)

Minute

340

(1)

Seconds

341

(1)

Time

341

(1)

Timestamp Function Reference

341

(1)

Timestamp

341

(1)

Summary

342

(1)

Chapter 18 Container Functions

343

(14)

Container Function Reference

343

(12)

Base64Decode

343

(1)

Base64Encode

344

(1)

Base64EncodeRFC

344

(1)

CryptAuthCode

345

(1)

CryptEncrypt

346

(1)

CryptEncryptBase64

346

(1)

CryptDecrypt

347

(1)

CryptDecryptBase64

347

(1)

CryptDigest

347

(1)

GetContainerAttribute

348

(2)

Examples

350

(1)

GetHeight

351

(1)

GetThumbnail

352

(1)

GetWidth

352

(1)

HexEncode

353

(1)

HexDecode

353

(1)

TextEncode

354

(1)

TextDecode

354

(1)

VerifyContainer

355

(1)

Summary

355

(2)

Chapter 19 Aggregate, Summary, and Repeating Functions

357

(22)

Aggregate Function Reference

357

(19)

Average

358

(2)

Count

360

(2)

List

362

(1)

Max

363

(2)

Min

365

(2)

StDev

367

(2)

StDevP

369

(1)

Sum

370

(2)

Variance

372

(2)

VarianceP

374

(2)

Summary Functions

376

(1)

GetSummary

376

(1)

Repeating Function Reference

377

(1)

Extend

377

(1)

GetRepetition

378

(1)

Last

378

(1)

Summary

378

(1)

Chapter 20 Financial and Trigonometric Functions

379

(6)

Financial Function Reference

379

(2)

379

(1)

NPV

380

(1)

PMT

380

(1)

380

(1)

Trigonometric Function Reference

381

(3)

Acos

381

(1)

Asin

382

(1)

Atan

382

(1)

Cos

382

(1)

Degrees

382

(1)

383

(1)

Radians

383

(1)

Sin

383

(1)

Tan

384

(1)

Summary

384

(1)

Chapter 21 Logical Functions

385

(16)

Logical Function Reference

385

(14)

Case

386

(1)

Choose

386

(1)

Evaluate

387

(1)

EvaluationError

388

(1)

ExecuteSQL

389

(1)

GetAsBoolean

389

(1)

GetAVPlayerAttribute

389

(1)

GetField

390

(1)

GetFieldName

391

(1)

GetLayoutObjectAttribute

392

(2)

GetNthRecord

394

(1)

394

(1)

IsEmpty

395

(1)

IsValid

395

(1)

IsValidExpression

395

(1)

Let

396

(1)

Lookup

397

(1)

LookupNext

398

(1)

Self

399

(1)

Summary

399

(2)

Chapter 22 Get Functions

401

(44)

Get Function Reference

401

(42)

Get (AccountExtendedPrivileges)

404

(1)

Get (AccountGroupName)

405

(1)

Get (AccountName)

405

(1)

Get (AccountPrivilegeSetName)

405

(1)

Get (ActiveFieldContents)

406

(1)

Get (ActiveFieldName)

406

(1)

Get (ActiveFieldTableName)

406

(1)

Get (ActiveLayoutObjectName)

406

(1)

Get (ActiveModifierKeys)

407

(1)

Get (ActivePortalRowNumber)

407

(1)

Get (ActiveRepetitionNumber)

408

(1)

Get (ActiveSelectionSize)

408

(1)

Get (ActiveSelectionStart)

408

(1)

Get(AllowAbortState)

409

(1)

Get (AllowFormattingBarState)

409

(1)

Get (ApplicationArchitecture)

409

(1)

Get (ApplicationLanguage)

410

(1)

Get (ApplicationVersion)

410

(1)

Get (CalculationRepetitionNumber)

411

(1)

Get (ConnectionAttributes)

411

(1)

Get (ConnectionState)

411

(1)

Get (CurrentDate)

412

(1)

Get (CurrentExtendedPrivileges)

412

(1)

Get (CurrentHostTimestamp)

412

(1)

Get (CurrentPrivilegeSetName)

413

(1)

Get (CurrentTime)

413

(1)

Get (CurrentTimestamp)

413

(1)

Get (CurrentTimeUTCMilliseconds)

413

(1)

Get (CustomMenuSetName)

414

(1)

Get (DesktopPath)

414

(1)

Get (Device)

415

(1)

Get (DocumentsPath)

415

(1)

Get (DocumentsPathlisting)

416

(1)

Get (EncryptionState)

416

(1)

Get (ErrorCaptureState)

417

(1)

Get (FileMakerPath)

417

(1)

Get (FileName)

417

(1)

Get (FilePath)

417

(1)

Get (FileSize)

418

(1)

Get (FoundCount)

418

(1)

Get(HighContrastColor)

418

(1)

Get (HighContrastState)

419

(1)

Get (HostApplicationVersion)

419

(1)

Get (HostIPAddress)

419

(1)

Get(HostName)

420

(1)

Get (InstalledFMPIugins)

420

(1)

Get(LastError)

420

(1)

Get (LastExternalErrorDetail)

421

(1)

Get (LastMessageChoice)

421

(1)

Get (LayoutAccess)

421

(1)

Get(LayoutCount)

422

(1)

Get (LayoutName)

422

(1)

Get(LayoutNumber)

422

(1)

Get (LayoutTableName)

422

(1)

Get (LayoutViewState)

423

(1)

Get (MenubarState)

423

(1)

Get (ModifiedFields)

423

(1)

Get (MultiUserState)

424

(1)

Get (NetworkProtocol)

424

(1)

Get (NetworkType)

424

(1)

Get (PageNumber)

425

(1)

Get (PersistentID)

425

(1)

Get (PreferencesPath)

425

(1)

Get (PrinterName)

426

(1)

Get (QuickFindText)

426

(1)

Get (RecordAccess)

426

(1)

Get (RecordID)

427

(1)

Get (RecordModificationCount)

427

(1)

Get (RecordNumber)

427

(1)

Get (RecordOpenCount)

427

(1)

Get (RecordOpenState)

428

(1)

Get (RegionMonitorEvents)

428

(1)

Get (RequestCount)

428

(1)

Get (RequestOmitState)

429

(1)

Get (ScreenDepth)

429

(1)

Get (ScreenHeight)

429

(1)

Get (ScreenScaleFactor)

430

(1)

Get (ScreenWidth)

430

(1)

Get (ScriptAnimationState)

430

(1)

Get (ScriptName)

430

(1)

Get (ScriptParameter)

431

(1)

Get(ScriptResult)

431

(1)

Get (SortState)

432

(1)

Get (StatusAreaState)

432

(1)

Get (SystemDrive)

432

(1)

Get (SystemIPAddress)

433

(1)

Get (SystemLanguage)

433

(1)

Get (SystemNICAddress)

433

(1)

Get (SystemPlatform)

434

(1)

Get (SystemVersion)

434

(1)

Get (TemporaryPath)

434

(1)

Get (TextRulerVisible)

435

(1)

Get(TotalRecordCount)

435

(1)

Get (TouchKeyboardState)

435

(1)

Get (TriggerCurrentPanel)

436

(1)

Get (TriggerExternalEvent)

436

(1)

Get (TriggerGestureInfo)

437

(1)

Get (TriggerKeystroke)

437

(1)

Get (TriggerModifierKeys)

437

(1)

Get (TriggerTargetPanel)

438

(1)

Get (UserCount)

438

(1)

Get (UserName)

438

(1)

Get (UseSystemFormatsState)

439

(1)

Get(UUID)

439

(1)

Get (WindowContentHeight)

439

(1)

Get (WindowContentWidth)

440

(1)

Get (WindowDesktopHeight)

440

(1)

Get (WindowDesktopWidth)

440

(1)

Get(WindowHeight)

440

(1)

Get(WindowLeft)

441

(1)

Get (WindowMode)

441

(1)

Get (WindowName)

441

(1)

Get (WindowOrientation)

442

(1)

Get(WindowStyle)

442

(1)

Get (WindowTop)

442

(1)

Get(WindowVisible)

443

(1)

Get(WindowWidth)

443

(1)

Get (WindowZoomLevel)

443

(1)

Summary

443

(2)

Chapter 23 Design Functions

445

(12)

Design Function Reference

445

(11)

DatabaseNames

446

(1)

FieldBounds

446

(1)

FieldComment

447

(1)

FieldlDs

447

(1)

FieldNames

448

(1)

FieldRepetitions

448

(1)

FieldStyle

449

(1)

FieldType

449

(1)

GetNextSerialValue

450

(1)

LayoutIDs

450

(1)

LayoutNames

451

(1)

LayoutObjectNames

451

(1)

RelationInfo

452

(1)

ScriptIDs

453

(1)

ScriptNames

453

(1)

TablelDs

453

TableNames

454

(1)

ValueListIDs

454

(1)

ValueListItems

455

(1)

ValueListNames

455

(1)

Window/Names

456

(1)

Summary

456

(1)

Chapter 24 Mobile Functions

457

(4)

Mobile Function Reference

457

(3)

Location

457

(1)

LocationValues

458

(1)

RangeBeacons

459

(1)

Summary

460

(1)

Chapter 25 Creating Custom Functions

461

(16)

Defining Custom Functions

461

(1)

Exploring the Custom Function Dialogs

462

(3)

The Manage Custom Functions Dialog

462

(2)

The Edit Custom Function Dialog

464

(1)

Building Custom Functions

465

(10)

Creating a Simple Custom Function

465

(2)

Adding Parameters to a Custom Function

467

(4)

Accessing Fields from Custom Functions

471

(1)

Building Recursive Custom Functions

472

(3)

Summary

475

(2)

Chapter 26 Introducing ExecuteSQL

477

(22)

Defining the ExecuteSQL Function

478

(3)

How the ExecuteSQL Function Works

478

(2)

Understanding Some Limitations of ExecuteSQL

480

(1)

Creating SQL Queries

481

(15)

Defining SELECT Statements

481

(2)

Using the SELECT Statement

483

(6)

Inserting Literal Text in the Field List

489

(1)

Concatenating Results

490

(1)

Using the WHERE Clause

491

(1)

Using the ORDER BY Clause

492

(1)

Using the JOIN Clause

492

(1)

Using the GROUP BY Clause

493

(1)

Using the UNION Clause

494

(1)

Limiting the Results of a Query

494

(2)

Accessing the Database Schema

496

(2)

Selecting FileMaker_Tables

496

(1)

Selecting FileMaker_Fields

497

(1)

Exploring Other SQL Features

498

(1)

Summary

498

(1)

Part IV Designing Interfaces

499

(220)

Chapter 27 Introducing Layout Mode

501

(18)

Emphasizing the Importance of Layout Design

501

(1)

Using Layout Mode

502

(16)

Identifying Layout Mode

502

(2)

Status Toolbar (Layout Mode)

504

(5)

Menu Changes (Layout Mode)

509

(9)

Summary

518

(1)

Chapter 28 Getting Started with Layouts

519

(40)

Planning Layouts

519

(5)

Classifying Layouts into Type Categories

519

(4)

Sketching a Layout Flow Chart

523

(1)

Working with Layout Parts

524

(6)

Exploring Layout Regions and Controls

524

(2)

Defining Part Types

526

(1)

Managing Parts

527

(3)

Adding Layouts

530

(26)

Creating a New Layout

530

(20)

Configuring Layouts

550

(6)

Deleting Layouts

556

(1)

Using the Manage Layouts Dialog

556

(2)

Optimizing Layout Performance

558

(1)

Summary

558

(1)

Chapter 29 Exploring Layout Palettes

559

(30)

Exploring the Field Picker

559

(2)

Exploring the Inspector

561

(24)

Panel One Defining Position Settings

562

(6)

Panel Two Style Settings

568

(1)

Panel Three Appearance Settings

568

(8)

Panel Four Data

576

(9)

Exploring the Layout Objects Palette

585

(3)

Using the Shortcuts in the Layout Objects Palette Contextual Menu

586

(2)

Summary

588

(1)

Chapter 30 Creating Layout Objects

589

(72)

Introducing Layout Objects

589

(2)

Inserting an Object onto the Layout

590

(1)

Configuring an Object

590

(1)

Working with Field Objects

591

(28)

Clarifying Field Terminology

591

(1)

Field Basics

592

(4)

Configuring Field Control Style

596

(14)

Exploring the Benefits of Pop-Up Menus for Two-Field Value List

610

(3)

Bypassing Value List Entry Restrictions

613

(3)

Using Placeholders

616

(3)

Working with Text

619

(2)

Static Text

620

(1)

Dynamic Placeholder Symbols

620

(1)

Merge Fields

620

(1)

Merge Variables

621

(1)

Working with Button Controls

621

(14)

Working with Buttons

621

(7)

Popover Button

628

(4)

Button Bar

632

(3)

Working with Panel Controls

635

(4)

Tab Control

635

(3)

Slide Control

638

(1)

Working with Portals

639

(11)

Illustrating How Portals Work

640

(1)

Exploring the Portal Setup Dialog

640

(2)

Adding Objects to Portal Rows

642

(1)

Creating Records in a Portal

642

(2)

Deleting Portal Rows

644

(2)

Filtering Portal Records

646

(4)

Working with Web Viewers

650

(5)

Exploring the Web Viewer Setup Dialog

650

(2)

Interacting with Web Viewer Content

652

(1)

Building a Web Page Using Data from Fields

653

(2)

Working with Charts

655

(5)

Creating Charts

657

(3)

Summary

660

(1)

Chapter 31 Manipulating Objects

661

(20)

Selecting Objects

661

(1)

Resizing Objects

662

(1)

Moving Objects

662

(5)

Layout Positioning Helpers

663

(4)

Arranging & Aligning Objects

667

(5)

Align

668

(1)

Resize To

668

(1)

Distribute or Space

669

(1)

Rotate

670

(1)

Group

670

(1)

Lock

671

(1)

Object Stacking

671

(1)

Hiding Objects

672

(1)

Conditional Formatting

672

(5)

Condition Formula Options

674

(1)

Conditional Format Settings

675

(1)

Conditionally Formatting an Invoice Status Field

675

(2)

Understanding Tab Order

677

(2)

Changing the Tab Order

677

(1)

Using Functions of the Set Tab Order Dialog

678

(1)

Naming Objects

679

(1)

Summary

679

(2)

Chapter 32 Using Themes and Styles

681

(12)

Introducing Themes and Styles

681

(5)

Defining Styles

681

(4)

Defining Themes

685

(1)

Using Themes

686

(3)

Choosing a Layout's Theme

687

(1)

Managing Themes

688

(1)

Using Styles

689

(2)

Changing an Object's Style Assignment

689

(1)

Editing a Style's Settings

690

(1)

Summary

691

(2)

Chapter 33 Customizing Menus

693

(26)

Exploring the Capabilities of Customize Menus

693

(1)

Getting Started with Custom Menus Basics

694

(3)

Exploring Custom Menu Set Options

695

(1)

Understanding Customization Exceptions

696

(1)

Exploring the Manage Custom Menus Dialog

697

(1)

Creating a Custom Menu Set

698

(6)

Adding Copies of Standard FileMaker Menus

699

(5)

Customizing Menu Items

704

(8)

Exploring the Edit Custom Menu Dialog

704

(3)

Modifying Standard Menu Items

707

(2)

Adding a Custom Menu

709

(3)

Installing a Menu Set

712

(1)

Exploring the Link Between Commands and Menus

713

(3)

Creating a Status-Based Custom Menu

716

(1)

Summary

717

(2)

Part V Automating Tasks with Scripts

719

(100)

Chapter 34 Introduction to Scripting

721

(28)

Identifying the Benefits of Scripting

721

(1)

Exploring Scripting Basics

722

(6)

Calling Other Scripts

723

(4)

Understanding the Importance of Context

727

(1)

Exploring the Script Workspace

728

(10)

Workspace Toolbar

729

(1)

Script Pane

729

(2)

Script-Editing Pane

731

(1)

Script Step Pane

732

(2)

Script Workspace Menu Changes

734

(4)

Writing Scripts

738

(10)

Script Step Basics

739

(9)

Summary

748

(1)

Chapter 35 Common Scripting Tasks

749

(44)

Allowing User Abort

749

(1)

Setting Variables

750

(1)

Creating Navigation Scripts

751

(5)

Go to Layout

751

(2)

Go to Record/Request/Page

753

(1)

Go to Related Record

754

(2)

Interacting with Fields

756

(5)

Go to Field

757

(1)

Set Field

757

(1)

Set Field by Name

758

(1)

Set Selection

759

(1)

Set Next Serial Value

759

(2)

Get Directory

761

(1)

Working with Records

762

(2)

Import Records

762

(1)

Export Records

763

(1)

Using Show Custom Dialog

764

(3)

Configuring a Dialog

764

(2)

Configuring a Dialog for Field Input

766

(1)

Capturing the Button Click

767

(1)

Conditionally Branching with If Statements

767

(3)

Building Simple If Statements

768

(1)

Building Compound If Statement

769

(1)

Building Nested If Statement

769

(1)

Performing Searches

770

(1)

Working with Found Sets

771

(1)

Iterating with a Loop Statement

772

(5)

Looping Through a Found Set of Records

772

(2)

Looping Through Lists of Data

774

(1)

Confirming a Dialog Field Value

775

(2)

Scripting Portal Functions

777

(2)

Navigating to a Portal Row's Record

777

(1)

Adding a Portal Row

778

(1)

Managing Windows

779

(11)

Creating a New Window

780

(8)

Introducing the Card Window

788

(2)

Managing Errors

790

(1)

Summary

791

(2)

Chapter 36 Debugging Scripts

793

(8)

How Script Debugging Works

793

(2)

Uses for the Script Debugger

794

(1)

Defining Basic Debugging Concepts

794

(1)

Activating the Debugger

795

(1)

Exploring the Debugging Interface

795

(3)

Debugging Options Under the Tools Menu

795

(1)

Exploring the Script Debugger Window

796

(1)

Exploring the Data Viewer Window

797

(1)

Using Custom Breakpoints

798

(1)

Summary

799

(2)

Chapter 37 Using Script Triggers

801

(14)

Script Trigger Reference

801

(10)

File Option Triggers

802

(2)

Layout Triggers

804

(5)

Layout Object Triggers

809

(2)

Working with Script Triggers

811

(3)

Finding Script-Triggered Objects

812

(1)

Remembering Event Precedence

812

(1)

Using Caution with Script Parameters

813

(1)

Exceptions to Event Triggers

814

(1)

Summary

814

(1)

Chapter 38 Extending Features with Plugins

815

(4)

Purchasing Plug-Ins

815

(2)

360 Works

815

(1)

Productive Computing

815

(1)

Trio Automatisering

816

(1)

Finding Other Plug-ins

816

(1)

Locating Installed Plug-Ins

816

(1)

Installing Plug-Ins

817

(1)

Accessing Plug-In Functions

817

(1)

Summary

818

(1)

Part VI Sharing and Networking

819

(80)

Chapter 39 Introducing Network Sharing

821

(30)

How Network Sharing Works

821

(2)

Limitations to Sharing

823

(1)

Setting Up Peer-to-Peer Database Sharing

823

(2)

Using a FileMaker Server

825

(16)

Understanding Client License Options and Limitations

825

(2)

Exploring FileMaker Server Basics

827

(13)

Hosting Databases with FileMaker Cloud

840

(1)

Accessing Databases from Outside FileMaker

841

(8)

Sharing Bookmarks with Snapshot Links

841

(1)

Using the FileMaker URL

842

(3)

Using AppleScript to Automate FileMaker

845

(4)

Summary

849

(2)

Chapter 40 Securing Database Access

851

(28)

Exploring the Benefits of Security

851

(1)

Defining Default Security

851

(1)

Exploring the Security Dialog

852

(4)

Exploring the Interface Modes

853

(3)

Creating Accounts

856

(5)

Creating a New Local Account

856

(2)

Creating a New External Account

858

(3)

Exploring Privilege Sets

861

(10)

Default Privilege Sets

862

(1)

Creating Custom Privilege Sets

862

(9)

Exploring Extended Privileges

871

(5)

Defining Built-In Extended Privileges

871

(1)

Using Custom Extended Privileges

872

(4)

Controlling File Access

876

(1)

Summary

877

(2)

Chapter 41 Advanced Sharing and Analysis Tools

879

(16)

Database Design Report

879

(6)

Generating a Design Report

879

(2)

Exploring a Design Report

881

(3)

Introducing Professional DDR Tools

884

(1)

Developer Utilities

885

(9)

Exploring the Developer Utilities Dialog

885

(2)

Specifying Solution Options

887

(7)

Summary

894

(1)

Chapter 42 Getting Connected

895

(4)

Connect with Mark Munro

895

(1)

Learn FileMaker Pro 16 Official Sites

895

(1)

FileMaker Inc

896

(1)

Database Design Report (DDR) Analysis Tools

896

(1)

Plug-Ins

896

(1)

Communities

896

(1)

Technology Sites

897

(1)

Function Background Information

897

(2)

Index

899

Mark Munro is an author, software developer and entrepreneur. A 1988 introduction to FileMakerled Mark to pursue a career as a developer. Soon after, he was using AppleScript and FileMaker forinformation management and process automation. In 1994, Mark founded Write Track Media, acomputer consultancy to develop custom database and workflow automation solutions for clients.Today, Mark continues in that mission, using AppleScript and FileMaker Pro in combination withother tools and technologies to build time-saving systems for a diverse list of clients. Armed withthe conviction of the virtue of using of technology to free human focus from repetitive computertasks so they can pursue a higher level of productivity, Marks passion for the work isunwavering.

Lisainfo e-raamatute kohta

Püsilink: https://www.kriso.ee/db/97814842286306e.html

Märksõnad:

E-raamat: Learn FileMaker Pro 16: The Comprehensive Guide to Building Custom Databases

DRM piirangud

Kopeerimine (copy/paste):

Printimine:

Kasutamine:

Konto & seaded

Otsing

Otsingu andmebaas

Filtreeri tulemusi

Teemad E-raamatute teemad

Vali ostukorv