Hi,
Appreciate the subject line is a bit odd
Basically Iโm trying to create a view which has a padlock on it - meaning everyone can see it but only certain people can access the detail behind it, which of course I will control dynamically from my users table.
Does anyone have an idea how I could implement this?
Ideally Iโd like to place a default message inside the view when clicked (when they donโt have access to it) which says โPlease contact us to gain access to this viewโ etc etcโฆ?
Thanks
Immy
Hmm just thinking this throughโฆ
I guess I could have 2 views, one which is shown to those who donโt meet the dynamic criteria and the other which does - I could then just have a dummy table with a single record to display a message in place of the โpadlockโ view. Trying it out
You could use Show_If to hide the column for unprivileged users. You could also add a (virtual?) column of type Show to show only to unprivileged users with your message.
See also:
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |