lunamuna Posted April 17, 2002 Posted April 17, 2002 Here's another question: I have layout with four entry fields and another field that I am using to instructions as to what data needs to be entered in each field. I've tried to set the instruction field based on the Status(CurrentFieldName) function, but it doesn't seem to work. So I'm setting them with scripts placed on the fields themselves that set the instructions field. The problem with that is that when they tab (which makes sense on a data entry screen), they circumvent the scripts/ Is there a way of setting a script on the tab? Or better yet, does anyone know how I can get Status(CurrentFieldName) to work in the instruction field definition? -Heather
Vaughan Posted April 18, 2002 Posted April 18, 2002 The instruction field need to be an unstored calculation.
lunamuna Posted April 18, 2002 Author Posted April 18, 2002 Making them an unstored calculation produces results, at least, but only the first case in my statement, and that is the only result, whether it is true or not. Does the fact that the data entry field are globals have anything to do with it? -Heather
Gogargirl Posted April 18, 2002 Posted April 18, 2002 Can't answer the question about Status(CurrentFieldName), but here is a method that will work with global input fields and with tabbing between fields (assuming you set the tab order in the logical sequence for your instructions). Use this unstored calculation for your instructions field: Case(IsEmpty(Field1),"1st instruction here", IsEmpty(Field2),"2nd instruction here", IsEmpty(Field3),"3rd instruction here", IsEmpty(Field4), "last instruction here", "") As FM returns the first true answer in the Case statement, you might want to force the user to go to the first field at the start. It won't work properly if they start in another field. When all the fields contain values, the instruction field will be empty. Of course, if your instructions change, you'll need to change the code.
Recommended Posts
This topic is 8259 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