Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Any way to force user info into a lookup column?

  Asked By: Keaton    Date: Feb 15    Category: Sharepoint    Views: 968

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).



4 Answers Found

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

Maybe this link can help you


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

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

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

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.