Here is my problem, I have a view that I want to be a “Show My Requests” type view. It should only show the documents the author created and that’s it. I was thinking I could do it with simple select script but this not going so smoothly for me. Below is examples of what I have tried.
SELECT Form = (“EntryForm” & = @UserName(Title_Name))
SELECT Form = “EntryForm” & @Name([CN];Title_Name) = @Name([CN];@UserName)
Title_Name is a computed on composed author field and the form is called EntryForm
Each time I have tried them it clears out the view and nothing shows up for anyone.
Any help would be Awesome Thank you!
Subject: Private view
Hello,
Selection formulas are “compiled” when saved. @Username is replaced by developpers name.
You need to create a view “Becoming private at first use” or something like that (i use a french version)
Bye
Subject: @UserName in selection formulas
You can’t use @UserName in a selection formula (as the help tells you).
There are a huge number of posts on the forum about this (have you searched?)
Your options are:
Private views, but this has lots of drawbacks, again search the forum
Single category embedded view - the generally accepted way to do it
Readers fields - if you’re only wanting people to see their own documents at all times you can use readers fields then only have one view
There are other ways potentially, eg if this is a web only db then you can build ‘views’ in webqueryopen agents
Subject: Single category!
My “duh” on the @username command. Thank you for the direction on the Single category idea.