Create a Formula to Reference a User's Model Role

Create a Formula to Reference a User's Model Role

Dynamic cell access can be extremely challenging with long user lists, especially if you want a user's read/write abilities to be dependent on their model role. If we were able to reference a user's model role via a formula, we could create role specific criteria for dynamic cell access.

10 Comments
Master Anaplanner/Community Boss

@rachel_goering 

We are currently investigating various enhancements to the user list, including subsets and possibly creating a roles list, similar to users which will allow DCA by role

Would that satisfy the user case?

David

Certified Master Anaplanner

@DavidSmith Yes, that would satisfy the use case. Is there an estimated release date for those enhancements?

Super Contributor

I wish I could have add 1000 kudos!

 

@DavidSmith really looking forward to that! 

Master Anaplanner/Community Boss

@rachel_goering 

We've still to do the investigation so a little early for estimates

That said, it is unlikely to be this year, but it is high up on my priority list

David

Occasional Contributor

@DavidSmith this sounds great!! would make creating User access much easier and complete

Certified Master Anaplanner

Adding this functionality would be fantastic and would greatly simplify DCA management as well as user access/security management which are audit-able and recurring reviews at my company! Excellent suggestion @rachel_goering!

Certified Master Anaplanner

This would be so great!!!

Certified Master Anaplanner

Always looking forward to more user management functionalities!

New Contributor

To add on, we need some flexibility w.r.t read access - We have a use case, where we want to give read access to certain locations but allow users to filter the locations(multi-select scenario) based on a flag - Due to read access, they can't select the flag against the location and it is set to false for them. 

There shall be flexibility where we can bypass the default access for a line item/module. 

Thanks!

Certified Master Anaplanner

@rachel_goering great idea! DCA has been a very useful addition to how users interact with the model, and this will only expedite the time set it up and will increase the use of DCA by making it a simpler process.

Users Online
Currently online: 195 members 548 guests
Please welcome our newest community members: