Filemaker Success Tips: Recent Episodes

Lee Strong and Andy Cohen

Lee Strong, with 23 years of database and FileMaker experience, and Dr. Andy Cohen, with 25 years experience in IT development for fortune 500 companies, discuss valuable tips and hard to find tricks which enhance developing applications in FileMaker Pro.

These guys give an informative overview of not only the hidden stuff but also consulting issues such as project definition, pricing and scope as well as a regular review of functions and script commands. They also make a point of having a lot of fun!

View Details

Sign-off, farewell.

View Details

Is It too complicated?, Should we do a series?, Indexing and import Repeat

View Details

Biz Politics, Comcast, Privilege Set Testing Repeat

View Details

Large Data Sets, UnixTimeStamp custom function Repeat, Get(Flag) Repeat

View Details

Installing a server, Lookups Vs script-based Record Repeat, When to use Commit Record Repeat

View Details

Apple and the FBI, Layout tip from Jerry, Client upgrade decisions

View Details

Thought on where FM is going, Chopping it Up

View Details

When updates hurt, Getting Motivated, Windows 32 bit vs. 64 bit and Office and plugins

View Details

Deletion Sets, Filemaker/IOS SDK Released, PDF in container on Mac

View Details

CES 2016, Theme Names

View Details

Should you be pragmatic?, Layout Names as Script Parameters, Export CSV with Field Names, How to get into High gear 

View Details

Your Own Design, Too much time into a project?

View Details

Who ya workin for?, Organizing your layouts, Relationship Graph approaches

View Details

Naming your scripts, Culling Fake Data, One to Many Pattern

View Details

Resize Button Trick, User View Design Philosophies

View Details

Starting from scratch

View Details

Always Script It, How to Build your FM Biz

View Details

Handling FM solution updates, New Window, Constrain, Update and Close Window, Internet of Things

View Details

Theme Magic?, Script Workspace last line, How to remove favorite host, Command Key Fun

View Details

NutShell+, To multi or not

View Details

Mac Keychain Off, How many themes, Nutshell Request, Sequence Fix

View Details

Branding as WebDirect, Double click pain, Making inputs explicit

View Details

Setting up a an FMS Fusion connection, Revisit on FMS server Reqs, When a UPS is not enough., To separate or not to separate

View Details

Navigating the relationship graph, Is FM Interest waning?

View Details

Another bid method, Open local remote file in FM14, FMS14 HW requirements

View Details

Task bidding for FM proposals, Use the launch center to delete recents, When should you upgrade your FileMaker?

View Details

Open Raw CSV, Getting specifics from Clients, Merge Printing Page Control

View Details

Removing Asterisk, Server OS requirements, Using Estimation System

View Details

Fixing a dangerous shortcut, Upgrading to 14, First step for project from scratch

View Details

Net Suite pt3, More EMV and CC Processing pt3, Netsuite Listener Reply

View Details

EMV2, A Merge Technique, Record lock on approval

View Details

Starter Apps revisited, EMV Part1

View Details

How to Start To Renovate, NetSuite ODBC part 2, Syncing Question

View Details

Clean up Spaghetti, Server Backups, Sliding Side Bar Nav

View Details

NetSuite ODBC, Server not letting go, Add Icon to Launch Center

View Details

Get Directory, Script workspace shortcuts, Allow Keychain access to save passcode

View Details

Field Comments and In-Field labels, Inbound Marketing, Color Picker

View Details

Launch Center, New Security Dialog, Badges in layout mode, Btn Bar Btn Labels

View Details

Script Workspace Tips, SVG Files for icons, Backwards compatibility

View Details

Calculation engine calculations, Nav Parts, Dynamic Button bars, Hamburger Menu

View Details

Multi-File Import, Button Icons, Nav Partition and button bar, Placeholder text

View Details

FM 14 released, Apple Watch

View Details

Vexed with Reporting, FM Starting Point

View Details

Container Fields remote PDF access, FileMaker writers block, Win 7 on the Mac

View Details

Container Interactive Content, Newbie Flubs, Looking forward

View Details

When to switch architectures, InspectorPro 5 First Blush

View Details

Go Same Record Revisit again, Connector Selector First blush

View Details

Go Same Record Revisited, fmXRaySpecs, Helper File

View Details

Data Sources, adioS

View Details

InspectorPro 5, Data Driven Graphics, Mandelbulb.com

View Details

Reports Model Part 3, Search, Sort, Go Specific record, Replace Some Text

View Details

Reports Model Part 2, Version Conversion, To Sync or not to Sync

View Details

When the client wants it all, OS Rudeness, Reports Model Part 1

