Hide button Based on a condition in an active form

Post Reply
pikolikoli
Posts: 37
Joined: Sun May 17, 2020 2:37 am
OLAP Product: tm1
Version: 10.2
Excel Version: 2013

Hide button Based on a condition in an active form

Post by pikolikoli » Fri Oct 01, 2021 7:19 pm

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

User avatar
paulsimon
MVP
Posts: 805
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

Post by paulsimon » Fri Oct 01, 2021 8:02 pm

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

pikolikoli
Posts: 37
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

Post by pikolikoli » Mon Oct 11, 2021 3:47 pm

This is very insightfull and helpfull idea. We will work on implementing this idea in our solution. Thank you very much!

Post Reply