Hello Forum ,
I have an active form where based on a cell value I want to hide or show a button.
Is there anyway to achieve this solution in TM1 without using VBA ?
Thank you
Hide button Based on a condition in an active form
-
- Posts: 38
- Joined: Sun May 17, 2020 2:37 am
- OLAP Product: tm1
- Version: 10.2
- Excel Version: 2013
- paulsimon
- MVP
- Posts: 808
- Joined: Sat Sep 03, 2011 11:10 pm
- OLAP Product: TM1
- Version: PA 2.0.5
- Excel Version: 2016
- Contact:
Re: Hide button Based on a condition in an active form
Hi
As far as I know there is no way to hide a button without using VBA. Presumably you are using this on a Web Sheet and therefore VBA is not an option.
While you cannot hide the button, you can alter what the button does and what it means.
For example, we use sheets where we have one Action Button with a caption "Take Selected Action".
The list of possible selected actions is selected via a Drop Down List, either driven from a TM1 PickList or a conventional Excel Validation List.
We can then use Excel formula to alter the content of the list.
For example,
If the workflow is at the Contribute stage, then the only option is Submit.
If the workflow is at the Initial Review stage, then, if the user is a valid Authoriser for that stage then the list will have the options Approve and Reject. However, if they are not a valid Authoriser, then it will only have the Reject option.
The Action Button runs a TI process and passes in the selected action as a parameter, along with other parameters such as the cost centre.
The TI process validates the selected action, eg it gets the current state of the cost centre and if it is at the Initial Review stage then if the action is Approve it will check that the user running the process is a valid authoriser for that cost centre at that stage. If validations are passed then it will process the selected action. The TI process either carries out the action directly or calls other processes to do whatever is necessary eg copying data, updating the workflow state, etc.
Perhaps an approach like this will work for your case?
Regards
Paul Simon
As far as I know there is no way to hide a button without using VBA. Presumably you are using this on a Web Sheet and therefore VBA is not an option.
While you cannot hide the button, you can alter what the button does and what it means.
For example, we use sheets where we have one Action Button with a caption "Take Selected Action".
The list of possible selected actions is selected via a Drop Down List, either driven from a TM1 PickList or a conventional Excel Validation List.
We can then use Excel formula to alter the content of the list.
For example,
If the workflow is at the Contribute stage, then the only option is Submit.
If the workflow is at the Initial Review stage, then, if the user is a valid Authoriser for that stage then the list will have the options Approve and Reject. However, if they are not a valid Authoriser, then it will only have the Reject option.
The Action Button runs a TI process and passes in the selected action as a parameter, along with other parameters such as the cost centre.
The TI process validates the selected action, eg it gets the current state of the cost centre and if it is at the Initial Review stage then if the action is Approve it will check that the user running the process is a valid authoriser for that cost centre at that stage. If validations are passed then it will process the selected action. The TI process either carries out the action directly or calls other processes to do whatever is necessary eg copying data, updating the workflow state, etc.
Perhaps an approach like this will work for your case?
Regards
Paul Simon
-
- Posts: 38
- Joined: Sun May 17, 2020 2:37 am
- OLAP Product: tm1
- Version: 10.2
- Excel Version: 2013
Re: Hide button Based on a condition in an active form
This is very insightfull and helpfull idea. We will work on implementing this idea in our solution. Thank you very much!