Welcome to DW Data Concepts FMP Tips Page


 
All files have been compressed into a single Self-Extracting Archive.
For Macintosh users, you need Stuffit Expander.

Gotta a tip? Gotta an idea for a tip. Let know.

CF Calendar - (16K)  Download  - Build an optimized calendar using a custom function. By ISO Productions and Don Wieland of DW Data Concepts.

Archive
- (16K)  MAC  WIN  - Ever wanted to ARCHIVE your multi-file solutions. Demonstrates how to archive and restore parent and child records. By Don Wieland of DW Data Concepts.

Dynamic Column Borders - (16K)  MAC  WIN  - This file demonstrates how to get borders around sliding fields to resize correctly.   By Don Wieland of DW Data Concepts.

Abacus - (16K)  MAC  WIN  - Created this little file for my daughter to practice math. Check it out.   By Don Wieland of DW Data Concepts.

Long String Pick - (16K)  MAC  WIN  - Sometimes you just can't display long text strings in a value list for selecting. Here is an alternate approach.   By Don Wieland of DW Data Concepts.

Shuffle Students - (16K)  MAC  WIN  - This sample solution shows how to pair students together through various phases without repeats. Worth a looksy.  By Don Wieland of DW Data Concepts.

Quick Books Data Ranges - (16K)  MAC  WIN  - This should cover your date range needs.   By Don Wieland of DW Data Concepts.

Summarize Time - (16K)  MAC  WIN  - This was a mock file I did for someone on the Blueworld mailing list.  It might be useful to someone.   By Don Wieland of DW Data Concepts.

Document Database
- (16K)  MAC  WIN  - This is a handy file to do a quick documentation of your multi-file solutions.   By Don Wieland of DW Data Concepts.

One Line Value List Display - (16K)  MAC  WIN  - Every wanted to parse your selected value list choices to one line? (ex. - red, blue, yellow, and orange.) Check this tip out.   By Don Wieland of DW Data Concepts.

Value List Control - (16K)  MAC  WIN  - Would you like to have more control/protection in editing value lists? Here is a TIP that show one option.   By Don Wieland of DW Data Concepts.

Price Break Look-up - (16K)  MAC  WIN  - This sample solution shows a handy way to incorporate PRICE BREAKS in your invoice system.   By Don Wieland of DW Data Concepts.

OMIT Multiple (by field value) - (16K)  MAC  WIN  - Is the OMIT Multiple script step a little limited? This tip shows how to OMIT Multile records by a field value.   By Don Wieland of DW Data Concepts.

Multi-Items - (16K)  MAC  WIN  - A technique to cut down the amount of JOIN (items) files in your solution.  Interesting PRINTING techniques.   By Don Wieland of DW Data Concepts.

FMP to Outlook Express - BULK EMAIL - (4K)  MAC  A way to generate one email (with multiple recipients - To, cc, bcc) from FMP to Outlook Express (MAC only - Applescript Required).   By Don Wieland of DW Data Concepts and John Delacour.

FMP to Outlook Express - (4K)  MAC  A way to generate emails (with an attachment) from FMP to Outlook Express (MAC only - Applescript Required).   By Don Wieland of DW Data Concepts and Steve Friesen.

MOD KEYS - (4K)  MAC  WIN  -  MOD KEYS tricks.

RECORD LOCK - (4K)  MAC  WIN  -  Record locking technique using the VISIBILTY method (invalid portal) By Don Wieland of DW Data Concepts.

EASY Date Range - (4K)  MAC  WIN  -  A neat way to make it very easy for your USERS to specify Date Ranges.   By Don Wieland of DW Data Concepts and Bart Bartholomay of Metro Technologies.

NAV TIPS - (11K)  MAC  WIN  -  Establish TIGHT file navigation in your solutions.  By Don Wieland of DW Data Concepts.

Compound Interest - (11K)  MAC  WIN  -  This TIP shows a technique of compounding interest in an invoice example.  By Don Wieland of DW Data Concepts.

Distance - (4K)  MAC  WIN  -  Calculate the distance between TWO points using longitute and latitute coordinates.  By Don Wieland of DW Data Concepts.

Find Birthdays - (10K)  MAC  WIN  -  Find Birthdays for a particular month in a SNAP using FMP relational capabilities.  By Don Wieland of DW Data Concepts.

EMAIL FUN with FMP4 - (11K)  MAC  WIN  -  A little email solution I zapped up which demonstrates BULK and Custom Emailing techniques from within FMP4.  By Don Wieland of DW Data Concepts.

OPEN SESAME - File opening/closing techniques - (18K)  MAC  WIN  -  Shows a technique to open and close a multi-file solution quickly.  Window sizing techniques, also. By Don Wieland of DW Data Concepts.

Range MADNESS - (148K)  MAC  WIN  -  Use relationships to display a variety of RANGES of dates in PORTALS.  By Don Wieland of DW Data Concepts.

Survey - (8K)  MAC  WIN  -  An interesting SURVEY file that is worth a look.  By Don Wieland of DW Data Concepts.

MANY to MANY - (8K)  MAC  WIN  -  Demonstrates how to setup a Many to Many relationship WITHOUT a join file. Multi-Line KEY field techniques.  By Don Wieland of DW Data Concepts.