View Details

Buying Version 1, Calendar Stuff, When the client wants to design ad hoc

View Details

Optimizing For Performance, SyncAndAsync, Round Trip

View Details

Upgrade options on New MacBook Pros, Records are all or none, FM logo

View Details

Revamping Old Projects, Commenting on commenting, Starting a slow client

View Details

Favorite Functions, CES roundup

View Details

Case Statement, Send link file as Email quirk, Deprecated Themes, Nav Path Spaghetti

View Details

Designing in FMGo for IOs, Pono, Deprecated Assets

View Details

Integrating link files into email, Script Versioning, Hidden objects for testing, Hard coding a filename for future imports

View Details

Customer Recoveries, New MacBook Pro, Stand alone iPhone app, Why layouts update

View Details

Saving design Modules, Get Field Name function, An Easy Interface, RelationshipGraphLabels

View Details

No Spaghetti Please, Yosemite, Balance Calculation

View Details

A Navigation Button Design, Poor Man’s Backup, Adding Portal Rows

View Details

Thinking Ahead, When you did it wrong, New Untested System Components

View Details

Typical mistakes in decoupling scripts, 2 theme tools

View Details

No padding in table view, Latest Radioshack stuff, Get( Scriptresult ) and Dialog boxes

View Details

Clean the slate?, Testing the small and missing the big, Duplicate or Copy Record

View Details

One to one revisit, Get(TemporaryPath) Revisit, Whats “Normalized” data?, Easy to create, hard to maintain

View Details

Status Rollup, Legalese, When you have to script it

View Details

More on Self, Proxy fields, Temp Items on a Layout, Selecting the wrong design.

View Details

Chromebook effect, It’s a data server, not a file server, Making a pdf and attaching to email

View Details

Moving records from one table to another, Getting a temp desktop path

View Details

One to one, Lets Go to a Web based Turnkey, Getting out of the Funk

View Details

3 tiered TO Design Patterns, Self in Conditional Formatting, 1 to multiple manys

View Details

Repeat Fields in Calendar, Script Placeholders, DDR Search, Sometimes it all just works

View Details

Capturing data in emails, Table of Contents on PDF, Setting a beginning page number, More naming stuff

View Details

Install OnTimer Script Reminder, How to share a file during small project development, Can WebDirect do distributed Dbs?

View Details

Test Mode for printing, Find Items not Purchased, Setting a shared file, GoDraw

View Details

Mid Design steps, Raspberry Pi, The value of decoupled scripts

View Details

Get (ModifiedFields), Portal Item Controls

View Details

How do you line them up?, Updating Previously Imported Data, Listing Reports

View Details

Sorting Portals, Using the Return Key for controlling Dialogs, UI Structure

View Details

New Use Case ruins the key. Should you always do what your client asks? How to get the customer moving.

View Details

Popover Button Fun, Popover limits, Status in our calendar

View Details

Go to related record in a different context, Setting grids on served files, Watch your screen resolution

View Details

Different checkbox value list for single field, MDB Explorer, Updating data without updating date modified and modified by, Truth Tables

View Details

Pasting into Matching TO names, SerialIncrement, Chromebook

View Details

When you pick the wrong thing for your key, Bernard will fix Windows, The 1st layout your user sees

View Details

Vendors Vs Companies, 12 or 13 FMS?, Insert from Index, CLI to FMS

View Details

The Situation, Portal Styles, Cash Cow

View Details

Combining into 1 table Revisit, Labels in field, Multi-Table Reports

View Details

FMS12 uninstall Fail, iBeacon and Go?, Urls in text fields, Compressing into 1 table

View Details

Organizing practices in structural design, Themes Available, Use Dash “-” with checkboxes, radio buttons

View Details

Make your own Calendar, Post Office Scrub to Excel, Operating system compatibility

View Details

More working with themes and styles, Check Logo / Image jpg size, Repeating field fields

View Details

Defining an Entity, Checking version of FMS, Changing objects to the theme

View Details

Color Stuff, Using Merge files for import/export, Why go FMP revisit

View Details

Playing with Themes, Interface for Security Privileges, Paper Dolls

View Details

TO Naming, Themes and Tab control, Popover caution

View Details

Table View and Web Direct, Simple Imports from Pre-12, Calc Fields or Multi Resources

View Details

Diagrammix, Rant for pragmatics, Radioshack ad from the 90s, To combine or not

View Details

Keeping it organized, WebDirect Vs FMGo, Building Layouts for themes

View Details

Big Imports, Flashterm, Managing new field names

View Details

Going from multiple file to a single, Sell Away from Quickbooks, Sales Tax lookup

