SharePoint Integration

Re: I need a form that automatically fills some fields and allows the user to input others...

AndyMoon — Mon, 02 Mar 2015 15:35:18 GMT

I'm not certain what did it, but I was able to get the form to work in Preview. Thank you so much for your help!

Andy

Re: I need a form that automatically fills some fields and allows the user to input others...

donstephen — Wed, 25 Feb 2015 20:34:31 GMT

The logic for querying data and setting values is correct. However there is some issue with the query and/or the query filter and I am unable to determine the issue from my end. Here is a video regarding Secondary Data Connections and Filters, or we could look into it for you if you want to purchase a support pack.

Regards,

Re: I need a form that automatically fills some fields and allows the user to input others...

AndyMoon — Wed, 25 Feb 2015 20:26:21 GMT

In addition, the debug section appears to be displaying the entire list.

Re: I need a form that automatically fills some fields and allows the user to input others...

AndyMoon — Wed, 25 Feb 2015 20:21:59 GMT

Odd, I went back into the last form you sent me, deleted the rule under field 1, and now the form is populating, but field1 isn't and the form is populating with information other than mine.

Re: I need a form that automatically fills some fields and allows the user to input others...

AndyMoon — Wed, 25 Feb 2015 20:14:37 GMT

I deleted that rule and also deleted one on the Admission-GradDegree field. Still, nothing in the GradDegree field on either the form or in the debug section.

Re: I need a form that automatically fills some fields and allows the user to input others...

donstephen — Wed, 25 Feb 2015 20:07:59 GMT

I've double checked the form and saw a rule under field1. Could you try to disable or delete that rule? It looks like it's the one causing the issue - setting the Admissions-GradDegree to a blank value.

Re: I need a form that automatically fills some fields and allows the user to input others...

AndyMoon — Wed, 25 Feb 2015 19:59:57 GMT

The debug section does have some values, just not for the GradDegree field. I see values for the First and Last Name fields, the PeopleSoftID, and the concatenated full name, in addition to some fields with default values set (Modified, Created, Program-Concentration, etc.)

Re: I need a form that automatically fills some fields and allows the user to input others...

donstephen — Wed, 25 Feb 2015 19:50:51 GMT

The CougarnetID In the main data source will not get a value. At the Query Items rule on form load, The rule here is setting the CougarnetID for the Query Fields of the data connection (this filters the query based on the current user's ID). I'd like to ask if the debug section I added below contain any values?

Re: I need a form that automatically fills some fields and allows the user to input others...

AndyMoon — Wed, 25 Feb 2015 19:36:39 GMT

In the newest posted form, the CougarnetID field never gets set to the field1 value. I have been successful at using the Username() function to directly set the CougarnetID field directly, "field1" was a field I added for testing purposes, it doesn't exist in the list, just on the form.

In addition, the GradDegree field never gets set to the list value, but I suspect this is the result of the CougarnetID field not being set.

Re: I need a form that automatically fills some fields and allows the user to input others...

donstephen — Wed, 25 Feb 2015 19:17:57 GMT

Thank you for the additional information. At the Form Load rules, I have added 2 new rules. The first one queries the items from the Program Student Information1 data connection based on the field1 data. The issue I think is with the set value which should not be filtered. Please check this form instead.

I have added a debug section below to see if the queried data returns any value/s.

Re: I need a form that automatically fills some fields and allows the user to input others...

AndyMoon — Wed, 25 Feb 2015 19:13:20 GMT

I found one issue, the line where you tried to grab the Admissions-GradDegree field was set to compare field1 to PeopleSoftID instead of CougarnetID. Sadly, I changed this but still got no data pulled.

Re: I need a form that automatically fills some fields and allows the user to input others...

AndyMoon — Wed, 25 Feb 2015 19:04:45 GMT

I looked at what you did and it would appear that the condition was never met as the CougarnetID field never got set to the value of field1. The Username() function pulled the right userID and displays it as I expect, but the CougarnetID field doesn't get the same value when I preview.

Re: I need a form that automatically fills some fields and allows the user to input others...

AndyMoon — Wed, 25 Feb 2015 19:00:32 GMT

Don,

I opened in Design mode, which brought it up as "Form1," I previewed and the Admissions-GradDegree did not get populated, though field1 does get populated by using the Username() function.

Re: I need a form that automatically fills some fields and allows the user to input others...

donstephen — Wed, 25 Feb 2015 18:53:30 GMT

Kindly download the XSN, right click and open in design mode, and preview (click F5). That should do the trick.

Regards,

Re: I need a form that automatically fills some fields and allows the user to input others...

AndyMoon — Wed, 25 Feb 2015 18:45:21 GMT

Your form gives me a domain permission error and InfoPath won't allow me to open it. Is there a security setting in InfoPath I need to change?