October 16, 200322 yr 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
October 16, 200322 yr In the validation calculation, check the 'validate only if field has been modified' box.
October 20, 200322 yr Author 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.
October 20, 200322 yr 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 ?
October 21, 200322 yr Author 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.
October 21, 200322 yr 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.
October 21, 200322 yr Author 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.
October 21, 200322 yr 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
October 27, 200322 yr Author I tried your suggestion and I must be doing something wrong for I cannot get the pop up to stop.
Create an account or sign in to comment