Infopath force population of fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Welchs - 31 Mar 2008 14:59 GMT

I have a form that I am trying to force populate related data fields. It is
not working. The force population fields are listing the first row in the
SharePoint no matter what is selescted in the first field.

In a set of 5 fields, the first field is selected from a drop down list.
(this is populated by SharePoint) Based on this selection, the next 4 fields
should populate with information from SharePoint (same list) related to the
selection.

Example: Johnny is selected, his age, weight, dob, and height should force
populate from the list. They are not.

Can anyone help?
The formula for "Get Related Data" is currently-
condition: Plan_Name=SP_Plan Name
Set a field's value: .=@BCP_Vendor_Name[.=current()]
VIN1=@BCP_Vendor_Name=current()]
xpath is not checked

Thanks, I am in a project crunch.
S.Welch

Reply to this Message

Clay Fox - 31 Mar 2008 18:16 GMT

I am guessing it has to do with the current function you are trying to use.
current() can be use to specify an Xpth but not on its own.

Is this within a repeating section? I would think the filters would be fine
without using current.

Are you using a setfield action on the dropdown or using defaults on the
other fields?

Try going to http://www.infopathdev.com and search on current() to get some
examples of how to use it.

Signature

Clay Fox / Microsoft InfoPath MVP
www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To,
Experts, Forum

> I have a form that I am trying to force populate related data fields. It is
> not working. The force population fields are listing the first row in the
[quoted text clipped - 17 lines]
> Thanks, I am in a project crunch.
> S.Welch

Reply to this Message

Welchs - 31 Mar 2008 18:38 GMT

Clay,
Thank you for responding. This is not in a repeating section. This is just
a table with fields coming from a SP list.

If I checked the x path box would this work?

I am using setfield in the Get related data rule attached to the drop down
properties.

What filters would be fine without using current ().? Your saying go from
this:

Set a field's value: .=@BCP_Vendor_Name[.=current()]
VIN1=@BCP_Vendor_Name=current()]

To This:
Set a field's value: .=@BCP_Vendor_Name

> > VIN1=@BCP_Vendor_Name

Thanks,
Stacie

> I am guessing it has to do with the current function you are trying to use.
> current() can be use to specify an Xpth but not on its own.
[quoted text clipped - 29 lines]
> > Thanks, I am in a project crunch.
> > S.Welch

Reply to this Message

Clay Fox - 01 Apr 2008 01:36 GMT

If you have a list which returns
ID Name Description

You would have a FormID, FormName, and FormDesc in your main data source

You would have a dropdown, bound to FormID, which used the ID field as its
source.
Then add a rule that would set FormName to Name[FormID = ID] and set
FormDesc with Description[FormID= ID]

So you would use a filter to get the appropriate row of data.

Hope that helps.
Otherwise email me.
http://www.infopathdev.com/members/clayfox.aspx

Signature

Clay Fox / Microsoft InfoPath MVP
www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To,
Experts, Forum

> Clay,
> Thank you for responding. This is not in a repeating section. This is just
[quoted text clipped - 51 lines]
> > > Thanks, I am in a project crunch.
> > > S.Welch

Reply to this Message