Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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?
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)