View Details

CES overview 2014, Design Note Popover, You Can Still Use CWP

View Details

GetContainerAttribute, Slider control, Script Animation

View Details

New Barcode scanning with IOS, Option Drag, Just like a RAM disk, New SQL stuff

View Details

WebDirect Pricing, Hide Object When, 3D Printing Jeopardy

View Details

1st experience with WebDirect, FMS admin console, Can WebDirect generate reports?

View Details

Connections Pricing Model, Padding, Installing FMS13, VM Grief

View Details

Layout mode objects snap , Backwards compatible to 12, FM13 iOS Requirements, Nudge with Arrow Keys

View Details

New Project Task flow, Dictation in Mavericks, 3D scanning

View Details

Client Clarifications, IWP, No records found

View Details

Searching Date and Time ranges, Arduino, Garageband

View Details

Things we wish they would change FM, FMGo Things we wish they would change, Finding New Biz

View Details

Testing Before Use, InkPad, Maverix

View Details

Scary Stories, Spreading Thin, Terrifying Clients

View Details

Speed Issues, Comment Revisits, More FM SQL, Filemakerhacks.com

View Details

Insert Merge Variable, Broken Printer, Self join many to many

View Details

Installing Server, SQL your Schema, iMac DVD slot eats SD cards

View Details

IOS7 Issues, Can’t Meet the Requirement, Imports from same file

View Details

Unsolvable problem, Symbol Inserts, Autocalcs for indexing

View Details

Dealing with internal IT when you are not in IT, Install Menu Item, Anchoring objects

View Details

draw.io, Filtered Portal Update, Design an FM DDR

View Details

How to break the ice, Tables in a file, Layouts in a file

View Details

Windoze Pain, Get (UTCmSecs), Bypassing script triggers

View Details

Max Serial number, Tab Perrmissions, http://alternativeto.net/

View Details

Fields on a layout, Do not disturb, Orphan Records 

View Details

Things to do at startup, Open with No Status Tool Bar, Read Only Files

View Details

System Disaster, Substitute, Andys Apps

View Details

iPad Restore, Part Borders, Re-sequencing numbers, Surprise Website

View Details

Redesign of really old system, Calcing on the fly, Dialog Input

View Details

FM or Oracle, Card Readers, Self relationship

View Details

Auto Entry Options, Decimal to time for whole number, Multiple file security

View Details

Bar Codes, Portal Filter with PatternCount, ScreenFloat, Mac Icons from Marc Berning

View Details

Pricing Questions, Chrome DDR, A weird bug from a listener

View Details

Zero to Hero, Window content pairing, Global Variables arrays cannot use aggregate functions, DecimalToTime

View Details

3D Printing Silliness, Use Pause On Error, It’s hard to make it Easy

View Details

SwordSoft Layout, Find Em All, Email from Jerry

View Details

Global Fields vs Global Variables, Repeat Global Variables

View Details

One to One, one layout, multiple sub summaries with multiple sorts, Portal Filter Requirement

View Details

Coordinating windows, Making an Icon Library, Many to Many

View Details

Icon source, Option-Select All = Select Same, Halt Script/Exit Script Revisit

View Details

Phantom Records, Random Function, Cross platform window size

View Details

Always trap for caps lock, Java and Snow Leopard, Checkbox Search Great Solution

View Details

Minimum Project Problem, Always trap for error 101, Check box Search Revisit Version 2

View Details

Checkbox Search Revisit, Speak date on iOS 4/2/13, Directories Anyone?

View Details

Data Migration Fun, Record Locking Windows, Turnkey app Performance

View Details

Thing DB update, Fix It Mode, Can Calc fields hide followup

View Details

Remote TOs for Go, Oops, Can Calc flelds hide?

View Details

Updating from 11 to 12 & Go, More Email

View Details

UPS Stuff, 3D print trials

View Details

Bandwidth & Unique ID, Install On Timer, When ya gotta be there

View Details

3D Printer, Record Lockin, A Thing DB

View Details

CES2013, Evolving Updates

View Details

Fake Names revisit, Cognitive Load, Highlight on a click

View Details

Get ( TriggerTargetTabPanel ), Google Drive, Another shortcut, One more thing... on repeat fields

View Details

Making it unique, Tale of 2 Installs

View Details

Cash Drawer Manager, Error Trapping

View Details

UI Rant, Clean your data

View Details

Why globals?, Start icon with logins

View Details

Lost Check Boxes, Feature creep or requirements definition?, Convincing Client to Redesign

View Details

Making a Letter Name, Terminal app on Mac OSX for fmsadmin, Another use for repeat fields

View Details

