Jump to content

Scripting Problem


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

Recommended Posts

I have stumbled across a problem.

I need to "lock" the records if they are marked complete. I created 2 separate layouts (1 viewing (Lock), 1 editing(Entering)). Here is my script:

Enter Find Mode (Pause)

Go to Field (Substrate Number)

Perform Find

If (Completed = "X")

Go to Layout(Lock)

If (IsEmpty(Completed)

Go to Layout (Entering)

End If

End If

"Completed" is the field that the user checks with an "X" if the record is completed with it's run. If there is no "X" in the box I need the record to go back to the Entering layout because they will need to add to this record.

I have this script attached to the "find" button on the layout. It is finding the appropriate set of records but if the complete is not marked it is leaving the record in the Lock layout and not kicking it into the Entering layout.

Link to comment
Share on other sites

Move the first "End If" up two lines as shown here:

Enter Find Mode (Pause)

Go to Field (Substrate Number)

Perform Find

If (Completed = "X")

Go to Layout(Lock)

End If

If (IsEmpty(Completed)

Go to Layout (Entering)

End If

Better yet:

Enter Find Mode (Pause)

Go to Field (Substrate Number)

Perform Find

If (Completed = "X")

Go to Layout(Lock)

Else

Go to Layout (Entering)

End If

Link to comment
Share on other sites

Thank you for your reply on the problem script. I entered the script that you suggested and it continues to pick the correct found set, but for example, I have 5 records in a found set and 4 are completed and 1 is not. It shows all 5 records in the "lock" layout, instead of 4 in the "lock" layout and 1 in the "enter" layout. It seems that the layout is "set" by what condition(completed/uncompleted) the first record is in the found set.

Thank You

Link to comment
Share on other sites

Finding the records and going to the layout as the previous script suggested is good for the first record in the found set, but as I was suggesting before you still need to control navigation through the found set. Best method I have found is to hide and lock the status area and create your own navigation buttons for Go to Previous, Go to Next, Go to First, and Go to Last. Example below.

Go to Record Next

If (Completed = "X")

Go to Layout(Lock)

Else

Go to Layout (Entering)

End If

Link to comment
Share on other sites

This topic is 7781 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
 Share

×
×
  • Create New...

Important Information

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