FileMaker Off The Record Podcast: Recent Episodes
Thomas Mokwa - FileMaker Consultant
Thomas and Teresa interview Greg Price from AL3 Technologies. We talk about working from home with your significant other, the ups and downs of sharing office and home life.
A chat with Marty Thomasson and Tim Cimbura about our time at Pause on Error October 2022
After a brief comparison of the Delete Record menu option and the Delete Record script step we review all of the FileMaker Functions that start with Get..., not Get().
On the 25th episode Teresa and Thomas discuss their new years resolutions for future FileMaker development.
Tonight Teresa and Thomas have a chat about a couple of projects that we are working on including Medical Billing and a Theater Ticketing solution.
Coach Carol from EPS-Time talks with us on this episode about the need for coaching and the special needs of ADD/ADHD entrepreneurs.
You can download her free pdf at: http://bit.ly/DevBestLife
On this episode we talked to Daniel from New Leaf Data and discussed his company, his focus and his recommendations for newer developers. Daniel was generous enough to offer a discount code for his FM Inventory Starter file that you can get using the link below.
http://NewLeafData.com - The inventory specialists.
http://FileMakerInventoryResources.com - A resource site for building your own inventory management system on the FileMaker Workplace Innovation Platform. Includes articles and demo files.
http://www.FMInventoryStarter.com - FM Inventory Starter is a free and flexible foundation that is great for warehouses, distributors, and manufacturers.
http://www.TrayseInventory.com - Off the shelf Inventory solution. An inventory management system that's flexible, affordable, and intuitive!
We just realized that we never did an official introduction of ProFile Developers so in this episode I interview Teresa to get a little background. We hope you enjoy this.
On this episode we discuss the Data Separation Model used in FileMaker development. We rebut the arguments made on the July 22, 2019 podcast Fireside FileMaker by John Mark Osborne and Michael Rocharde. You can listen to their discussion on the Separation Model using the link below (spoiler alert: they both have a mild hatred of the model).
Fireside FileMaker: The Data Separation Model
Functional Separation Model
Karbon Webinar
LOgiCATOR
Data Separation and Account Security
Join us as we review DevCon19. We review the various sessions that we attended during the recent FileMaker Developers Conference held at the Gaylord Palms Resort in Orlando Florida.
Teresa and Thomas discuss working with clients and how they deal with certain issues that inevitably arise.
In this episode we discuss several tips and things to be aware of when developing a solution in FileMaker Pro Advanced 17. FileMaker has been around for a long time and has a few quirks and features, some of which you only learn with experience. This episode will give you tips that will save you time and improve your development skills.
In this episode Teresa and Thomas review several free starter files.
fmIgnite Starter from LuminFire
FM Starting Point from RCC Consulting
FM Kickstart from Kempen Automatisering
FMQuickStart from DB Services
Karbon from Geist Interactive
Beth Latta from IT Solutions is our guest and we discuss our 30 history developing solutions with FileMaker.
We review each of the Design Functions in FileMaker Advanced 17. We also discuss
DatabaseNames A list of the names of all files open on the computer. FieldBounds The location, in points, of each field boundary and the field’s rotation in degrees. FieldComment The specified field’s comment. FieldIDs A list of all field IDs in fileName and layoutName. FieldNames A list of the names of all fields on layoutName in fileName. FieldRepetitions The number and orientation of repetitions of a repeating field as formatted on a layout. FieldStyle The field formatting applied to fieldName on layoutName in fileName. FieldType Information about fieldName. GetNextSerialValue The next serial number of fieldName in fileName. LayoutIDs A list of all layout IDs in fileName. LayoutNames A list of the names of all layouts in fileName. LayoutObjectNames A list of the names of all named objects on layoutName in fileName. RelationInfo A list of four values for each relationship directly related to tableName. ScriptIDs A list of all script IDs in fileName. ScriptNames A list of the names of all scripts in fileName. TableIDs A list of all table IDs in fileName. TableNames A list of all table occurrences in the relationships graph for fileName. ValueListIDs A list of all value list IDs in fileName. ValueListItems A list of the values in a value list. ValueListNames A list of the names of all value lists in fileName. WindowNames A list of the names of windows that are currently open.
https://www.databuzz.com.au/using-executesql-to-query-the-virtual-schemasystem-tables/
https://mightydata.com/sql-reserved-words-in-filemaker/
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
We play the Google Autocomplete game again, this time with "FileMaker Can..."
Mentioned in this episode:
Plugins
Dacons Mail.it 360Works Email Plugin CNS SMTPit Pro MonkeyBread Software MBS
Sending Text Messages with FileMaker
Databuzz fmSMS
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)
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
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()
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.
FileMaker DevCon 2018 has ended. We talk a little about the conference in Dallas and have an interview with Marty Thomasson from Gearbox Solutions.
DevCon 2018 Dinner Party Dallas Texas
In this episode we discuss some things to be wary of: system requirements for FileMaker Server 17, case sensitive functions, zero based functions. And a couple cool tips.
In this episode we discuss some of our favorite modules available at Modular FileMaker.
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
Calculations Working with Functions and Formulas Functions Reference Custom Functions
Scripts Scripts Script Step Reference Run Scripts
Security Security Prepare for Installation Encryption SSL Server Security
Deploying Custom Apps Install on a Single Computer Install on Multiple Computers Whats New 17 (Changed and Removed Features List) Schedule Admin Tasks
Data Integration Saving and Sending Records
Publishing FileMaker Data on the Web fms 16 CWP Guide (17 not yet available) WebDirect
Development Tools and Processes Debugging Scripts Custom Menus
FileMaker Go
FileMaker Data API
FileMaker Data Migration Tool
Mentioned in the episode:
MBS FileMaker Plugin - Plugin with over 4,000 functions from Monkeybread Software
Developer Assistant - Dracoventions developer plugin
Scripting Deep Dive Training Class - June 5 2018 at the Pittsburgh Training Center
This is our first podcast episode and we discuss the newly released FileMaker 17 platform.