A Usability Review of Win 8, Zero Records Found Set, Client Challenges Revisit

View Details

Client Challenges, Watch ur context, When to be too Expensive

View Details

Showing the “Many” to a spreadsheet user, Why Java, Zero Records revisit, Run Dates

View Details

Upgrading to Windows 8 , New computers need new FileMaker

View Details

Pogoplug, Delineate Fields, Sending emails in Go

View Details

FMI’s App Maker, Location and LocationValues, Orientation View Switching

View Details

Libsyn UI lessons, Guide to Guides, Print Disabled?

View Details

When NOT to use Merge Variables, Logoist, Bypassing the Cancel/Continue Script dialog, John Sindelar Road Show report

View Details

Get nth Record, Find Mode Approaches, Ungroup it all for good screen updates, Spreadsheet UIs in dBs

View Details

Apple vs Samsung, Wireframe tool, Restore found set, Finding orphaned data

View Details

Fun with names, Multi-environment considerations, Relationship Integrity

View Details

Undocumented Feature, No Max Windows, Control your color schemes

View Details

Letter from Nicolas, Grow Your Product Conference, Layout work improving

View Details

Sending Mail from FMP, Insert Other Symbol, Preview o fNew Theme Studio, Irrational Requirements

View Details

Time Tracking, Relationship Graph Alignment, Field Evaluation Table

View Details

Display update performance in 12, Square Peg Round Hole, Stand Alone Converter

View Details

Testing Streaming with the new Container, Mountn Lion, Table view sort indicators

View Details

Lee Builds In Go, New Window Style Trap, Building for an expert FMP user.

View Details

Layout Challenges, New “commit” on custom dialog, Lee’s G5 died

View Details

Lessons learned with privileges, Keyboard confusion, Changes in layout mode

View Details

Storage for new containers, Use IsValid, Death of CE

View Details

Layout Challenges, Command Key Tips, No more pixels

View Details

Starting a new project based on an earlier model, Launchpad Controller, First for Free

View Details

Inventory, Storing BD without Year, An Entity Design

View Details

When to use Commit Record, Security and Relationships, Using DayofWeek

View Details

FM Go 12 good & bad, Get(documentpath), NewLines, Exporting Subsummaries into Xcel revisit, Lees 2 way Join

View Details

Get(applicationVersion)& Patterncount for IWP, TeamViewer steals port 80, Get Privlege Set name, ShortCut ToSchema in Field

View Details

Win7 and FMS, Boolean Data type and square root symbol, License limit

View Details

Getting data from Repeats, Low Cost Layout Review, FMGo12 First Time

View Details

FMS12 1stTry, Prefs Table, Layout Size Shortcut

View Details

New Guides, A bug you can’t track down, ExecuteSQL

View Details

New Layout Object Stuff, Making Themes

View Details

Client Missing Records, Wifi Issues, Get ( ActiveModifierKeys )

View Details

FM12 Performance Questions, Keys, Lost FMS connections, Value List Challenge

View Details

Our FM12 special edition

View Details

Speed Up iOS, GetLayoutObjectAtt, Excel Trick, Multi vs Single Files

View Details

UI Design Case, Crowded Portal, Best Practices with Live Systems

View Details

Halt Vs Exit Revisit, CheapWin7boxRevisit, Summary Report export to Excel

View Details

Report Headers and Footers, Using Count Of, Reminisce

View Details

Server TimeOuts, FM Go on iPhone voice into fields, The New Cheap PCs, iOS Fonts

View Details

Replace Field Contents, Are you the Admin?, Broken File, Power Data Viewer

View Details

Ringtones, Page 1 of XXX, Summing instances of things for reporting, Controlling field input

View Details

Lee Gets an iPhone, Multi User Quandry, Double your rates?, Free new Tech Net

View Details

Tab Control Talk, What clients are asking for, Separation model for iPhone to server

View Details

Andy @ CES, No Rosetta

View Details

Small group setup tradeoff, Update on Lion Install, Commenting your scripts revisit

View Details

Printing Reports, upgrading your OS

View Details

Trainer App Redesign, Upgrading to lion, Showing the user only their records

View Details

Custom Menu Tips, Managing Windows

View Details

AppleTV revisit, A List of Thursdays, Xmas Prsents

View Details

Trying barcodes with FM Go revisit, Swipe to Relationship Graph

View Details

What’s 1st, event or script?, Getting users to logout, When triggers don’t trigger?

View Details

Barcode reading in FM Go, Import Refresh, AppleTV

View Details

Context Talk, Trackpad, Setting up mail merge

View Details

EMail from a Listener, Using QuickSearch in a script, Allowing User Abort