Time Difference - (4K)  MAC  WIN  -  Calculate TOTAL TIME from a START and END date and time.  By Don Wieland of DW Data Concepts.

Trigger - (6K)  MAC  WIN  -  Field formatting using a TRIGGER FIELD.  By Don Wieland of DW Data Concepts.

Across4 - (82K)  MAC  WIN  -  This TIP shows how to set up your database so you can view records 4 across in BROWSE mode.  By Don Wieland of DW Data Concepts.

Exclude Current Record - (4K)  MAC  WIN  -  This TIP shows how to establish a procedure that will exclude the current record in a SELF JOIN portal.  By Don Wieland of DW Data Concepts.

Mark Row - (5K)  MAC  WIN  -  Shows how to MARK the current record in a portal.  By Don Wieland of DW Data Concepts.

Navigate - (13K)  MAC  WIN  -  Dynamic File Navigation by a POP-UP Menu/List.  The MAC and PC files are different.  For cross platform differences, download BOTH.  By Don Wieland of DW Data Concepts.

Dynamic Checkboxes - (4K)  MAC  WIN  -  Fun with Checkboxes.  By Don Wieland of DW Data Concepts.

AlphaJump - (6K)  MAC  WIN  -  This TIP shows how to establish an ALPHA Menu Pallette to navigate to the first record of a choosen letter.  Very useful in those LONG columnar layout views. By Don Wieland of DW Data Concepts.

Alternate Row Color - (5K)  MAC  WIN  -  This TIP demonstrates how to display every other row in a list view an alternate color.  A necessity for you GUI funatics. By Don Wieland of DW Data Concepts.

Animate FMP - (14K)  MAC  WIN  -  Is it possible to animate in FMP?  Well, with a little work it is.  Since, FMP redraws from bottom to top, you can manipuate FMP to animate by stacking objects.  Check out this file, if you don't believe it.  By Don Wieland of DW Data Concepts.

Color Calc - (5K)  MAC  WIN  -  Ever wanted to change a value of a field and have the fields background change to another color?  Check this out.  By Don Wieland of DW Data Concepts.

Compile Invoice - (20K)  MAC  WIN  -  Here is a handy sample solution that demostrates how to set up an invoice.  It includes a technique to set batch products to an invoice.  Worth a look.  By Don Wieland of DW Data Concepts.

Find - (5K)  MAC  WIN  -  A simple FIND procedure using GLOBALS.  Got some nice ERROR TRAPPING techniques.  By Don Wieland of DW Data Concepts.

Hierarchical Find - (11K)  MAC  WIN  -  This technique demonstrates how to set fields using a Hierarchical Find scheme.  This technique is for those who are trying to keep a tight rein of data the way data is entered in a database.  By Don Wieland of DW Data Concepts.

Inventory - (18K)  MAC  WIN  -  I put this together to demonstate how to deplete stock in inventory.  If you are planning to develop an inventory solution, download this solution for a good head start.  By Don Wieland of DW Data Concepts.

Irregular Button - (40K)  MAC  WIN  -  Want to get rid of the PESKY grey box that surrounds those buttons that are an odd shape?  Download this one to find out how.  By Don Wieland of DW Data Concepts.

Mega Buttons - (11K)  MAC  WIN  -  Fun with Container fields.  This tip demonstrates how to get a selected button to highlight.  Check it out!  By Don Wieland of DW Data Concepts.

Navigational Lookup - (46K)  MAC  WIN  -  Shows a great technique on how to replace those HUGE Value Lists.  By Don Wieland of DW Data Concepts.

Random Passwords - (31K)  MAC  WIN  -  A while back, Chris Moyer put together a file that demonstrated how to set up a password (registration) scheme based on the amount of records created, by time, and by days.  I took his technique and added a RANDOM password element to it.  Interesting file!  By Chris Moyer and Don Wieland.

Horizontal Portal Example - (10K)  MAC  WIN  -  Have you ever wanted to display a portal horizontally?  Check out this little workaround to simulate this effect.  By Don Wieland of DW Data Concepts.

Shuffle Rows - (5K)  MAC  WIN  -  An example of how to shuffle records to different positions in a list view?  Very handy!!!  By Don Wieland of DW Data Concepts.

Update Calcs - (25K)  MAC  WIN  -  Have you ever run into a situation where a calculation field did not update because it was based on a relationship?  It may be possible to wake up those lazy calcs with this technique.  By Don Wieland of DW Data Concepts.

Custom Username/Password Example - (23K)  MAC  WIN  -  This sample solution shows how to set up your own custom username/password system.  This technique is useful in a variety of situations.  Cool Stuff!  By Don Wieland of DW Data Concepts.

Hierarchical Value Lists - (41K)  MAC  WIN  -  This TIP demostrates a technique that allows you to select a value in one field and have a conditional value list in a second field based on the first field's choice.  A little work, but definitely worth the effort.  By Don Wieland of DW Data Concepts.

X Quotes - (3K)  MAC  WIN  -  This tip shows how to get rid of quotes in a field.  Not so straight forward.  FMP gets quirky if you use smart quotes!