Adding Fields On The Fly While Writing A FileMaker Script

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

In most cases, you will have all the fields you need defined before you begin to write your script. However, you don't have to leave ScriptMaker if the field you want to use doesn't exist in the primary file. I do this all the time with one of my favorite script steps (Set Field).

Here you can see that we have added the Set Field script step to a script. In the menu on top of the field pick list, we can see the table we were in when we were looking for a field to pick. We can see the other related tables to pick from and when we do, we will see the fields for that table. At the bottom of the list, you can see the define fields option. When that is picked, we get the standard define database dialog box to create a new field on the fly. In fact, we can even create a new table or edit the relationship graph on the fly as well!
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2007 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.