Select values only among the possible ones

Anonymous — Wed, 17 May 2017 15:53:31 GMT

This should be an easy one:

Within the field named "VALUE" there will be done some selections, normally range selections (like ">0" or ">-100000<200000"), so in order to make it more appealing to the user I designed the following structure:

i. A couple of input text boxes (qsVariable) so that input can be provided and collected as lower and upper bounds of a range

ii. A button (SheetNavigation & Actions) to apply the range selection provided

The issue here is that this selection is not the first one, values in other fields will have been selected at this point, and this selection is not performed on the set of non-excluded values (selected, alternative or possible values are all good) but on the whole set, which can ruin previous selections when selecting excluded values.

I would like it if the selection could be made only on non-excluded values.

Do you have any tips? I am at a loss here

PS: is this even doable??

topic Select values only among the possible ones in App Development

Select values only among the possible ones