Is there a way to make FM run a script on/before commit?

[ChuckL]

I want to run some checks on a record when it's ready to be committed or before going on to input another record. That is, after the operator has input data into the record, I want to run a script to do checks on the data to make sure it's valid. (If a field contains "a" then I need to do checka, if the field contains "b" then I need to do checkb, etc. I've written a script that performs the checks I want, but if the operator doesn't click my "commit" button, the record gets committed and no checks are performed, and she can go on to input the next record. I want to guarantee that each record goes thru this check.

All suggestions appreciated. Thanks.

[mr_vodka]

I always use global fields on entry forms for my end users. Then I do my validation logic and only when all of it has been satisfied, do I script it to create and pass the data into a new record.

[ChuckL]

Hmmm.. you mean you have them input into a "dummy" form, then when you're satisfied the data is valid you transfer it into the actual database?

[mr_vodka]

Yes, much like most web forms, the database is not updated until the validation logic is passed prior.