|
|
| 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). |
|
|
|
|
| Thanks
to our generous contributor - John Mark Osborne. The tips below marked
with an asterisk have been contributed by him. Thanks John! |
|
|
| *AGE.FP3 - This age calculation returns the years,
months and days of a person based on a date of birth. The calculation
is divided into three parts separated by returns representing years,
months and days. |
|
|
| *CHARTS.FP3 - Have you ever wanted to create
a bar chart in FileMaker Pro? Here's a method for charting with only
FileMaker features. And, the great thing is it doesn't use any graphics.
|
|
|
| *COLOR.FP3 - This is a simple yet powerful tip.
Just change the Category popup menu and watch the text in the Text
field change colors. |
|
|
| *DUPS.FP3 - There are plenty of techniques for
deleting duplicates after they have been entered. But, wouldn't you
rather prevent them from ever getting entered? This file demonstrates
how to bring up a warning message when a duplicate record is entered. |
|
|
| *FILTER.FP3 - The file demonstrates several techniques
for filtering fields. In other words, data entry is formatted to display
in a defined format regardless of how the user enters the data. |
|
|
| *HIDE.FP3 - This file demonstrates how to hide
field information at a record level. In other words, users can only
see fields from the records they created. |
|
|
| *PAGE.FP3 - There is no feature in FileMaker
Pro to display the total number of pages in a report (e.g. page 3
of 15). Fortunately, there is an easy workaround with a script. |
|
|
| *TIME.FP3 - You can figure out the elapsed time
very easily by subtracting two time fields. Unfortunately, if the
time spans two or more days, the simple formula doesn't work anymore.
This solution figures out the elapsed time over multiple days. |
|
|
| *VISIBLE.FP3 - There are so many uses for this
technique that this example hardly does it justice. This solution
works with buttons, fields or any object you can fit into a one line
portal row. |
|
|
| *WORK.FP3 - Here are two calculations that calculate
work days (days other than weekends). The first calculation determines
the number of work days between two dates. The second formula adds
work days onto a date. |
|
|
