Super Quick Data Entry

You'll never guess what you can do with a little creative thinking and the Custom Formatting option. Oh, wait, I just told you in the title of this article - Super Quick Data Entry.

One of my MOST favorite features of FileMaker is the fact that records are created by default when entering data into a related field and no valid relationship exists. This provides a number of opportunities to do cool things, such as entering data - provided it's not a lot of related data.

When you add script triggering to a field's custom formatting option, and you rely on what FileMaker tries to be smart about, you get a powerful method for entering data in a super quick way. The best part about this whole technique is that it becomes universal to your whole solution. You can use any related field with auto-creation of related records and your one single script can handle it all.

Watch this free video to see how easily it can be done!

Comments

Very nice Technique!

If you ever see or find any other cool techniques out there please bring them to my attention.

Matt

-- Matt Petrowsky - ISO FileMaker Magazine Editor

Though unrelated to this particular subject there is a technique that I use frequently to address the problem of how to maintain precision when copying and pasting objects from one layout to another where positioning is critical. The technique is to simply create a rectangle object and place it at the very top left of your layout. Then select the object(s) that you want to copy along with this rectangle and copy them and paste them to the desired layout and then just delete the rectangle. The result will be precise placement. Very simple but very powerful especially when dealing with complex layouts.

Best regards,

Ralf

Best regards,

Ralf

Hallo Matt,
Is it possible to have the technikfile?
It seems to be one of the best techniks I have seen for Filemaker 9.
I would like to do some equal solution for myself.

Best regards,

Henryk