Boolean Format Options

When boolean is selected as a line item format, there should be an option to have single or multiple selections allowed. Currently, the default is to allow multiple selections. For instance, for single-selection, once one line item has been checked, all of the other line items have a greyed out checkbox that cannot be changed unless the original checkbox has been unchecked.

Comments

PaulRitner

I think you might accomplish this using Dynamic Cell Access.

For example, where one of the children (under a parent) is checked TRUE, you could summarize that checkbox to the parent using ANY and, in turn, set another boolean that locks any sibling cells that are set to FALSE. I haven't done this before, but am confident it would work. The only hitch is if the user selects the entire FALSE column and clicks the Space Bar... it may trigger all to TRUE before the Dynamic Cell Access kicks in.... potentially allowing the user to bypass the control point. Notwithstanding, depending on the use case, this basic control may be adequate.

If you try this, please let me know what happens!

Paul

Miran

Status changed to: New

Quick Links

New ideas

Read-Only Access to Production Workspace Panel Without Admin Rights
Currently, only Workspace Admins in Anaplan can access certain model metadata and deployment validation panels (such as Revision Tags, Data Tags, etc.) in the Production workspace. For security and compliance reasons, we want to avoid granting admin-level access to users who only need to view this information. There is no…
Data Validation Enhancement
Currently, Anaplan does not natively restrict number inputs to specific ranges. Users can input any numeric value, which may result in data integrity problems, especially in collaborative or decentralised planning environments. Introducing a validation capability—where model builders set upper and lower bounds for number…
Multiple approvers in workflow when using, "select user from a line item in a module”
Currently we can assign only 1 approver when assigning using "select user from a line item in a module”. There is no option assign the task to multiple approvers and have one of them approve the task. Even if we create 2 line items each for an approver, since it is a drop down, it is currently giving an option to select…