November 2, 200619 yr 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.
November 2, 200619 yr 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.
November 2, 200619 yr Author 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?
November 2, 200619 yr Yes, much like most web forms, the database is not updated until the validation logic is passed prior.
Create an account or sign in to comment