Skip a field based on previous field answer

[robshortii]

Hi,

Here is my question.

I have fields with questions that the answer is yes or no. I want to skip the next field if the answer is no.

Can someone share there knowledge with me and help with this question. Thanks in advance.

Rob

[Ender]

I want to skip the next field if the answer is no.

Do you mean skip in the tab order, or something else?

[robshortii]

say there is three fields...1. was person a vet? yes or no 2. if yes, what branch? (branch options) 3. Persons Occupation.

I want to skip field 2 if field 1 is no. So after selecting no from field 1 i want to go to field 3.

Rob

[Ender]

Generally, the display of fields on a layout are not conditional. They are either there or not. Often scripts are used to branch to different layouts based on what's going on in the record, but this is when a user completes data entry on a layout and hits a button to go to another section (or the next step in a process.)

There is a handy visiblity trick that may be more what you are looking for. It lets you show or hide a field or group of fields based on values in the record. Do a search in the Resources section of databasepros.com for a couple good demos of this technique.

[Lee Smith]

Hi Ender,

To add to what you said, there are a lot of the same files also available at www.fmfiles.com. For more Visibility, click Here

HTH

Lee

[robshortii]

Thanks for the info but that is not what i want to do.

I need to just skip a field based on a "no" in the previous field. i probably need a script.

The visibility trick does not work because in order to have something appear the field need to be filled. if the answer to the question is yes or no then the field will always appear.

If someone knows how to accomplish what is mentioned please respond.

[transpower]

You could get Waves' Events to run a script when you exit your first field; if the answer is "No" you would then execute a script (with the step Go to Field 3), thereby skipping field 2.

[stanley]

Rob:

If you set the "Yes/No" field as radio buttons, you can overlay an invisible button over the "No" radio button. Have this invisible button trigger this script:

Set Field [your "is he a vet" field; "No"]

Go to Field [the field you want to go to]

-Stanley

[Ender]

I need to just skip a field based on a "no" in the previous field...

The visibility trick does not work because in order to have something appear the field need to be filled. if the answer to the question is yes or no then the field will always appear.

So change the relationship so that it only matches on "yes".