View Details

iOS5andManagingExpectations, Reset Import, Get(applicationversion)

View Details

iOS5andManagingExpectations, Reset Import, Get(applicationversion)

View Details

Trick or Treat:Hosting support, Working Blind, Works4Me, Getting Reviewed

View Details

Conceptual Pattern Called Focus, Substitute, Naming cf

View Details

A standard Table Schema, App Naming, Weebly, Relookup One record

View Details

Working with lists in functions, Bad FM Day, Excel date to FileMaker Date file

View Details

Looping a CF, Pre-indexing, Get ( CurrentHostTimeStamp )

View Details

When to create a custom function, Conditional shortcuts in Calcs, Separation model for buffer tables

View Details

Printing Design Pattern, Split off the Big Stuff, Let Troubles

View Details

steve winter - fm.php, New Record/Request, Scribe & Content Controls

View Details

Constrain Found Set, Gamebox Scandal, Independent Contractor Rules, On-Timer fun

View Details

Conditional Revert Record, data input vs data output, Dropbox Backpeddle, Backup the backups

View Details

tim neudecker - cytrix problem, lee lukehart - making a data visual context, jerry salem - drupal plugin, kirk bowman - value pricing revisit

View Details

Bruce Robertson - virtual list, Kevin Frank - Magickey, Tom Fitch - sorting portals interactively

View Details

Joe King - worldcloud.com virtual clients, Sean Stephens-lassosoft, Dave Simpson-fmpromigrator

View Details

Calling It the right thing, Following Someone Else’s Code, Starting Brand New File

View Details

Error traps 1, iWatch Revisited, Search with Matt, Hit the Use Case Mark

View Details

Server Nightmare with Matt, Scribe Challenges, Findng Nothing, To Calc or Not to Calc

View Details

Reverse Engineering, Some Patterns with Matt, LookupNext Function

View Details

Win 7, iPadMusic 2, Disallowing a button

View Details

ListView Issues, iPadMusic 1, iPod dropping Wifi

View Details

Sweating The Details, Adding new clients, Enlarging a layout by folding it, Form to List Layouts

View Details

Widget Factory Story, Opening Excel files, A Drop Down Puzzle, Startup script Issue

View Details

Invalid Use Cases, Data integrity using save, edit and done buttons, Pass code data systems

View Details

Distributing Stuff For FM Go, Boolean, Users do the data

View Details

Design Pattern Intro, Who owns the design?

View Details

More pricing talk, Logging In, Filler up

View Details

A new client, ID Battle, Clean layout change FM Go, Buffer table for import

View Details

Buying a new server, List function in combination with substitute funtion, Long Value Lists

View Details

Creating troubleshooting interface, Update on puttin a fork in it, Contracting Approach

View Details

Andy goes modal, iPad invoicing system QuickSale, RetroTip, Use record ID from source table

View Details

Working with summary fields, GarageBand, Notebook for Mac

View Details

Page Break span bug revisit, many to many without join table, gimme factor and fixed pricing

View Details

Estimator in FileMaker, Great Puzzles, Weetbicks, Mountain Climbing

View Details

When to put the fork in it, Flexible Sorting, Phone Numbers Formatting

View Details

Hazard Of Tblview in Verticl App, Theme Studio Revisited, When FMserver can’t change the Backup Path

View Details

CalendarPro revisit, Field labels under the field, Theme Studio updates

View Details

FMgoPeer2Peer, Get (TemporaryPath ), Get (DesktopPath), Painful beta testing

View Details

iPod FM Go on an iPad, Reply to Jonathan, FM as Woodturning, GetValue function vs MiddleValues function

View Details

Re-working a previous design, No Stress, No change to field once data is entered

View Details

Start a new solution, Unique ID’s for Tree Database, Clients that make changes

View Details

Prepared Customers, Exit script command at the /end, Preview the whole doc.

View Details

Seedcode Calendar, Export Character Set, Business Logic

View Details

Arrange TOs, Nomenclature - field naming conventions, The problem with script parms, TouchMyData

View Details

Calc fields issue, Polishing trds, Converting checkboxes

View Details

Client Solutions, Process Vs Policy, A Pricing Question

View Details

New Theme Studio, iPod Nano as an iWatch

View Details

360Works; Scribe, Command U/Control U in relationship graph, Using the Webviewer 4 recnum display

View Details

Page breaks with big text... bug, Arrange TOs Issue, Slide Up & working with Preview Mode

View Details

Tableview Revisit, Non FileMaker Tasks, Backup and Record ID, Portal Filter troubles

View Details

