SharePoint Integration

Re: Sharepoint binding problem

Clay Fox — Thu, 10 Apr 2008 18:59:25 GMT

Just add a repeating group or fields, depending on your need, to your main data source. Right Click on the node.

Re: Sharepoint binding problem

jowardel — Thu, 10 Apr 2008 18:43:35 GMT

ah yes, i understand what you mean by set field now.

when the user checks/unchecks a checkbox the value of the textbox (which is also inside the repeating section and binds to another field in the sp list) is copied to a field in the main form.

this means that if the user selects the checkboxes:

england

usa

france

the field in the main form is set to "england, usa, france"

how would i go about creating local fields to store this data in?

Manyb thanks,

Re: Sharepoint binding problem

Clay Fox — Thu, 10 Apr 2008 18:11:10 GMT

What does the check box do?

When they select it?

Often I would have a rule on the checkbox that when it is selected it use a setfield action to copy the cooresponding list data into your main form.

Then this selection will be saved or could be accessed later.

This is compatible with form services.

Re: Sharepoint binding problem

jowardel — Thu, 10 Apr 2008 17:18:44 GMT

I have set up a data connection to a sharepoint list

as i said, i have a repeating section (bound to the sp data connection) with a checkbox inside (bound to a field in the data connection)

the reason i use a repeating section is there could be n number of records in the sp list and i need a checkbox for each one.

i did not want to bind the checkbox to anything because I do not wish to pull any boolean value down from the sp list, but infopath does not allow me to leave the checkbox unbound within a bound repeating section.

how does a field action work? is it compatible with the Forms Service?

Re: Sharepoint binding problem

Clay Fox — Thu, 10 Apr 2008 17:06:10 GMT

It really kind of depends on the data and the form flow.

The simplest way is to use a set field action.

The most complex is using code to copy a whole node.

Give a bit more detail of what you are wanting or a screen shot.

Re: Sharepoint binding problem

jowardel — Thu, 10 Apr 2008 16:49:51 GMT

How do I load the secondary data and then store it in my main data ?

Re: Sharepoint binding problem

Clay Fox — Thu, 10 Apr 2008 16:43:03 GMT

It sounds like you are not storing the values in your main data source. The fields for the check boxes should be bound to fields in your main data source if you want them retained.

Typically you would load the secondary data but then transfer it to your main data so that the responses can be stored in the form and be used later.

Sharepoint binding problem

jowardel — Thu, 10 Apr 2008 16:25:47 GMT

Hope this is the correct alias for InfoPath questions, apologies if not;

I have a browser-enabled InfoPath form, with a repeating section, which contains a checkbox and textbox.

The repeating section is bound to a sharepoint list, and the controls inside are bound to columns in that SP list.

This works fine, however when I submit/save the form and then reopen, the checked status of the checkboxes is lost.

I realise that this is because the binding is performed again and thus the checkbox values are overwritten, but I do not know how to work around this (apart from writing some OTT C#).

Is it possible to stop InfoPath performing the bind?

Anyone got any ideas? Thanks in advance.