|
|
| This
is a new tip from John Mark Osborne of Database Pros. |
|
|
| EXTRACT.FP3
- Here is a quick and easy way to extract email addresses from a text
field. There is one method using a calculation and another method
using a script. |
|
|
|
|
| This
is a tip donated by a friend and Technique-A-Week subscriber. Thanks
Geertrui. |
|
|
| Define
New Sort Order - Here is a cool little technique for defining
a new sort order in a portal by simply clearing the current sort order
and clicking on each portal row in the order you wish the records
to appear. |
|
|
|
|
| Here
are two tips contributed by the folks at layoutmode.com.
Thanks! |
|
|
| Change
Color - Here is a cool way of letting users define their own colors
to an interface and change them on the fly, whether backgrounds, tabs,
or buttons. You can either have the option set up as a user preference
or set it as a developer preference for a starter template. |
|
|
| Web
Palette - This is the web-palette introduced in FileMaker Pro
5.x. If you are developing in an older version of FileMaker Pro you
can still use these colors. You can paste a graphic of your choice
into a container field, or you can view the HTML color code for that
specific color, or you can copy a color from the palette and paste
it into your solution. |
|
|
|
|
| This
is the latest tip contributed by John Mark Osborne of Database Pros. |
|
|
| Parse2.fp3
- Here is a great tip file that demonstrates how to parse an address
field into separate fields using the Return character as a delimiter.
Learn how powerful the Position, Middle, and PatternCount functions
can be. |
|
|
|
|
| The
next four tips were contributed by Florian Soenens - Please email
him here
if you would like to access layout mode with these tips, or visit
his website here. |
|
|
| Quick
Find - This file provides an example of "hot-typing," though you
must still tab out of the field to activate the script. |
|
|
| Trash
Data - Here is an example of how to simulate moving records to
the trash. It even includes an "empty trash" function. |
|
|
| Bar
Graphs - This tip can show you how to create a bar graph that
uses the progress bars typical of your Mac, rather than one that uses
the normal pipe token loaded one after the other. |
|
|
| Back
Color - Here is an example of how you can change the background
color on a layout using a container field and a global color field. |
|
|
|
|
| Phone
Tip.FP5 - Here is a wonderful calculation that you can use in
your solution to format phone numbers with ease (FMP 5). All the details
are here. Thanks to Bill Moseid
for the contribution! |
|
|
| Toy
Email Solution - Here is a quick and effective way to send an
email from FileMaker by using AppleScript rather than a plugin. It
includes the option to send the message immediately or send it later. |
|
|
|
|
| This
tip below has been offered by John Mark Osborne - don't forget to
visit his site and thank him! (http://www.databasepros.com) |
|
|
| Tabbed
Interface - Tabbed interfaces, an important part of FileMaker
Pro interface design, allow a user to become familiar with an interface
since only the view within the layout appears to change. This technique
focuses on how to easily create great looking tabs. |
|
|
|
|
| The
four tips below have been donated by Parker Bennett at Mogulsoft -
Database Solutions for the Entertainment Industry. Thanks! http://www.mogulsoft.com/fmpro |
|
|
| Clip
Save - This useful tip shows you how to store and retrieve the
contents of the clipboard when using scripts that require copying
and pasting. |
|
|
| End
Loop - This simple but very effective tip demonstrates a closing
script that won't allow the file to close until specific conditions
have been met. |
|
|
| Low
Score - Here's a quick way to isolate the top 10 numbers from
a list of recently entered numbers using both the Go To Related Records
script step, and a simpler Find. |
|
|
| Title
Jump - This cool tip shows you how to scroll to, or isolate, records
beginning with a specified letter in a list of alphabetized titles. |
|
|
|
|
| The
next four tips were contributed by Don Wieland of DW Data Concepts
- Thank you Don! |
|
|
| ModKeys.FP3
- Here are a few cool tricks with Modifier Keys - did you know you
could use these with FileMaker Pro? |
|
|
| Multiple
Omit - This tip shows you how to omit multiple records by a field
value. |
|
|
| OE
Email.FP3 - Here is one way to generate emails (with an attachment!)
and send them from FMP to Outlook Express 4.5 or above - requires
AppleScript. |
|
|
| Record
Lock - Here is a simple but very effective record locking technique
using the visibility method (invalid portal). |
|
|
