Conditional Formatting based on a Multiple Select List

S

SClCommish

Hi,

I've got a multiselect list box that's populated from a Sharepoint list. I
want to display certain sections containing questions, but only if certain
list box items are selected. How do I create the conditional formatting based
on the multi-select list box to show/hide the additional sections based on
list selections?
 
M

Mark

Hi,

I've got a multiselect list box that's populated from a Sharepoint list. I
want to display certain sections containing questions, but only if certain
list box items are selected. How do I create the conditional formatting based
on the multi-select list box to show/hide the additional sections based on
list selections?

Have not worked with that specific example, but I can suggest maybe
using a radio button group rather than the multiselect list box?
Might be easier to input conditional statements into the radio buttons.
 
S

S.Y.M. Wong-A-Ton

Hi,

I'm assuming that you're using the multi-select list box that comes with
InfoPath and haven't created your own? If this is the case, you can use an
expression in the conditional format dialog box that filters on the value of
an item and then counts the amount of nodes that are returned. For example,
something like:

count(../my:group1/my:field1[. = "A"]) != 1

where "A" is the value of an item in the multi-select list box, my:field1 is
one of the items in the multi-select list box, and my:group1 is the group
node for the multi-select list box. This condition would go on the section
that you want to hide when the selected value in the multi-select list box is
not equal to "A".

---
S.Y.M. Wong-A-Ton
http://www.bizsupportonline.net (100+ InfoPath articles, tutorials, and
solutions)
http://www.bizsupportonline.net/blog/ (InfoPath Solutions Blog)
http://www.bizsupportonline.net/infopath2007/videos/ (InfoPath 2007 video
tutorials)
 
S

S.Y.M. Wong-A-Ton

If anybody else is looking to do the same thing, I've created a video
tutorial that shows the steps to get this done (see
http://www.bizsupportonline.net/blo...ox-conditional-formatting-show-hide-sections/).
---
S.Y.M. Wong-A-Ton
http://www.bizsupportonline.net (100+ InfoPath articles, tutorials, and
solutions)


S.Y.M. Wong-A-Ton said:
Hi,

I'm assuming that you're using the multi-select list box that comes with
InfoPath and haven't created your own? If this is the case, you can use an
expression in the conditional format dialog box that filters on the value of
an item and then counts the amount of nodes that are returned. For example,
something like:

count(../my:group1/my:field1[. = "A"]) != 1

where "A" is the value of an item in the multi-select list box, my:field1 is
one of the items in the multi-select list box, and my:group1 is the group
node for the multi-select list box. This condition would go on the section
that you want to hide when the selected value in the multi-select list box is
not equal to "A".

---
S.Y.M. Wong-A-Ton
http://www.bizsupportonline.net (100+ InfoPath articles, tutorials, and
solutions)
http://www.bizsupportonline.net/blog/ (InfoPath Solutions Blog)
http://www.bizsupportonline.net/infopath2007/videos/ (InfoPath 2007 video
tutorials)


SClCommish said:
Hi,

I've got a multiselect list box that's populated from a Sharepoint list. I
want to display certain sections containing questions, but only if certain
list box items are selected. How do I create the conditional formatting based
on the multi-select list box to show/hide the additional sections based on
list selections?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top