Solved

Display list items based on previous selection

Posted on 2013-01-25
8
351 Views
Last Modified: 2013-01-28
Hi

I have  about 10 different users entering data on about 15 different items. I would like it so that the user picks their name from a drop down list, and then the items specific for that person to fill out appear. I need this because some users have two items to fill out and others have 5-10 items.

It could look something like this: if user is H1 then they will see items in the list type1 through type 2

User            Display
H1            Type1
            type2
            Type3

If user is H2 then they should have
User: Display
H2        Type4
        Type5
        Type1


What lists do I need? how to join them? and then how to get this all to work together. I am new to sharepoint, so don't assume I know too much.

I have access to infopath forms and sharepoint designer..

Thanks
0
Comment
Question by:Diaphanosoma
  • 4
  • 4
8 Comments
 
LVL 28

Expert Comment

by:clayfox
Comment Utility
I would create a list called Item responsibility

It has fields Item and User
You can make the user a people selector

you would then fill out all of the items and who is responsible.
If more than one person is responsible for an item make a record for each.

Then in your other form create a data connection to the list.

In your item selector, link to the Item responsibility list data.
Add a filter that username() = user field in list.

Then they will only have the items shown that they are linked to in the list.
0
 
LVL 1

Author Comment

by:Diaphanosoma
Comment Utility
A bit lost. See my comments/ questions in italics.

I would create a list called Item responsibility  OK

It has fields Item and User  OK
You can make the user a people selector  ??

you would then fill out all of the items and who is responsible.
If more than one person is responsible for an item make a record for each.  OK

Then in your other form create a data connection to the list.  What other form? I assume you mean list. If so, how exactly do I create this link?

In your item selector, link to the Item responsibility list data. Is there now a second link? How?
Add a filter that username() = user field in list. Where does this filter get added, I haven't seen a filter choice in anything I've done yet

Then they will only have the items shown that they are linked to in the list.
0
 
LVL 28

Accepted Solution

by:
clayfox earned 500 total points
Comment Utility
When you make the field User in your list, you can choose the type to be a people selector.
This is built in to look up users and store their ID.

Ok, so this new list is a supplement to the original.

If you edit the 2nd list I guess in InfoPath designer.

Add a new data connection to receive from SharePoint and reference the first list.

Make your field a dropdown.
Go to properties and select external data  then choose your data connection to list 1.

You will then browse it and select the item field, but in the lower left of the window will be a filter button.
This is often missed by people.  www.infopathdev.com is another good resource for beginners
0
 
LVL 1

Author Comment

by:Diaphanosoma
Comment Utility
Making a bit of progress. I've connected the two lists together, but now the drop down list for a given user has multiple entries for one person, because a person is responsible for more than one item. The other problem is there is still no changing of the items displayed based on changes in the selection of the user
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 28

Expert Comment

by:clayfox
Comment Utility
In InfoPath 2010 there is a check box at the bottom of the properties to filter duplicates.

I assumed that you would use username() to identify the person opening the form and then just show them the list of items they are responsible for.

They would select one and then enter what ever else you are doing in this process related to that item.

If you want a user to select a person and then an item.
You would have 2 dropdowns, one to pick form the list of users.
Then the one we have been working on filtered by the person they selected.

This is called cascading dropdowns and there are tutorials on infopathdev.com
0
 
LVL 1

Author Comment

by:Diaphanosoma
Comment Utility
I think part of the problem is that I simplified the problem. What is really going on is  that I don't know exactly who is going to fill out the form, but when the person chooses the first drop down list that will identify their company, and then based on that company they only have a few items to fill out.
So the logic is once a person logs on, they select the list to enter their info. Once they "Chose Acme Corp." eg, they have to fill out items 1 through 5. If the person chooses  "XMass Corp." then they will be presented with the items say 5 through 10.

Thanks,

Bruce
0
 
LVL 28

Expert Comment

by:clayfox
Comment Utility
Ok, so company rather than person.

Don't need the people picker then.

You would have the company selector and then the cascading item selector.

One issue is that since SP is flat, you can only do one record at a time.

May want a library form if you want the user to create a list of items per session.
0
 
LVL 1

Author Comment

by:Diaphanosoma
Comment Utility
Yeah, I'm surprised this is so difficult. I am going to get around this problem by having mulitple lists and instruct the users to use their own lists. I just don't have the time or skills to figure this out.

Thanks,

Bruce
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now