Hi, I have a custom user list and a another dimension called B with 10 members. There is a input grid where user list is in pages and List B is in the list formatted line item, I want as per each user they should only see few members of list B in the line item in input grid and it is many to many mapping between user list and list B members. I have tried using selective access with B list but was unable to see the results. Kindly suggest a way how i can achieve this? thanks in advance.
does the input grid have more dimensions besides users and List B?
Dynamic Cell Access should be able to provide the solution you are looking for. Lets have a look at the different steps you need to take to achieve your desired goal:
1. Create a module with the custom user list and the "List B" and 2 line items formatted as boolean: Write? and Read?. Then manually select these items from list B that should be accessible per User.
2. Then, in the Data input grid, go to the blueprint and scroll right until you find the columns "Read Access Driver" and "Write Access Driver". Select the Line Items from the module created in step 1.
3. Right after completing the step 3, you should see the effect on your data input grid. I advise you to publish both modules (the "access driver" and the "input grid") on the same dashboard and pivot the views if needed, so you can easily test the impact of the former on the latter:
Please, let me know if it helped. Else, feel free to attach some screenshots or provide some more details.
In reference to my previous post. You can simply achieve this by enabling selective access for both the list and give relevant access on both the list. Selective access for your custom user list will be one-to-one mapping while enabling write access.