Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.
Juggernaut

Skip a field based on previous field answer

Featured Replies

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

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

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

  • 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

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.

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

cool.gif

  • 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.

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.

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

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

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.