Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Any way to force user info into a lookup column?

  Asked By: Keaton Boyle         Date: Feb 15, 2006      Category: Sharepoint      Views: 452
 

I'm using 2003, and I'm trying to make use of AD groups instead of
adding individual users to a web. I want to create a lookup column
that shows all staff. When using groups instead of individual users,
though, only those who have actually visited the web show in the
lookup options.

Aside from sending a message to all staff begging them to click on a
link to the web (so they've all "visited" and therefore show in my
lookup column), what are my other options?
Any no-code options?

This is for a project where I need to be able to choose any of our
current employees as the contact for a list item. I don't want to have
to manually type their names, especially because I want the features
of presence info (and, of course, I don't want to run the risk of
misspellings/user errors).

Tagged:                  

 

4 Answers Found

 
Answer #1       Answered By: Gopal Jamakhandi          Answered On: Feb 15, 2006       

Maybe this link can help you

mindsharpblogs.com/.../853.aspx

 
Answer #2       Answered By: Dameon Dejesus          Answered On: Feb 15, 2006       

Unfortunately, since I'm trying to do this with the
built-in "user information" and not an actual list or column  from
another list, I don't know how to use this to help me. I am
thinking, silly as it sounds, that it would be good to just send out
a link and ask folks to click on it so they become "site visitors."

 
Answer #3       Answered By: Tejaswani Barve          Answered On: Feb 15, 2006       

There is another way of doing this, add the users programmatically to the WSS site. They will then show up in the lookup  field. Later delete them programmatically.

I have done this before by querying UserInfo table (I know not a good practice to query SharePoint db), and added all the users with Contributors rights to a WSS site on a single click of a button. Another button was to delete all users.

You can create a similar tool using windows application.

 
Answer #4       Answered By: Harshita Padwal          Answered On: Feb 15, 2006       

It sounds a bit cumbersome, but since there's no built-in
option, this will work for me! I won't do the query thing, but I can
easily add the people I know I need in the lookup  column, and once
we publish and advertise the list, others will hit the site, become
users in the lookup list, etc. Whenever I run into a problem w/ one
or two users not showing in the lookup options, I'll do the
add/delete thing.

 
Didn't find what you were looking for? Find more on Any way to force user info into a lookup column? Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].