Solved

Jumping down to validated field

Posted on 2009-04-06
2
190 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
A short film showing how OnPage and Connectwise integration works.

919 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

20 Experts available now in Live!

Get 1:1 Help Now