Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 8259 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

The instruction field need to be an unstored calculation.

Posted

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

Posted

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.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.