Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there any way to have tables dynamically change their X & Y position?
For example table 1 has 10 rows in it based on a set of criteria and the next table 2 is right below it.
But if the table 1 now has 15 rows, how can table 2 dynamically move down to avoid overlapping?
Thanks
Frank
Only with macros would it be (with some efforts) possible to change the object-positions and it's not really recommended to do it. Therefore you will need different approaches - by only a small number of possible different records you could use several objects and hide them conditionally - otherwise you need to rethink the whole usability of this sheet respectively the entire application.
- Marcus
To avoid Overlapping use NoConcatenate - May be?
Only with macros would it be (with some efforts) possible to change the object-positions and it's not really recommended to do it. Therefore you will need different approaches - by only a small number of possible different records you could use several objects and hide them conditionally - otherwise you need to rethink the whole usability of this sheet respectively the entire application.
- Marcus
Marcus
We came up with the same idea as you posted this. Thanks for confirming our assumptions
Hi Frank, Try putting your tables in a container. Choose the grid style with one column and two rows. Cheers Andrew
Andrew
We tried that, but the tables didn't change their position. the only way we were able to achieve the look and feel that we wanted was to show and hide multiple tables