Go to Layout [original layout] note: continue discussion with user meaning vs developers meaning, Lookups &. Auto-enter calc on import, You can’t invent  your own steering wheel, Greater than 0 and less than .01

View Details

Conditional Tabs, Some Project Talk, processing records shown in a portal

View Details

When FM is hard , Dropbox Revisited, Portal in a portal

View Details

Designing to the programing environment, Making your own modal dialog, Make UR dialog 2

View Details

Normalize, Radio buttons trick, From File Processing

View Details

Fixed pricing with staggered implementation, Analysis Lessons, Scary Corruption

View Details

Writing Requirements, Batch Code YYMMDDHHMMSS, GoFlexHD

View Details

RSsummit Go app, Get (AccountPrivilegeSetName) vs. Get (CurrentPrivilegeSetName), Quote Function, Defaults and the new Inspector

View Details

Vertical Development How To, RGB tool for Go, Dropbox

View Details

WorldCloud, Average Function, Error Trapping

View Details

DEVCON Themes, Layouts Out of view, Verify Layout Hide tip, More Separation

View Details

Server’s req’d ports, FMonRemoteServers, Server Admin and public wifi, Case statement with no else

View Details

Field named “other”, zoogue ipad case, Bad Wheel UI

View Details

Data seperation in Go, Making FMGo GO on Ipod/iPhone, Any math requiring Quantity * Price should be rounded - added from my iPod, Text Field Goes Big

View Details

Overcoming tiny radio btns, E-Mail Bug (Black Background on Black Text), Strange Date/Time Entry

View Details

Using changeable data or meaningful data for relationship links, Value List as a data source, Going Retro

View Details

What’s reusable by modules?, Go To Original Layout, Pricing a data entry dialog

View Details

How to put a $ value on a solution, Dialog OK/Cancel return, iPhone 4

View Details

Our Filemaker go review. Stuff that works which we are told does not and stuff that has UI issues.

View Details

Troubleshooting missing records, Get (HostAppVersion), Data Movers

View Details

A selection design pattern, Script Result, How to... multiple items from a pulldown into a field

View Details

A sample Use case analysis, Opening a snapshot file in FMP, Interesting Discovery

View Details

Design Consistency, Somethin’ Weird, CustFuncLib

View Details

New Table View features, Snapshot Link Contents, Highight in conditional formatting, QuotesAsTExt, Quickfind note

View Details

WifiAnalyzer, Paste default, Crash story, 3 ways to do charting

View Details

Find Operators, DataTrium, Portal Filtering in Version 11 Part B

View Details

Developer Cards, Layout Folders, More Droid, Whats a terrabyte?

View Details

Cold turkey for Inspector , Use the Snapshot Link, Highlight, Upgrade pain

View Details

Server Vs Peer to Peer, Portal Filtering in Version 11 Part A, Finding and deleting duplicates

View Details

Lookups Vs script-based Record copy, WebViewer_button Custom Function, Server Slow Startup

View Details

Design Trade for Logging, FMHosting4Hire, Over Designing

View Details

PDAnet, Client Interaction, Relookup

View Details

File References, Snipe, New Data Viewer Feature, Scripting Rehearsal

View Details

Criteria for taking on a client, Variables on a layout, How to make a real modal dialog

View Details

FMS 11 Update, Printing Portal Records, Web Searching

View Details

Object resizing , GettingAroundRemoteDisconnect, Why are indexes faster? Binary Searches!

View Details

Color Scheme Designer, Working with objects (layout mode), IWP puzzle

View Details

Designing to a range of end users, Handybackup, Web Google Map, Reply On Subscription Model

View Details

We discuss what's new in the new release of FilemakerPro!

View Details

Reqs Vs Specification Vs Design, Zero W x H windows, Colorschemer

View Details

New Favorite Font - Tahoma, GetAsBoolean, iPad

View Details

Favorite Subscripts, Marketing new add on work, Client Qualifications..

View Details

Checkboxes on same field, Calengoo review, Working Styles

View Details

Why do Spec if it takes less time to just do it in FM, Multiple script Parms, Top 10 sales volume reports

View Details

Date Function - Date ( month ; day ; year ) 2 steps forward and 1 step back to get last day of previous month, Favorite Custom Functions, Script Independence, Revisit the subscribe

View Details

Our FMST as the real added value of FM, Generating Reports, Organizing per context

View Details

Who knows better?, Let Function, FMP Ref

View Details

Using the schema 4 logic, Information moving between tables, Writing to fields from a loop in a script

View Details

Keystroke Script triggr conflict text edit or rcrds?, Reporting from multiple tables, Droid

View Details

