Solved

Jumping down to validated field

Posted on 2009-04-06
2
189 Views
Last Modified: 2013-12-18
Have a form we use for ordering hardware. The main body of the form is setup in a 2 column table. On the most recent version we added a Yes/No question that they are required to respond to in order to proceed. Nothing out of the ordinary here.

What I am having an issue with is when I test the form, I enter a name in the first row, when I tab to move to the second field I get prompted with the validation ressponse. Strange thing is this validated field is 6 rows into the table yet it is going right there. I get the Notes error - did not apss validation after the validation response below.

I have tried numbering the tab sequence, but it is still going right to this question when I tab out of field 1. I have confirmed it is in the Input Validation section for this field, but cannot figure out why it is jumping right there out of sequence.

Any ideas?
@If(terms_signoff = "" ; @Failure ("You must respond to the question regarding the signature page and acceptance.") ; @Success)

Open in new window

0
Comment
Question by:jforget1
2 Comments
 
LVL 22

Accepted Solution

by:
Bill-Hanson earned 500 total points
ID: 24079975
It would be very hard to say why the validation formula is firing out of order without seeing the form in the designer.  Validation formulas usually execute from the top to the bottom of the form.

On another topic, are you sure that you want the validation formulas executing every time the form is refreshed?  I normally only allow mine to run when the document is being saved.  If you want to check your fields only when the form is being saved, use the @IsDocBeingSaved function...

    @If(
      !@IsDocBeingSaved; @Success;
        terms_signoff = "" ; @Failure ("You must respond to the question regarding the signature page and acceptance.");
        @Success);
0
 

Author Closing Comment

by:jforget1
ID: 31567150
Did not know of that method of validation. That will be very helpful.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now