Execution of Actions - Button needs to be clicked twice to execute all actions
Hello,
The button has the following 3 actions :
1. Select Possible, Field : " QuarterID " (Alternate State : B)
2. Copy State Contents, Source State : " A ", Target State : " B " (Alternate State : none)
3. Select in Field, Field : " Quarter ID ", Search String : " =max({<QuarterID=A::QuarterID>} QuarterID)-1 " (Alternate State : A)
This button basically copies all the selections from State A to State B, then goes back 1 quarter. This way I can create a Quarter over Quarter comparison with Alternate States.
The issue is the button needs to be clicked twice for it to fully execute all the actions. If it's only clicked once it executes Action #1, when it's clicked a second time it executes Action #2 and #3.
I've tried assigning Alternate State A and B to the button in the General tab but I still get the same result.
I have just found this thread (with the help of google) and is exactly the same problem as I am having. Do you have any solution?
I found the following thread useful Button with multiple actions - create a second button that is hidden and then call that via a macro. It seems a strange way to fix the problem when you set up the actions in order and they are not executed until a second time