FileMaker

Designing and developing with Claris FileMaker Pro Workplace Innovation Platform.

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

Vertical Markets

I gave a talk on creating and marketing vertical products with FileMaker Pro at thePittsburgh FileMaker users and developers Meetup and FMBurgh. Here are some of the items that were mentioned: To look for ideas, look at what others are hiring for eLance.com or Upwork.com Smashing Magazine: So You Want To Build A Software Product Documentation Tools …

Vertical Markets Read More »

Dealing with FileMaker script parameters (Scripts as Functions)

One of my naming standards has been with script names. Through many versions of FileMaker Pro I have tried to keep my script names clear and concise. This has worked well for me. When FileMaker introduced script parameters in version 7 that was a huge improvement. With script parameters came the function Get(ScriptParameter). And we …

Dealing with FileMaker script parameters (Scripts as Functions) Read More »