E013 – Transactions and Rambling

We discuss transactions in FileMaker and several approaches. Geist Interactive Karbon Update Transaction Logs Geist Interactive FileMaker transactions Scarpetta Group JSON Transactional Edits ClickWorks – Transactions without Portals FileMaker Transactions – YouTube

E011 – Virtual Lists Technique Discussed

On this episode we discuss Virtual Lists, what they are, how they work and some general uses. Learn more: Virtual Lists in 3 Easy Steps by Mighty Data Using the Virtual List Technique by Soliant Flexible Reporting with Virtual Lists and ExecuteSQL by Martha Zink (DevCon2018)

E010 – Blueprinting and Wireframing for FileMaker

In episode 10 of FileMaker Off The Record we talk about our blueprinting process and wire framing. Some recommended reading: Paper Prototyping: The Fast and Easy Way to Design and Refine User Interfaces Sketching User Experiences: Getting the Design Right and the Right Design Sketching User Experiences: The Workbook

E009 – FileMaker Get() Functions

We chat about some of the FileMaker Get() functions, how we use them and some things to be wary of. Get(AccountPrivilegeSetName) Get(ActiveFieldContents) Get(ActiveFieldName) Get(ActiveModifierKeys) Get(ActiveRecordNumber) Get(CurrentHostTimestamp) Get(CurrentPrivilegeSetName) Get(Device) Get(DocumentsPathListing) Get(Filename) Get(FilePath) Get(LayoutTableName) Get(ModifiedFields) Get(NetworkProtocol) Get(NetworkType) Get(PersistentID) Get(RecordOpenState) Get(TriggerKeystroke) Get(UserCount) Get(UUID) Get(UUIDNumber) GetSensor()

E008 – FileMaker Google Autocomplete Game

We discuss Repeating Global Fields, Lookups, Duplicate Records, Deleting Multiple Records, Searching, Locking, Custom Functions. Using Hide Object When and referencing repeating fields requires you to specify the repetition, even with the first repetition.

Episode 4 – FileMaker Certification

Studying for Certification FileMaker 16 Certification Study Guide FileMaker 15 FTS (FileMaker Training Series) FileMaker 17 Study References Tech Specs fmpa Tech Specs fms Tech Specs fmgo Tech Specs Schema FileMaker Help under Defining Database Tables Working with Related Data External Data Sources Layouts Layouts and Reports Web Viewers  Creating Charts Script Triggers Navigation Script Steps …

Episode 4 – FileMaker Certification Read More »

Episode 2 – FM17 Clarifications for ep. 1

Mentioned in this episode are two YouTube videos: Productive Computing – FM Data Migration Assistant FileMaker Training Videos – FileMaker Server 17-FMDT Free Wrapper App For more information on Default Fields Soliant TV – Customizing Default Fields