January 29, 200520 yr 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
January 29, 200520 yr I want to skip the next field if the answer is no. Do you mean skip in the tab order, or something else?
January 29, 200520 yr Author 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
January 29, 200520 yr 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.
January 29, 200520 yr 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
January 29, 200520 yr Author 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.
January 29, 200520 yr 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.
January 29, 200520 yr 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
January 29, 200520 yr 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".
Create an account or sign in to comment