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

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

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

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

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

Window Dressing, Design for multiusers with global fields, Context

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

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

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

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

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

AutoUpdate, Speak the customers language, Q1 Review#2

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

Tips, tricks and fun from DEVCON 2009

Samsung Q1, Market Research, Email from NSW

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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.

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

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.

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

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.

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.

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.

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.

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

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.

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.

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.