Jump to ___ in sheet ?

[#1]

Hi,

I build a very long page with many tables. The layout needs to remain this way for various reasons, but the tables themselves fall under different categories. What I'm asking is if there's a way to create a button (or any other solution) that by clicking it the view will jump to a specific section of the sheet, (something like you will see in many websites) ?

Thanks

[fernando_tonial]

You can try use the actions in the button object.

Best Regards.

Tonial.

[Anonymous]

Hi,

you can create a button, then make it activate a variable something like =if(vShow=1,0,1)

and on the table layout you chose the condition that shows the table

setting variables is under setting-->variable overview

hope that helped

[Anonymous]

Hi,

Can you please explain detail what you needed.

Thanks

[marcus_sommer]

You should separate your objects in several sheets. Within the sheets you could put the objects one above the other and controled the visibility per variable (settings in layout) and/or put the opbjects in container-boxes which could also be nested. This could you control per macros or actions in buttons which choose the sheet or perhaps bookmark and/or set variable-values and so on. If you have any scroll-bars the usability isn't really good ...

- Marcus

[#6]

All, thanks for trying to help.

What I have is one long sheet with many pivot tables one below the other.

This has to remain the format.

I cannot break it to different sheets or to use conditional show/hide.

That's why I asked how I can get a "jump to" functionality, for places within the same sheet.

Thanks

[#7]

please see below

[#8]

please see below

[#9]

please see below

אבנר  ?

[marcus_sommer]

I Think this isn't possible, it isn't a native functionality in qv. Which advantages have you with several large tables on one sheet?

- Marcus