Form Design with query and update function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Art - 01 May 2007 21:21 GMT

I am working on a travel profile form and have a question on how to do a
database retreival and an update in the same form.

I have a web service that pre-populates name and email based on Active
Directory. That event happens on form load.

When email is populated, I would like that to trigger a query against a
profile database and return fields from a database. (e.g., field 1, field2,
etc)

I set a rule on the email field to query the database and then set one of
the fields (field1) to the query value but it does not work.

Eventually, the user will then be able to update those fields, if necessary,
and resubmit the record to the database with the updates.

I have the WDSL working but I cannot get the form to automatically retrieve
the data from the database (SQL in my case).

In one word - HELP!!!

Reply to this Message

Art - 02 May 2007 14:32 GMT

Let me add to this today.

I was able to get the issue to run on one field and one field only.

I use email as the primary key. I set the field email via WSDL from AD and
then search my database for matching email addresses.

When I went to populate the field First Name, I set a rule on email to say
set the value of First Name based on this data selection and filter:

.../../dfs:queryFields/q:tblTravelProfile/@FirstName[../../../my:TravelerInfo/my:Email = ../../../dfs:dataFields/d:tblTravelProfile/@EMail]

And the Field of First name gets populated correctly.

When I add a second stop to the rule to set Last Name I used the exact same
data selection:

.../../dfs:queryFields/q:tblTravelProfile/@TravelFirstName[../../../my:TravelerInfo/my:Email = ../../../dfs:dataFields/d:tblTravelProfile/@EMail]

And the field of last name will not populate.

I even tried to set it up as a second rule rather than a second step in the
same rule with no luck.

HELP!!!

> I am working on a travel profile form and have a question on how to do a
> database retreival and an update in the same form.
[quoted text clipped - 16 lines]
>
> In one word - HELP!!!

Reply to this Message

Paul - 06 Jun 2007 20:34 GMT

Hi Art,

Care to share the code for how you're calling the webservice and populating
the fields in the InfoPath (2007?) form? Are you using VS.net code-behind or
doing this in the InfoPath form itself?

We're just starting out on the same path you are on... so this is gratuitous
begging :>)

Any help would be appreciated.

Paul

> I am working on a travel profile form and have a question on how to do a
> database retreival and an update in the same form.
[quoted text clipped - 16 lines]
>
> In one word - HELP!!!

Reply to this Message