Re: Using [Me] on text columns by Todd
Todd
Thu Jan 08 16:27:42 CST 2004
I tried this before. [Me] only seems to work on SharePoint fields like
Created By and Modified By.
When I try to create a _single line text column_ called UserName, populate
it with server\user information, and then set the filter on that field to
[Me]; I get a <!-- #RENDER FAILED --> error.
However, if you create a _lookup column_ on the User Information list you
can use [Me] as a filter. If that works for you, the list grows to include
users as they are created. However, sometimes that global list of users can
become quite large and the dropdown rendering inefficient. Let me know if
that meets you needs.
I tried one promising workaround that didn't work. I Created a Custom List
called UserNameLookup that only has a single lookup column called UserName
of people on the User Information list and the Title field you just can't
get rid of. I then created as many records as you want, one for each user
you want in the final dropdown (ensuring that they were not duplicated).
Returned to the listview of the original document library and added a lookup
column on the UserNameLookup list. All of this works as I had hoped.
However, only the ID and Title fields could be selected. The UserName field
is not in the list of fields to show. Bummer. If it had been than I would
wager that [Me] would have worked on that field as well.
HTH,
<Todd />
"Magnus" <anonymous@discussions.microsoft.com> wrote in message
news:2324511E-C4E0-4C7B-8056-B40097BDDBEA@microsoft.com...
> Is there any way I can use [Me] as a filter on a single line text column
when I create a view in a document library? Normally it doesn't seen to
work. Maybe there's a workaround...?