Jump to content
Sign in to follow this  
abomb

Run script by window closing without button?

Recommended Posts

Hello everyone,

Is there a way to run a script by closing the active window with the "x" box on top right of window? I created a button to Validate my record but I don't want people to be able to just hit the "x" and not run the script.

Also, does any one have an example or link on how to auto create a record with a serial number, but if record is not "saved", delete that record and reset the serial pattern. My serial numbers get turned into a alpha code that represents an important inventory marker for us.

Thanks in advance to any help.

Share this post


Link to post
Share on other sites

1) Yes, but you need to be able to create custom menus, a feature only available in the Developer version.

2) I would recommend having two serial numbers. One would be the auto enter used by Filemaker to relate records. Users never need see that number. The other would be the one that meets your business rules.

That second number can be serial without interuption based on a couple methods. You could script new record creation, in the script you can grab the last record's id number and add one to that.

Another way would be via a relationship. Create a Cartesian self-join and for Number have it auto enter Max(SelfJoin::Number) +1.

Share this post


Link to post
Share on other sites

Thanks David,

I'm going to try some of those techniques. Sounds easy enough. Will repost with any new questions.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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