Re: how to display dropdowns from sharepoint list depending on user

Clay Fox — Wed, 16 Jan 2008 15:49:58 GMT

Hi Stephanie.

You need to be able to identify the user of your form, and get their full name and other details.

You should check out the AD Web Service from http://www.qdabra.com

With it you can identify your form user and get their name, email address, even group membership and use that to filter your list.

I would recommend a seperator of some kind in your list of names or multiple column fields since it will be dificult to parse a text field with multiple names.

You may be interested in the Database Accelerator package. Qdabra Database Accelerator Suite Version 2.1 - Developer It includes the AD web service and many others. It has a whole suite of form templates for project management that you may be interested in.

Or you may just want to see a demo of how we use it. Let me know.

how to display dropdowns from sharepoint list depending on user

stephanie — Wed, 16 Jan 2008 15:28:16 GMT

I have a Infopath form which I have three drop downs I am pulling from a Sharepoint list. The drop downs are Client, Project, Task. On my Sharepoint site, the list also includes a column for UserName, which I have added users which are working at a particular client and on that project or task. On my Infopath form, when the user opens the form, I would like for the Client, Projects, and Tasks that are associated with the user name to be displayed. But, if that user name is not on that Client, that it doesn't appear on the form.

Is there a way to do this? I am new to Infopath. Any help would be appreciated.

Here is an example of my Sharepoint list

Client	Project	Task	Users
CompanyA	Web site development	Design	Sam SmithJim Jones
Company A	Shopping Cart	Development	Sam SmithAlicia Food
CompanyB	Sharepoint setup	Setup	Bob JohnsonJeff Smith

Thanks, Stephanie

Newbie Questions

Re: how to display dropdowns from sharepoint list depending on user

how to display dropdowns from sharepoint list depending on user