Using the DDR to find problems, Micro Projector, Slowness because of Logo Graphic Sizes, summary fields, etc.

View Details

When using global field can nail you, Missing the data while testing, Base Tables - How to determine the base tables/ERD

View Details

Base-elements1, How much error trapping is too much, Custom Function Widget

View Details

The Let Function, Hard Coding vs. global fields / defaults, hiding and showing control objects

View Details

Arrow key question, Privilege Set Export, FMS 10 needs JAVA 6 v7 as well for Admin Console, The downside to user mod tabl view

View Details

Enter time without the colon, Fake name generator, Summary fields in the body of a layout, A + B + C = Sum (A; B; C)

View Details

Remote file icon - Launcher, Use Models and Use Cases, Summary field vs. sum function

View Details

Copy Layout, FMStarting Point, Global variable polution ($$Variable)

View Details

FileMaker 9 Admin and Java 6 v10+ = Crash, Loop exit trap, Manual Backup, A broken Foundation... Halloween Show!!!

View Details

When the Relation does not work, Hidden values in checkboxes, Design for Testing, FilemakerFree

View Details

Window Dressing, Design for multiusers with global fields, Context

View Details

Else/If Scripting OR Case Statement in set field?, How to sell an FM app?, Fun with Conditional Formatting

View Details

Basic TO to TO relation as a query/filter, Problems with Server admin app, Right Border

View Details

Get As... Text/Number, etc, When to add TOs or add a TOG, Solving differences - How do you work through the math problems?

View Details

Searching for an e-mail address? Use “name\@isp.com”, When to make the time to encapsulate, Preview and PNGs, Cheap Heavy Metal

View Details

Cartesian Join Relationship, The debugger, Macintosh - Force Quit / Relaunch Finder

View Details

AutoUpdate, Speak the customers language, Q1 Review#2

View Details

Autosequence mismatch, Manual entry of time into Time format, spaghetti to anchor buoy

View Details

Tips, tricks and fun from DEVCON 2009

View Details

Samsung Q1, Market Research, Email from NSW

View Details

1 Year anniversary! Printing subroutines which handle preview, One2One=ONE table= GREAT performance, Utility menus you need to have, Checkboxes and one value set Vs mulitple

View Details

Manual overide on a calculation field, Can’t mod field because another layout is modifying the field, Concatenated key revisit, Calc field Vs Calc Auto Enter for concat key

View Details

Getting age from current date - DOB, Keepin it clean - remove it if you are not using it., Chart making 1, SetFieldByName

View Details

Pixelmator, Security Tidbits, AVG interferes with port 80 and IWP

View Details

Transparent PNGs, Script Trigger find on single TO, Sorting subsums, Set the defaults on your file locally before you upload to server

View Details

Looping, Upgrading to version 10? Why?, Uniformity of design

View Details

Set Field By Name provide field addressing for encapsulation, How an invoice works, LanguageIndex, Data entry screens vs. print layouts

View Details

Using buttons for status info or highlighting with Cond formatting, Product Doc Menu, Table Magic view once more! Group sort display Table Magic, Layout Partitions and how they work

View Details

When to use FM canned routine and when to script?, On Timer script, Setting mulitple selected objects, 1. Description of what we’re doing with Strength as a hosted vert app

View Details

Script trigger fun 3- Cond format on “apply” btn, Drop down list Vs Popup menu.Relationship Graph... basics The relation, Using a graphic in a field for info

View Details

Script trigger - pull down menus, EscapeCharacter, What’s a key? , A time tracking system

View Details

Get PrivilegeSet, Script trigger fun 2 - arrow keys, ESS import, Use of modeless daughter windows

View Details

Manage 5, Conceptual UIs, User Mod Tableview revisit, April Fools FileMaker 11

View Details

Continuation of Table View Discussion... adding other fields, Merge Filed - Using data in labels, Script Lunch, Value pricing

View Details

What’s the difference between Exit Script and Halt Script?, Using Insert script steps... , Yellow - empty Conditional formatting, Importing within your own solution, WarehouseMaster

View Details

Turn on the Object Grids in Layout mode, Save as PDF, append to PDF, Script arrange and layouts arrange... What divisions do you use to segment you Script Manager?, Referrals from employees leaving, Smallerscripts

View Details

UserCreated, date, modified in Auto enter, Script steps cut/ copy/paste, More uses of script triggers, IS Model - Transactions, decision support, conditionalvaluelists

View Details

Script trigger traps, Magnetic card scan - credit card, dl, , Basic 1 to many design, portalsort

View Details

Repeating Fields, When should you use subscripts? , Change passwords in 10 server 9 is used... won’t work... bug, Bar Code Scanning, RelatedLine

