Select field as 'Nothing' or select 'Anything'

[anguila]

Hi,

I have a button that selects customers with certain threshold of bill, so when this button is clicked exclodes customers than doesnt reach that point or in a clear way, select all possible customers with requeriment.

But what happens if I select 1 customer that i know for sure thant doesnt reach the threshold? The idea would be ok, so select "Nothing" because there is no posible customers with that selections.

There is a way to achieve that behaviour? Can I select "Nothing" as selector value?

Thanks!

David.

[whiteline]

If you mean that when you select Nothing all associated data become excluded, I guess you cann't.

But you can always add a fake customer 'Nothing' that is not associated with any data except his table.

Then you can just select it.

[anguila]

I already thought that Idea of the fake customer, but will appear that fake customer in the selectors lists.

There is a way to hide a certain selector?

[whiteline]

Yes, two possible solutions:

1) Create a table with two fields Customer and corresponding HiddenCustomer (one row for each with equal values).

    Then add a row where Customer=null() and HiddenCustomer='Nothing'.

    Then use first in lists and second for selection.

    Bu the user will see the HiddenCustomer field in Current selections.

2)  Use expression for listboxes to hide 'Nothing' from visible:

    =aggr(if(Customer<>'Nothing', Customer, null()), Customer)