Shari Posted October 16, 2003 Posted October 16, 2003 I have a value list of class dates. I also have a validation field that calculates if the date is prior to today's date to send a message. The field is blank otherwise. The problem is when I am in the file and want to do other activities, the message appears. I do not want the message to appear until I enter data into the date field. How can I stop the message from appearing when I click on other options? Thanks, Shari
-Queue- Posted October 16, 2003 Posted October 16, 2003 In the validation calculation, check the 'validate only if field has been modified' box.
Shari Posted October 20, 2003 Author Posted October 20, 2003 If I check that box, then the error message does not display if I choose an earlier date. Which is the reason for the message.
Ugo DI LUCA Posted October 20, 2003 Posted October 20, 2003 Without knowing the calc you used in this validation, it would be difficult to know what's happening. Date>Status(CurrentDate) should work, with or without the box unchecked. But is it a date field or a text field ?
Shari Posted October 21, 2003 Author Posted October 21, 2003 I changed the calculationto the one you listed, but I am still getting the pop up when I don't want it. I changed from a text to a date and back again, it didn't seem to make a difference.
Ugo DI LUCA Posted October 21, 2003 Posted October 21, 2003 So I've double checked it, and the formula should work. How are your dates entered in this list. Related ? How many digits ? There must be something obvious here.
Shari Posted October 21, 2003 Author Posted October 21, 2003 The dates are from a value list from a related file. The format is month/day/4 digit year. The field is empty until a date is picked from the list. This is the problem. If anything in the file is clicked the message appears before you can get to the field.
Ugo DI LUCA Posted October 21, 2003 Posted October 21, 2003 Something is wrong dor sure Shari ! See attachment. You may need to save as clone because of my French settings, then enter some dates in Sharidate.fp5 and select the datefield in the other file. ForShari.zip
Shari Posted October 27, 2003 Author Posted October 27, 2003 I tried your suggestion and I must be doing something wrong for I cannot get the pop up to stop.
Recommended Posts
This topic is 8041 days old. Please don't post here. Open a new topic instead.
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