Show/hide multiple tables based on selection

[ahammadshafi]

Dear Experts:

Please note, there are four tables in my app - 1. Sales, 2. Budget, 3. Forecast I and 4. Forecast II

I have to show them based on selection from "Type" List Box and to do that I have set condition in "Layout" tab like the following

Now the app shows the tables accordingly.

But if I select multiple items from the list box all the tables disappear.

According to client requirement, in the given scenario Sales and Budget tables need to be shown.

Looking forward to your suggestions.

Ahammad Shafi

[jonathandienst]

Use a conditions like:

=WildMatch(Concat(Type), '*Act*')

=WildMatch(Concat(Type), '*Bud*')

[Chanty4u]

try something lik below

=if(

(GetFieldSelections ([filed])='no'

or GetSelectedCount([YourFlag])=0

or GetSelectedCount([YourFlag])=2

)

,Expression1

,Expression2

)

[Chanty4u]

or

=GetSelectedCount(filed)=1

=GetSelectedCount(filed)='value';

[ahammadshafi]

Hi Jonathan:

Many thanks, it works fine with one exception - when I select "Forecast II" it shows two tables (Forecast I and Forecast II).

The condition I have set in "Forecast I" table is  "=WildMatch(Concat(Type),'*Forecast I*')"

                                and in "Forecast II" table is "=WildMatch(Concat(Type), '*Forecast II*')"

[jonathandienst · Accepted solution]

Add a delimiter like a pipe |, so that you can distinguish these:

=WildMatch('|'& Concat(Type, '|') & '|', '*|Act|*')

=WildMatch('|'& Concat(Type, '|') & '|', '*|Forecast I|*')

[ahammadshafi]

Many thanks to both of you. Got it resolved