Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Hidden repeatable subform to Visible based on dropdown selection.

PCForm
Level 2
Level 2

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.

1 Accepted Solution
Magus069
Correct answer by
Level 10
Level 10

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!

View solution in original post

5 Replies
Magus069
Correct answer by
Level 10
Level 10

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!

PCForm
Level 2
Level 2

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


Magus069
Level 10
Level 10

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
Level 2
Level 2

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
Level 10
Level 10

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!