• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

complex select formula based on roles

I've got this view which I would like to perform specific selection formulas according to the user access.
I've been looking for a method using @UserRoles but it doesn't work on select formulas. The same happened with @dbLookup (I thought I could make some views with the users and their access levels).
Any idea on how can I do this without makin a special view for each user? I'm talking about 90 different access levels :P

1 Solution
Put the view in a page and use "Show single category in embedded views" option this work with roles...

Or use shared private on first use views.

frenetixAuthor Commented:
thanks, I'll try that. but since I'm kind of new with notes 5 (been working with 4.6 lately) can you tell me where to find some guides on how to work with pages?


Pages is an R5 thing. Not available in R4.x.

Can't you use the roles in a readers field?
All you'd have to worry about is the remainder of the selection.
If the readers field says "[Role1]":"[Role2]" you wont be able to see the document unless you have either of those.

By the way... you mentioned @UserRoles and 90 different access levels. Is R4.6 capable of using that amount of roles? I don't remember the limit; just that it appeared insufficient to me in one assignment!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now