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