(easy?) remove a choosing possibility from list box

[#1]

I have 3 item in the list box I want that the user in a screen will see only 2 item.

There is an easy way to exclude 1 item from this list

Shavit

[amars]

Hi,

If it's just a List box you can use Hide Excluded in the List box properties to hide it. or you can use Reduce Data based on section access to reduce it to the required values.

Regard's

Amar

[#3]

I think I already know the answer to this one based on some other posts I've seen, but I'm going to ask anyway.

Is there any way to prevent the excluded values from showing up in a list box? I have a set of filters in my app for Questions and Answers. The Answer list is fairly long and many of the answers are incongruous with other questions. I've configured it to use Hide Excluded, but would really like to see a filtered list rather than one where the excluded values have been "painted over".

Is this possible?

[Oleg_Troyansky]

Both problems can be solved with a calculated list box. An attached example demonstrates how to solve the second problem - limiting the list to the available values only. The first question is even simpler - simply use the IF formula to exclude the value that needs to be excluded.

cheers,

Oleg

[#5]

Thanks, Oleg. That worked beautifully. The only edit I had to make was a replace() function around the Answer in the variable and expression definitions, since some of my values contain single quotes.

Jim

[#6]

Hi Oleg,

Your example above is really good and works for the selections made.

But would you please be able to show how we can use the conditional list box to reduce the calendar data for week being shown below to show only 13 recent weeks if the user logs in or all the data if admin logs in. Need to use with the section access to limit the data that they see.

I have a scenario to work on and already posted a new discussion with the scenario requirement.

Any help or suggestion would be greatly appreciated.

Thanks,

DD