hcmbrbj Posted December 6, 2009 Posted December 6, 2009 Another newbie question, please. If Field x has data entered into it by the operator, y needs to have data entered also and vice versa. How can I put a warning dialog in so if the operator enters data in x but not y they get a warning before they can proceed?
MetaSys Software Posted December 7, 2009 Posted December 7, 2009 Using OnRecordCommit script trigger, check which field has value and show warning accordingly.
hcmbrbj Posted December 7, 2009 Author Posted December 7, 2009 I'm a newbie and haven't dealt with Script Triggers. But, wouldn't OnObjectExit be more appropriate?
corn Posted December 7, 2009 Posted December 7, 2009 No, because as soon as you leave X you'll be prompted with the warning before you've had a chance to enter a value in Y.
hcmbrbj Posted December 7, 2009 Author Posted December 7, 2009 You're absolutely correct as I discovered trying it. I will have to write a script to trigger a dialog if one or the other is empty but not if both are completed, right?
comment Posted December 7, 2009 Posted December 7, 2009 If you need to ensure data integrity, use field validation first and foremost. Then you may add a script trigger to protect the user from Filemaker's annoying validation error message.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now