Title:FileMaker Pro Scripting Book with AppleScript English Edition
Author:Takaaki Naganoya@Piyomaru Software
Technical Supervisor:Masayuki Nii
Price: JPY 3,000 (About USD 30)@our ebook store, JPY 3,500+VAT 10%@PayPal
Delivery: Soon@our ebook store, 1 business day @ paypal (Check and return your URL on cloud storage via email)
Page:158
File format:PDF
Supplement : AppleScript files / RTF exported files / Piyomaru Script Assistant v2 (Japanese Version)
–> Online Store
This book is a comprehensive explanation of the description of controlling Claris’ database application “FileMaker Pro” from AppleScript, with an emphasis on the basics.
FileMaker Pro provides a unique scripting language for automating your day-to-day operations. If your day-to-day work is done only within FileMaker Pro, it may be sufficient to use FileMaker Pro’s own scripts.
However, if you are using other applications with FileMaker Pro (such as Mail.app, Safari, TextEdit, or your own application), you should add AppleScript as a great partner for FileMaker Pro. That’s it!
Your future isn’t just about adding FileMaker Pro to one of the applications called by AppleScript.
Surprisingly, you can also call the macOS Cocoa API from within FileMaker Pro via AppleScript.
This fact means that you have the option of distributing a “.fmp12” file packed with everything you can do on your Mac.
▲All pages are composed by screen shots
Table of contents
Cover
Trademarks and Copyrights notice
It’s a FileMaker Pro + AppleScripting time!
Preface
About this book
Piyomaru Software Apps
Piyomaru Software Books
Beginner Level
AboutFileMaker Pro
FileMaker Pro, a database application
Components of database document
Condition to access from AppleScript
Column【FileMaker Pro product family】
Launch Script Editor
Launch Script Editor!
Change Lexical color settings
Input your first AppleScript
Save your AppleScript
Check FileMaker Pro’s scripting dictionary
Security Settingsin macOS
“Security & Privacy” pane
Important privacy settings
Set-up “Extended Privileges”
Add Extended Privileges to FMDB①
Add Extended Privileges to FMDB②
Add Extended Privileges to FMDB③
Column【Minimum Privileges】
Launch FileMaker Pro
From AppleScript
Two control styles
Launch FileMaker Pro.app
Quit FileMaker Pro.app
Column【Ident FileMaker Pro/Advanced】
Open Database
Name and extension of document
Get database name
Close database
Open a database
Get document info
Column【Path styles which FileMaker Pro require】
Open RemoteDatabase
3 types of servers
“fmp://” URL format
Server ①(FileMaker Pro, Peer to peer)
Server ②(FileMaker Server)
Server ③(FileMaker Cloud)
Column【How to enable peer-to-peer sharing】
Column【TCP/IP port number of FileMaker Pro series】
Intermediate Level
Get info fromtables
Get table info from document
Get name of fields in the table
Get field information from the table
Change layout
Check the existence of the layout
Change the layout
Column【Unusable functions for AppleScript】
Get current record
Use current record
Column【Record id = Unique numbers】
Get / set info from various fields
Kinds of field
Use field object to access FM fields
Text field
Text field with style attribute
Number character field
Date, Time, timestamp field
Container field
Write image to container field (direct data store)
Analyze container field (2/1)
Analyze container field (2/2)
Calculation field (Read Only)
Get value list of slection UI embedded field
Repetition field (whole access)
Repeating field (element access)
Column【If you can’t access the field from AS】
Get current records in current view
Current records in the current view
Process records currently contained in the view
Make new record and set data
Create new record
Create new record and set data
Create new record with data
Sort a table
Table sorting (from GUI)
Table sorting command (mono-key)
Table sorting command (multiple-key)
Simple find
Easy find command = show
Advanced Level
Find by multiple conditions
Find record from GUI
Find execution step with mono-condition
Find execution step with uni-condition
Complex find with multiple request
How to process the result from multi-req
Delete records
Delete current record
Delete every record in the current view
Delete every record
Specify the target database
database 1 = front document@FileMaker Pro
How to know the name of front document
Access frontmost document
Call FileMaker Script
Check the existence of the FileMaker Script
Call FileMaker Script
Call FM Script via URL events
“fmp://” format ②
Write AppleScript in the FileMaker Script
Script step”Execute AppleScript”
Unique problem in “Execute AppleScript”script step
Check the keyword confliction
How to de-select selected fields
Get the file path of FileMaker Pro document
Convert path from FileMaker Pro script
Samples and Data
Sample Scripts
AppleScript-able function mapping
To ignore the difference with FileMaker Pro and Advanced
Sample: QR image recognition in the obj field
Sample: Add fields as you like
Bennchmark
AppleScript vs FileMaker Pro
AppleScript only script (Cocoa Scripting)
FileMaker Pro calling script
FileMaker Pro’s AppleScript Dictionary
FileMaker Pro scripting dictionary
AppleScript Standard reserved words
AppleScript references
Technical Supervisor’s Afterword
Author’s Postscript