Newbie Questions

Re: InfoPath2010 List

Mike Schweiss — Tue, 12 Mar 2013 18:44:03 GMT

yeah i see that. i just have to figure out how to find it & fix it. thanks for all your help...

Re: InfoPath2010 List

Hilary Stoupa — Tue, 12 Mar 2013 18:31:39 GMT

One of your fields is relying on the data connection SAP Cost Center which was removed.

Re: InfoPath2010 List

Mike Schweiss — Tue, 12 Mar 2013 18:19:24 GMT

when i try to preview it i got an error.

InfoPath
A call to XDocument.GetDOM failed. The DataObject "SAP Cost Center" does not exist.

Error occurred during a call to property or method 'GetDOM'.

any thoughts?

Re: InfoPath2010 List

Hilary Stoupa — Tue, 12 Mar 2013 17:41:08 GMT

Okay - I set the Cost Center drop down to use the data connection and set the value and display to the Cost Center field in the data connection. I set the Department dropdown with a filter to only show rows where Cost Center is equal to the selected Cost Center. Save the linked form locally, then right click and select design to take a look. To see the filter, go to the Drop Down Properties (right click menu) on the Department dropdown. Click the Select XPath button next to the Entries field. Click the Filter Data button and you'll be able to take a look at the filter I used. Hope this helps!

Re: InfoPath2010 List

Mike Schweiss — Tue, 12 Mar 2013 17:14:51 GMT

Ok, here it is with only 1 data connection. i am so curious to see how this works. Thank you so much...

Re: InfoPath2010 List

Hilary Stoupa — Tue, 12 Mar 2013 16:33:22 GMT

You have a single SharePoint List with this info? I'd have the data connection include all the fields you need - just one data connection. Can you change your form so it has a single data connection to that list with all the fields you need? Then I can help you set it up.

Re: InfoPath2010 List

Mike Schweiss — Tue, 12 Mar 2013 16:23:56 GMT

I hope this isn't too bad, i have just started working with Infopath. kind of got thrown into it. but i enjoy it. so i apreciate any help... the fields are SAPcost center & SAP Department.

Thank you!!

Re: InfoPath2010 List

Hilary Stoupa — Tue, 12 Mar 2013 15:49:47 GMT

Can you attach your form under the Options tab? I might be able to give you a quick hand. :)

Re: InfoPath2010 List

Mike Schweiss — Tue, 12 Mar 2013 14:56:04 GMT

Patrick i appreciate your help. i have gotten further. but when i choose a cost center the department doesn't populate automatically. my list is a sharepoint access list. with 3 columns. 1 is the ID column which will reference the row, the second is Department & the 3rd is cost center. i want ID of row 2 to reference the department & cost center on row 2. i thought i had it figured out with your help but i am missing something. now these are drop down lists with multiple rows. not sure if that ,matters.... one other question, should i have a data connection for each of those options or just one? right now i have a data connection for department, cost center & id.

Thanks again

Re: InfoPath2010 List

Patrick Halstead — Sat, 09 Mar 2013 20:22:11 GMT

This is easy with default value filters. Set a default value on the Cost Center by double clicking on the field in the data source taskpane and clicking on the Fx button. Insert the field from the secondary data source (the list you are pulling from) and specify a filter on it where the Department in the secondary data source equals the selected department in the main data source.

To display multiple filtered items in a dropdown, right click the dropdown control and select the field from your secondary data source and you should see a filter button. Same idea here as above.

InfoPath2010 List

Mike Schweiss — Fri, 08 Mar 2013 20:10:00 GMT

Beginner here, i have an infopath list with 3 columns, 1 is ID, the other is Department & the other is Cost center. i am trying to make the form so when you choose the cost center it autopopulates the department field. i have the list setup in share point & i have to data connections, one to the departments & one to the cost center. now the ID corresponds with the Department & the Cost Center. i would think i could filter it to say if you choose Cost Center xxxxx then the corresponding Cost Center ID would reference the Department.

Any HELP!!!! would be greatly appreaciated..... Thanks in advance...

Mike