Solved

Sharepoint Lists and InfoPath Checkbox List

Posted on 2010-11-26
7
1,629 Views
Last Modified: 2012-05-10
I am trying to do something relatively simple.

I have an InfoPath form that track attendance at meetings, the form contains a list of members obtained from a SharePoint list, on the right of each member I want to have a checkbox that the user fills in.

John Doe                 [  ]
Seamus Brennan    [  ]
Sandra Fahy           [  ]
Mark Gibbin             [  ]

I can get the list in there now worries, but the checkbox is proving to be an issue.

Any Ideas.




0
Comment
Question by:adavir
7 Comments
 
LVL 9

Expert Comment

by:Justin Imes
ID: 34218178
make sure you create a choice column in sharepoint then bind it to the infopath check box you create... Make sure the control is checkbox.
0
 

Author Comment

by:adavir
ID: 34228926
yes, I have tried that. The issue is that the data source is locked as is the resulting check box. As a result you cannot change the value.

When you add a check box to the repeating table/item you end up with the same checkbox for each row so when you check one they all become checked.

using code behind is not an option I'm afraid.

Regards

Paul
0
 
LVL 7

Expert Comment

by:janicet123
ID: 34231862
Are you displaying all items from the list at all times? If that is the case, each check box will need to be bound to a separate item in your list. You will need to create new check boxes for each item. Consequently, if the check box is independent from the list item, you will need to restructure your data source to reflect that.  
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:adavir
ID: 34238822
Hi there,

I'm aware of that, however I will need to know how to accomplish that exactly.

Paul
0
 
LVL 7

Accepted Solution

by:
janicet123 earned 500 total points
ID: 34244566
I am happy to help. You mentioned a repeating table that is pulling informaitno from a SharePoint list. In your data source, you will create a group node for the meeting attendees. Under that, you will create two more nodes under that -one for the attendee and one for attendance that the user can click (the checkbox - this should be created as a boolean field). It should look like the first picture. Then you can insert the group node into your template as a repeating table.

Change the text box for the attendee name to be a drop down box and bind it to the name field of your secondary data source. As new rows are inserted, each check box works independently of the others. See the second screen shot.

If you need clarification, please let me know.  Repeating Table Datasource Picture of the repeating table
0
 
LVL 24

Expert Comment

by:broomee9
ID: 35005196
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…

809 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