Register

New formula for checking User's access

New formula for checking User's access

As a Model Builder, I would find new function really useful:

Syntax

HASACCESS(x,y,[f])

Returns Boolean, "TRUE" if User has specified access, where:

  • x: Users list-formatted line item containing .
  • y: Item of the list with Selective Access enabled.
  • f: Flag which tells which access formula should test, keywords: "ANY" (default), "WRITE", "READ" (optional).

We need it to set DCA really dynamically, based on real SA, and not on some imports like we do now.

7 Comments
Miran
Community Manager
 
Status changed to: Your support is needed
MarinaDunets
Contributor

Hi!

 

As a model builder I need smth familiar to the idea described below, so I decided to put this as a comment, not as a separate idea. 

I'd like to use Workspace Admin boolean in my formulas (example is on the screenshot attached).

It would be super-useful for dynamic cell access management

 

2019-08-27_15-40-37.png

NakulAggarwal
Certified Master Anaplanner

Hi,

 

This formula for HASACCESS is not working, i was selecting selective access to one of my list formatted line item but that is also not working. 

 

Is there any solution update to the same ?

MarinaDunets
Contributor

Hi, @NakulAggarwal!

 

The formula HASACCESS does not exist in Anaplan, it's just an idea proposed by @M.Kierepka

The full list of exisitng formulas is here: https://help.anaplan.com/anapedia/Content/Calculation_Functions/CF_All_Functions.htm

andrewtye
Master Anaplanner/Community Boss

This would make life particularly useful especially when the user based is approaching 1k!

Gwen.pryor
Regular Contributor
 
Status changed to: Under Investigation
jepley
New Contributor

Many applicable uses if this were available. Dynamic filtering without using the dimensionality of the selective access. Great suggestion @M.Kierepka