You can work with the visibility condition of the sheets.
Go to the sheet properties -> General -> Show Sheet and write an expression there.
For example, when the user selects only one loan, it goes automatically to sheet 2.
Then, on sheet 2, the condition would be =if( count(distinct loan)=1,1,0)
On all the other sheets, the condition would be exactly the opposite:
=if( count(distinct loan)=1,0,1).
On this details sheet, you can include a button where the user can clear the selection on this field.
- Include a button, go to properties -> Actions -:> Add -> Selection -> make any selection on the field (if the value does not exist this would mean a clear as well).
A second alternative would be the creation of a control variable. Go to Setttings -> Variable Overview and create any variable (controlSheet, for example).
Then you can include buttons on the sheets to set the value of this variable to 1 or 0.
Use this variable as the visibility condition (as described on the first option). The condition would be:
=controlSheet
----
On this forum, you can mark on or more answers on your post as 'verified'.
Hope it helps,
Regards,
