View by employee Name
I have 2 database, one is for workflow and one is for attendance. In the attendance database, I have a view that is called My Time, a simple nice little view that will allow associates to see only their time that they have taken off. The formula for the view selection is:
SELECT employeeName=@Name([CN];@U
Now in my second database, I would like to create the same type of view that is My Calls (since the 2nd is a call record database).
I have copied the same formula over and tweaked it to this:
SELECT employeeName=@Name([CN];@U
This does NOT work, what happens is that all the associate can see my actual calls I have logged and not theirs. But if I refresh the documents they all just go away. I do not understand how this can work in one database and not the other. I did not want to make these private views, so they are currently both shared. If anyone has any suggestions that would be fantastic!
SELECT employeeName=@Name([CN];@U
Now in my second database, I would like to create the same type of view that is My Calls (since the 2nd is a call record database).
I have copied the same formula over and tweaked it to this:
SELECT employeeName=@Name([CN];@U
This does NOT work, what happens is that all the associate can see my actual calls I have logged and not theirs. But if I refresh the documents they all just go away. I do not understand how this can work in one database and not the other. I did not want to make these private views, so they are currently both shared. If anyone has any suggestions that would be fantastic!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so much Marilyng - I think that I am going to do is the embedded view, that makes the most sense. I can control who creates views and such. Thanks again
for views that contain @Username the best option is to use "Shared, private-on-first-use views" or "Shared, desktop private-on-first-use views".
That kind of view is shared and when the user first access it, it is saved (in your db or in the desktop.dsk, that's the difference between two mentioned types) as private view.
Locate "Private views" - "described" in designer's help index.
Hope this helps,
Marko