Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the requirement to implement in a few of my apps a "safety cross" - that is a cross, made from many boxes, each carrying the nr. of one day of the month (so that all 28+ days of the month are represented) where every "day_box" can change its colour if there has been an accident on that day.
We have something like that in one app already, but it is made from a multitude of individual textboxes as I said, which makes it near impossible to change the size of this thing ... to the effect that the screen "jumps" quite a bit when switching from any other sheet to the one with this display.
<=> Is there any way to build this other than using a lot of individual textboxes - or at least to connect them all so that I can change
the size of the whole cross more easily?
Thanks a lot!
Best regards,
DataNibbler
Hi Oscar,m
that looks really cool! I don't quite understand it, but it looks cool. - unfortunately, I guess there's no way round using individual textboxes - for I need every "day_element" to be able to change colour and display the shift (early/late) when something happened.
Thanks a lot anyway!
Best regards,
DataNibbler
The objects I'm using are Pivot Tables and you do have the flexability of changing colors. My only concern is because of the shape I had to use four pivot tables in order to accomplish this. In the original Square Pie it was a single pivot table. But you do have the flexability of changing colors depending upon your expression. I simply used a MTD flag to display different colors in my example.
Looking at the middle pivot table (values 7-24)
Three things to worry about:
Dimensions:
First dimension is the number of rows you will need. ValueLoop(3,1)
Second dimension is the number of columns you will need. ValueLoop(6,1)
Expressions: (Day Element)
The expression is a counter for the position of the square, using offsets. (Column()+6) + (6*(RowNo()-1))
Color Expressions:
Background Color. This is where you would create your custom expression for dealing with shift colors.
Text Color
If you do find something that works for you I'd like to see what you come up with.
Good luck
Oscar