View Details

Use a special Dev Custom menu during your development efforts, Our Day, Table view changing, Lions Tigers and bears

View Details

AutoRelatedFailure, Order of design, what do you do first, middle and last in the design process, When to use header/footer in form view

View Details

ETL, FileMaker 10 Server Backups, Old FileMaker Disks, Index and import, error mgmt

View Details

Go to related record command, relatedLine, The Green Bubble, FM server and win OSs

View Details

Design your own billing system using FileMaker, Constrain-Plus, Behavior Changes in Version 10 (gotchas), PDF’s in a container

View Details

The Replace Command, When should you use a dialog box that says “Are you sure”? and when is it overkill?, duplicateScript, Single record defaults, Script Collaboration

View Details

Using ESS/ODBC, NoExtras Do not add extras to the design, Commit, Writing find scripts, LionsTigersBears

View Details

How to close, List function, killing the Lookup2 &  V10Status Area

View Details

Coupling/Decoupling and cohesiveness, Ins and Outs of Date/Time Field formatting, Consistency in layout object placement

View Details

Troubleshooting, How to isolate a record, What do you do when it’s not Filemaker?, Dwaynes take on naming conventions.

View Details

How to price or scope a project, Setting Layout Defaults and what's Twitter?

View Details

Taborder and  conceptual design in layouts, Custom Menu starting place, CASE function, and Dwayne's reuse analysis tip.

View Details

Our special show reviewing what we have tried in the new FilemakerPro version 10! WOOHOO!!

View Details

Elipsis; Conditional script step; simplicity revisited and a bad 4D day.

View Details

LayoutNames Function; Constrain and Extend Found Set; IsEmpty and Not IsEmpty; Set Field Script Step.

View Details

We're now Filemaker Success Tips! Yeah! Filemaker Development with Vista Vs MacOS; Qutes in a Quote; Cascading Deletes.

View Details

Modeless Vs Modal Dialogs, making labels, and Ceiling and Floor functions

View Details

Backing up a Filemaker server. Where to find great stuff on the web. Building an application template so you don't start from scratch.

View Details

Andy finally plays with FMTouch, we revisit working on a live system, Lee talks about Modify Last Find and Dwayne talks about archiving layouts.

View Details

How to build a proper dialog box; handling sensitive data; Using Wildcards in doing finds and Parsing text.

View Details

A custom UnixTimeStamp function; Naming conventions; a discussion on Conditional Formatting, then Lee talks about how to put together a fake database.

View Details

Dwayne joins us to talk more about tricks in layout building; Lee talks about using the Data Viewer for object property display and we  discuss developing  design specifications.

View Details

How to do Project definition, ins and outs of Instant Web Publishing and putting all your prefs and config stuff in an encapsulated area for easy reuse.

View Details

Trick or treat? Working on a dB while it's in use, selling Filemaker development in a tough economy, the Normal Forms... ouch!

View Details

Our 60 second promo.

View Details

What to say while in front of a client when it goes all wrong, an update of our data migration project and different kinds of Q/A.

View Details

A great clip from a listener then we talk about Lookups and discuss techniques in scripting and developing scripts for reuse.

View Details

Andy and Lee get into who's fault is it when the user pushes the wrong button. Then we talk about using a digital voice recorder for capturing customer related info and using Filemaker Server during development.

View Details

Why you need to try something new outside your production project as a prototype. A tip for how to prevent a user from closing a window on a PC and also closing the application inadvertently. We also discuss real cool tips for fast layout work.

View Details

Lee talks about who is the ideal point person from the client side to work with. We talk about the differences one runs into when running a file from PC to Mac and how to avoid problems. We also take a first time discussion on the Relationship Graph.

View Details

Inheriting somebody else's work.  The value of simplicity in your application design. We also start describing our data migration project using FM to go from one SQL dB to another.

View Details

In this show we talk about contracts, the value of the Filemaker Maintenance agreement and building a runtime executable with FilemakerPro Advanced.

View Details

Andy and Lee discuss the concept of a "database" and get into how Filemaker has evolved into meeting this concept via the development of a "Separation" model with data/tables in one or more seperate files from forms and reports. They also discuss why it's a very good idea to do development using the Advanced version of FilemakerPro.

View Details

Lee and Andy talk about tips for designing your approach to user navigation within your solution. We also talk about the usefulness of the "Evaluate" function as well as using the import capability between tables within a solution.

View Details

Our first show! We talk about using a special table for design notes to get feedback from users during your solutions operation; the "Get" functions; and how to test your application while in a specific privilege setting which may not have full admin access.