Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
My requirement is to input a range of values to a four (4) input boxes, currently Im using four variables to get the two minimum and maximum values, the requirement is after inputting the first min-max values, user should not be able to input again the same values in the second min-max.
EX:
Min: Max:
Group 1 : ABC 10 15
in Group 2's Min and Max, user can only input 1 and 9 or 16 to any numbers.
Any set analysis suggestions to this requirements? Please help.
Thanks and more power!
Best regards,
Jason
Hi,
PFA.
Hope it serves your purpose.
thank so much, Abhijit.
by the way cabhijit what about user inputs this values:
Min Max
Group 1: ABC 10 - 15
however in
Min Max
Group 2: DEF any of 1 to 8 - 9 only
or 16 - any number higher than 16
Thanks.
Hi Jason,
If your input for Group1 is ,Min -10 Max -15
Then constraints on input boxes of Group2 will take care of only allowing Min numbers in the range of 1to 9 and Max number >15 only.
Below are the constraints on Group2 input box:
Group2Min:
$ >= 0 and $<$(vGrp1Min)
Group2Max:
$>$(vGrp1Max)
Hi Abhijit,
I understand. Let me explain the requirements, in Group1 the user inputs min=10 and max=15 so the range values for group1 is (10, 11, 12, 14, 15), Now for Group2, user may input min=1 to 8 and max=9 only, the range values for Group2 (1,2,3....9) or user may input min=16 to any number and max=17 to any number, now the range values for Group2 would be (16,17...).
i wonder if this is possible.
thanks again, Abhijit cabhijit
If I understood your problem correctly,
does this attached suffice your requirement?
yes Abhijit, all thumbs up. thank you so much.
Br,
Jason