Hidden repeatable subform to Visible based on dropdown selection.

PCForm

15-09-2015

LiveCycle - Hidden repeatable SubForm becomes visible when a "MO" is selected. However, if "MO" is changed to "KS" or any other state within the repeating rows, that visible SubForm should reset back to hidden.

Accepted Solutions (1)

Accepted Solutions (1)

Magus069

MVP

15-09-2015

Hi there,

to be able to do so, you should have your dropdown list within a repeatable subform which should be considered as your main index, so you may have 5 drop down lists with each respectively 1 subform comes with it.

So let's say your dropdown list is inside a repeatable subform, and you have another subform underneath that is linked to that drop down list

in your drop down list exit event, you should have if statements to determine which value has been selected, and then depending on the value selected you hide or show the subform

Hope this help!

Answers (4)

Answers (4)

Magus069

MVP

15-09-2015

Okay, then you should iterates through each of the rows to find if you have a drop down list with MO selected, and if you have at least 1 value MO, then you show your subform, otherwise you hide the subform

Hope this will do the trick!

PCForm

15-09-2015

If at least one drop down list has MO selected in the SubForm "Annual Audit", the SubForm "As Per Audit" should be visible,      Correct

MO Visible.JPG

and if none of the drop down lists has MO selected (In the SubForm "Annual Audit", then you hide the SubForm "As Per Audit". (see below)

MO should be hidden.JPG

Magus069

MVP

15-09-2015

Okay, so if I understand well, if at least one drop down list has MO selected, the subform above the table "As Per Audit" should be visible,

and if none of the drop down lists has MO selected, then you hide the subform above the table.. ?

or should it hide/show the subform above the next table?

PCForm

15-09-2015

MO makes the repeatable SubForm "As Per Audit" visible.

MO Visible.JPG

If I the user accidentally picked MO and wanted it to be MN, the "As Per Audit" should go back to hidden. Unless I keyed in the exit formula incorrectly, it didn't work. 😞

MO should be hidden.JPG