You are viewing limited content. For full access, please sign in.

Question

Question

Forms Field Rules

asked on August 9

I have a few options, and cannot get the fields rules to work properly. I have a radio button and a drop down. 

The drop down is location, and the radio button is a type of cost. 

If the drop down is 1 of 2 options, example 376 or 377, AND the radio button i permit, i want 2 additional fields to show up. 

 

What is the best way to get this to work properly?

0 0

Answer

SELECTED ANSWER
replied on August 9 Show version history

This is tricky because you have a multi-part condition.

Essentially, you are trying to build a condition like (3 OR 4) AND C

However, Forms only supports "All" or "Any" condition groups

As a workaround, you could put the hidden fields in a section, set the section so it does not show the header.

Set one condition to show the Section when C

Set a separate condition to show the Fields when A or B

If you do this, make sure you add another hidden section after it to break it up otherwise you would hide everything that follows those two fields as well.

 

OR you could go the other way around and show them when the dropdown is not equal to the other possible values like (NOT 1,2,5,6) AND C

This option works best if you only have a few options, but it probably won't work if you're using a lookup or something.

 

I also have a third option that involves using Functions and a hidden field:

The hidden field has a function that sets the field value based on the contents of the dropdown. If it does not equal either of your choices it makes the value "Hide".

Then, your rule just looks at the Hidden field and the Radio.

 

0 0

Replies

replied on August 9

Do the fields you want to show changed based on the combination of drop-down answer and radio button answer?

 

0 0
replied on August 9

It depends on the order I choose them in. If i click on a location that is not my choice, it hides them, if i choose the correct location and permits it shows them. If i chose another location and a different radio button it is hidden, but if i click on permits it appears. 

0 0
SELECTED ANSWER
replied on August 9 Show version history

This is tricky because you have a multi-part condition.

Essentially, you are trying to build a condition like (3 OR 4) AND C

However, Forms only supports "All" or "Any" condition groups

As a workaround, you could put the hidden fields in a section, set the section so it does not show the header.

Set one condition to show the Section when C

Set a separate condition to show the Fields when A or B

If you do this, make sure you add another hidden section after it to break it up otherwise you would hide everything that follows those two fields as well.

 

OR you could go the other way around and show them when the dropdown is not equal to the other possible values like (NOT 1,2,5,6) AND C

This option works best if you only have a few options, but it probably won't work if you're using a lookup or something.

 

I also have a third option that involves using Functions and a hidden field:

The hidden field has a function that sets the field value based on the contents of the dropdown. If it does not equal either of your choices it makes the value "Hide".

Then, your rule just looks at the Hidden field and the Radio.

 

0 0
replied on August 10

OH MY GOODNESS. That is brilliant and works perfectly. 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.