Jump to content
Sign in to follow this  

Launch script while a user is entering data?

Recommended Posts

I am relatively new to Filemaker so I'm hoping to get some advice from the experts.

I am working on a Filemaker system that creates records when items get moved from one location to another. There is no location data, just records that show what quantities have been moved. The system does child to parent lookups but not parent to child. In other words, you can easily see where something came from, but when you are looking at an old record you have no idea if the item you moved is still where you put it. That complicates any kind of Find where you want to know what is in a location.

The problem: We want a report on what is in one specific location.

My solution: Flag a record when something goes in. When it comes out look up the parent record and unflag it. Then you just have to search for the flags.

When a user is creating a new record I need to check a field for the specific location, go to the parent record, remove a flag variable, and return to the current record. I could do it with a button, but then I am relying on users to push the dumb button. If they don't (and I can't make them) things will get messed up in a hurry.

Is there any way to get a script started using field validation, tab stops to an invisible button, switching between fields, Apple Events, or something? I would run the check script every time the user pushed the tab key if necessary. I am currently using Filemaker 5.5, but I would happily run out and buy Filemaker Unlimited if it would help.

Thanks for caring enough to read this far. Sorry for the long post, but how can anyone help if they don't understand the problem?


Share this post

Link to post
Share on other sites

First let me say that I don't think this is a good way to keep track. Inventory control systems, for example, don't change quantities on a Inventory Item records (similar to your flag). Instead the post a transaction to a file drawing or stocking a quantity. Similarly, you would post a move transaction to indicate where an item was moved to. This way there is always a "paper" trail and you can establish where an item is by the "moves" it has made. Otherwise, using the inventory example, the incorrect modification of a number forces someone to go look at how many items physically exist. With a transactions file, all you have to do is add up all the transactions to get the current count (or look at the last tranaction to see the current location. The Library system doesn't check out books by checking and unchecking a box on the catalog card, they also post a transaction for each checkout and return.

As to your second question. A plug-in such as Troi Activator will trigger a script upon exiting a field (www.troi.com).


Share this post

Link to post
Share on other sites

In addition to your second question, you may also look at oAzium Events Plugin


You can trigger your scripts to run upon exiting a field, creating new records or scheduling your scripts to run a specified date/time.

Share this post

Link to post
Share on other sites

Thanks for responding. No, it definitely isn't a good solution. The only good solution would be to build a real inventory control system, but that is not going to happen in a timely manner. I'm just going to have to cludge something together.



Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By Tumma K
      Hello, All!

      I am an aspiring developer for Filemaker. The company I work with is stuck in the past working off of Filemaker Pro 4.1

      I was given the task of bringing us up to Filemaker Pro/Server 13. So far my conversion prototypes are successful but we recently had a layout issue that can only be fixed in versions 3-6 (as the file is an .fp3) I work off of a macbook while our network is all Windows 7. In order for me to repair the layouts without tampering our active database, I decided the best option is to repair a copy of our solutions off the network. Unfortunately, when I go to download the trial version of Filemaker Pro 6 off of the respected website, the file is corrupt! I've tried multiple times, with different extraction apps and in different directories.

      My question is;

      Does anyone know a place where I could obtain version 6 (or better yet, 4.0) for an OSX computer? I've looked everywhere!
      Thank you for your time,
      Tumma K.
    • By MrEddByrnes
      I'm hoping my question can have a happy ending. In the mid-90's, I purchased Filemaker 3. When Filemaker 5.5 Pro was released, I bought the update CD, which requires the user to either have FM 3 installed or to have the installation CD for FM 3. I've used it all these years, most recently with Windows XP Pro, and it has worked just fine. The databases I began with were long ago converted to FM Pro 5.5 databases.
      I'm still using FM Pro 5.5 on a laptop with WinXP Pro, but in 2013, I purchased a PC with Windows 8. I haven't been able to install FM 3 on it, therefore can't install FM Pro 5.5. I am retired and rarely use Filemaker, but I have a few Filemaker databases I'd like to add to my Win 8 machine. I don't feel it's worth upgrading FM for the sake of using a couple of databases.
      Has anyone else run into this situation and/or have a (possible) solution? Is there perhaps any other software that can read FM 5.5 databases? Thanks in advance for your help.
    • By bmill
      I am using a custom filemaker solution for medical office billing written with fp5 running on a mac with snow leopard. In addition, I have a patient management db (which I wrote) that is linked through pt. ID number to the billing program allowing transfer of some demographic information (name, DOB, etc).
      Other than being limited by hardware restrictions, the billing program serves our needs for now and upgrading to fp12 will take some time (and money).  In the meantime, I am upgrading my pt. management program to fp13 and would like to move new patient demographic information from the billing program ( fp5 running on snow leopard through Parallels) and the new pt management program ( fp13 running on OS X 10.9) on the same mac.   
      Ideally, demographic information would be entered once into fp5 and then a scipt would make the data available for fp13.
      Any ideas on how to make this work?
    • By randyinla
      Hi, can anyone tell me why my on-line database might have stopped allowing me to delete records?  All of my access privileges and passwords are correct.
    • By randyinla
      Hi, I still use filemaker 5.5 and am very happy with it and don't want to upgrade.  Does anyone still host filemaker 5.5?  Thanks!
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.