npaadmin Posted April 18, 2007 Posted April 18, 2007 Question, Is there a way to have a limited view for a certain privlege set based on a yes/no drop down menu? Eg: Sales cannot see records that are tagged "No" in the "Active" field. I have a calc set up for another department where users can ony see records that have assigned to. Keeping our sales department from seeing inactive records is pretty important for us. Thank You In Advance,
Steven H. Blackwell Posted April 18, 2007 Posted April 18, 2007 Fascinating. Yes, jsut set their privilege set so that they cannot see records where the value in the field is "No." This is done in the Define Acciunts & Privileges area. Steven
npaadmin Posted April 18, 2007 Author Posted April 18, 2007 This I understand and I have gotten that far. I am not sure how to code it to say If field "Active" = no then users under this privlege set cannot view. I have tried a few different things but nothing seems to be working for me. Could you give me any direction as to go about doing this?
Steven H. Blackwell Posted April 19, 2007 Posted April 19, 2007 Define Accounts & Privileges-->Privilege Set tab-->Edit (or new)-->Records-->Custom Privileges-->Set privileges--> View-->limited and enter the calculation. Steven
npaadmin Posted April 30, 2007 Author Posted April 30, 2007 I was able to do this by using ( Active ) ≠ "no" Thanks for the tips. It's working perfectly.
Steven H. Blackwell Posted April 30, 2007 Posted April 30, 2007 For text values, I'd recommend using the Exact function instead of the = operator. Steven
Recommended Posts
This topic is 6419 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now