InfoPath Dev

I have now been able to get the item in the list. I think that If some column is defined as lookup of some other information on the site than web service does not create the list entry. Ex. one of the column is the ID which is forgeign key to a doc library id column. Or a column like "Assigned To" which is a person/group type column. If I am trying to insert some value in it, I get the success message but entry does not get created. But If I leave this column blank from infopath form and fill rest of the information then it is created.

Date fields are also causing similar problem. Help!

Hi Schweta,

It sounds like you are starting to get into making some pretty complicated CAML templates. Instead of forging these with your bare hands you might consider wielding the the CAML Query Builder V2 put up by Patrick Tisseghem athttp://blog.u2u.info/DottextWeb/patrick/archive/2005/05/29/3522.aspx

This should help make those complicated CAML queries a little easier! Please let me know how the use of this tool goes, I have not used it and am curious as to how well it works.

Very helpful info!!

Thanks to all for this great thread. I've been working on updating a helpdesk issues list with infopath and this has helped me a lot. One question about this design though... Is it possible to not have the list display on the form? How about changing the displayed field names on the form without goofing up the functionality? Everything is working just the way I want it to... but now I'm having issues with prettying it up.

dmhollis

I'm glad the tutorial has helped you! There are some tricks to pretty up how things are displayed.

To change the field name you could set up a secondary data source that has the actual field names and the names that you want displayed. After this is done, you can use an expression box in each row to display the correct display name depending on what row you are currently displaying.

Hi, I'am new in this fantastic forum!

First i want to say thanks to Matt for that fantastic description how to add sharepoint list items with InfoPath.
With the CALM you have posted in the description the fields only appears as textboxes. I would like to change the control types. I need dropdown lists and things like that.
How do i do that using CALM?

I know that his question was already posted in that forum, but cant find any answer.

Thanks,
Christoph

Hi Christoph, Welcome to the forum and I'm glad to hear that it has been such a great resource for you!

You should be able to do this by right-clicking the textbox, opening the Change To.. Fly-out, and then selecting the control that you would like to use. If you want to use different controls for different fields you might need to use a little more advanced technique than what was provided in the HowTo to capture your data. This will entail having another secondary data source with static layout, and then code behind your submit button that reads the inputted data and generated the CAML template.

I hope this helps, let us know if there are any more questions!

Hi Matt,

Once again, thanks for a truly informative post! I've got my Issues list form looking better now.... but I was reading your post to Christoph and it looks like I'm stuck in the same boat. I've got fields that need to have static dropdown lists and others I'd like to pull from an xml list of users... so, if I'm understanding this correctly.. Can I use the data connections up to this point? Or do I have to add separate data connections for each of the custom fields I need to populate with a drop down? If this is all code behind... is there anyplace you know of that I might browse some snippets to get an idea of where to start?

Thanks,
Dave

Hi Matt,

thanks for the great tutorial "Add Sharepoint List Items With InfoPath" :) you dont know how much it helped me..

just curious though, can we use the same workaround for _modifying_ the list items through InfoPath form?

Yes, you should be able to accomplish pretty much anything by constructing the appropriate CAML query. I posted a link on April 5, 2006 to a CAML Query Builder program that Patrick Tisseghem has written. I haven't actually used it, but it looks pretty cool.

Hi Matt,
I am new to Sharepoint as well as Infopath. Will you please explain me what is the purpose of this whole procedure when you have the ready made forms (AllItems.aspx,EditForm.aspx) given by SharePoint?
Also will you please explain me how to design a form with different controls instead of repeating table?

Hi Devyani and welcome to the forum!

The reason you would want to integrate this functionality into InfoPath are various. It all just depends on the situation. InfoPath provides much greater control over how to the form looks and behaves, so a good reason to implement in InfoPath is you want to add help screens or data validation.

As to the second question, (and I think this will also be for you dmhollis - so sorry about missing your post!).

First, I think you want to check out some of the great tutorials we have posted in our HowTo: Tutorials section. Here's a few to start:
http://infopathdev.com/howto/tutorials/default.aspx?i=7f693c75c5c94604b01bdfd3a1edaedc
http://infopathdev.com/howto/tutorials/default.aspx?i=4e038a7f3f5b443bbe4db49f86d95fba

Dave, yes, it sounds like you should be able to use just data connections so far. If you want, you can put several groups into one XML file and then populate your drop-downs from the seperate groups (kind of like seperate data connections).

As for creating a solution using the technique described in the HowTo except displaying the input fields in regular form controls instead of a repeating table, follow these steps:
1. Construct an XML document that contains enough nodes to store all of the fields you want to add to SharePoint.
2. Add this document as a secondary data source to your form. (Note that this document is in addition to the CAML template that should already be connected to your form).
3. Build the form however you want it to look using the fields from the secondary data source to take input.
4. Upon submission you can read the fields from the secondary data source and programmatically add the appropriate rows to the CAML template and then submit.

This is kind of complicated, but I hope you can understand! If you have any questions, feel free to ask!

Hi Matt,
Thanks for your reply. I was trying to create a simple form to insert data into a custom list. After submitting the form I get message that the form has been submitted successfully but nothing is getting inserted into the list.Why is that so?

Hi Matt,

Thanks for the reply. I have no problems with setting up my secondary data sources and implementing the form... it all comes down to setting up the CAML to send to the database. Your posts have been very helpful... but it looks like I can't escape working out the code to get this to submit properly. I'll keep at it an let you know when I wrestle out a solution. :)

Thanks again,
Dave

* * This for Devyani: I ran into similar problems... and it came down to trying to submit incorrect data for the database field type. ( IE.. text instead of numeric ) I solved my problem by setting up a dropdown list with the data type I wanted them to submit.

Hi Matt & Dave,
Thanks to both of you for your suggestions! I tried submitting data to custom list but nothing was actually getting inserted. I read somewhere that there is a bug in the upgrade mechanism that made Web services not work correctly.To fix this issue you need to remove stssoap from the global assembly cache. I am trying to do this with web part now.(still I need to use web service but at least I don't need to worry about field controls and datatypes)Wish me luck!

Hm, I've never heard of that. I hope it fixes everything for you, good luck!