FileMaker Off The Record Podcast

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

We discuss various productivity methods

After a 2 year hiatus we are back

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().

We give some advice and tips for working at home during the COVID-19 shutdown.

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.