Reverse ARRAYS to control visibility states
After reviewing the file and the question, even though I understand what I was after I would have to agree that someone else won't. I also feel in some ways I was also complicating some aspects of the block. The idea behind the block is short and simple.I have narrowed it down to 4 questions as I can't see any other problems off hand. I hope this is more explanatory of the requirements.
Anyway after some thought I have decided to simplify it with 2 controls only (see sketch below). The top being the overall quantity. The bottom being the Future Quantity. I do have some issues though. Q4 can probably be skipped as this more of a OCD (Obsessive Compulsive Disorder) question. Because of the way the block is set up this would be impossible to do unless you edited the block accordingly. in the block editor by making these stretch triangles visible.
Notes: In question below you will see for example (1B)... this refers to a sketch in the drawing. Some of the blocks have been purposely shown with the required outcome.
(1) as you will see in V2 at Q-box 1 you have a Qty with the X set to zero (1A). When you set the overall quantity (top pull down) lower the Bottom remains the same qty as before (1B). so as per example my original overall qty is 4 when I make the overall qty 3 the bottom qty still stays as 4(1B). If change top overall qty to 2 or 1 the bottom qty is still 4. Requirement is that when X= 0 the bottom quantity cannot be more than the overall quantity (1C)
(2) If the original overall top qty is say 3 and the X qty is 1 (2A) when I increase the overall top qty it increases the X Qty (2B) I wish that the x qty would remain 1 (2C). If I had an overall top qty of 5 with the X qty as 2 and then changed the overall top qty to 11 then X qty would still remain 2 until changed.... (SIDE NOTE:This is probably functioning and one would then be required to lower the X value accordingly)
(3) The X Qty can go over the overall top qty (3A & 3B). The requirement is that at most X qty must always be at one less then the overall qty so if TQ=2 then X=1 if TQ17 then X=16 if TQ=million and one X=million....... (3C & 3D & 3E)
(4) I have copied the block and renamed it, This version allows you to use stretch triangles to control the bottom X and bottom square quantities. I have it working that you can control the bottom squares by using the X stretcher. The problem though is that if you have say an overall quantity of 10 and stretch the bottom square to qty 3 you have a gap. Controlling the X will keep this gap the same so X=3 BS=3 then X=4 BS=2 then X=5 BS-1. Another issued with this is I notice that if I then stretch the X to the BS the bottom squares extend beyond the overall quantity
