12 Replies Latest reply: Mar 15, 2012 9:04 AM by Chanchal Diwan RSS

Move different sheet on click of bookmark object

Chanchal Diwan

Hi all,

 

I want to add one bookmark object in my application . Through this bookmark to add some condition ,

I want to move diffrent sheet on click of the condition.

 

Please help any one as soon as possible

Thanks in advance

  • Move different sheet on click of bookmark object
    Jason Michaelides

    When creating your bookmark tick "Include Layout State".

     

    Or else use a button with a Bookmark > Apply Bookmark action followed by a Layout > Activate Sheet action.

     

    Hope this helps,

     

    Jason

    • Re: Move different sheet on click of bookmark object
      Chanchal Diwan

      yes , I agree with u.

      But i want same thing by bookmark which can be done by button .

      Whatever U people replied i already did but its not working.

       

      Please give me another solution.

      I will be thank full to everyone

      • Move different sheet on click of bookmark object
        Jason Michaelides

        Sorry - can you be a little clearer?  Do you want a button to apply a bookmark and move sheets?  If so, see my comment above.

        • Re: Move different sheet on click of bookmark object
          Chanchal Diwan

          ok

          i m explaining sothat it will  more clear

          I have one application in which 4 sheet which names are dashboard,product,customer and bookmark.

          on the bookmark sheet there is a bookmark object.in bookmark there are  2 conditions

          1. product>20%

          2. customer in gp%

            in this application when i clicked on 1st condition i move product sheet ,when i clicked on 2nd condition i move customer sheet with message.

           

          Same thing i want to apply in my application but i unable to find the solution.

          • Re: Move different sheet on click of bookmark object
            Ashok Chandran

            Hi

             

                      You want only to move the sheet when you select the bookmark like product>20 or customer in gp% or example you want to move the Product sheet with the associated filter (like select the filter to show the product which are coming under the below (>20) %  when you select bookmark product>20%.

          • Move different sheet on click of bookmark object
            Kaushik Solanki

            Hi Chanchal,

             

                      Bookmark is used only for the purpose of saving the selections which you want for later use. The movement of sheet is achieved through the button.

                      There is no way you can make bookmark object to act as a button to move to next sheet.

             

                      But there is a way to achieve this in a  different way.

                      Say for example. You need create two booksmarks as you said above. i.e 1 for product >20% and 2. Customer in gp%.

             

                      Now you should create two buttons with same name as your bookmark name. i.e Product > 20% and Customer in gp%. Now you have to add actions on both the buttons. lets consider you are adding action to button 1 (Product > 20%). Here add action for applying the bookmark and also add another action which will activate the product sheet. So when you click the button the bookmark will get applied and also the user will be taken to product sheet. Same way you can do for the 2nd button.

             

                      So both the things will be done in just one button click.

             

                      Hope you understood.

             

            Regards,

            Kaushik Solanki

            • Re: Move different sheet on click of bookmark object
              Chanchal Diwan

              Hi Kaushik

               

              Thanks for reply.and sorry for very delay .

              I was busy in different work.

              i agree with  your answer but i have one application in which same work done by  bookmark.and I checked there is no button.

              I attached that application see the last sheet.

               

               

              Regards

              Chanchal Diwan

              • Move different sheet on click of bookmark object
                Kaushik Solanki

                Hi Chanchal,

                 

                     Let me explain how it works.

                 

                     When you create a new BookMark you get an window where you define the name for that bookmark, within this window(wizard) you  will also find an option called "Include Layout State". If you select this option and save your bookmark, and when you select this bookmark it will take you to the state when you have created the bookmark.

                 

                    For example if you do some selected in "Salesman" Sheet and from that sheet only if you create a bookmark with selecting the "Include Layout State" and save it. Now whenever you select the bookmark it will take you to the sheet "Salesman"

                 

                    So you are getting a feel like its working as a button, but actually it is not.

                 

                    Hope you understood. Try this and check it out. Let me know if you need more clarification.

                 

                 

                Regards,

                Kaushik Solanki

  • Move different sheet on click of bookmark object
    Ashok Chandran

    Hi,

          I tried to find out solution for your problem. In bookmark condition we can't move one sheet from another sheet.

     

            But as like Jason said we can Move one sheet from another sheet using the button and the button Action.

     

              OR

     

         In the Settings ---> Document Properties ---> Triggers ---> OnAnySelect Event we can add the Action to Apply Bookmark based on the BookMark Object ID. Not based on the BookMark List Values.

     

    Regards,

     

    Ashok