Newbie Questions

Re: Autopopulate Static Fields after a Drop Down Selection

PAWInfo — Thu, 09 Apr 2009 02:40:19 GMT

Thx mate!

The users love it. I appreciate the help!

PAW

Re: Autopopulate Static Fields after a Drop Down Selection

Jimmy — Thu, 09 Apr 2009 01:20:51 GMT

Hello again,

Glad everything went off without a hitch. Using ResponseEntity in the dropdown box should be fine as long as the values are unique (and it appears they are). You could also choose to use ResponseEntity as the Display field for the dropdown box, and Code as the Value field, which would allow you to keep the rest of your setup the way it is.

InfoPath controls are merely a visual representation of the data, while the data itself exists behind the scenes. So you could for example, have the dropdown box bound to the my:Code field while displaying the ResponseEntity value, have a text box/expression box bound to the same my:Code field and actually displaying its value, and have the my:TerminationResponseEnt field populated behind the scenes the same way as you're doing now, without actually binding it to a control.

Re: Autopopulate Static Fields after a Drop Down Selection

PAWInfo — Wed, 08 Apr 2009 23:19:13 GMT

Jimmy,

Got it! Thanks! Perfecto!

Now, what I was trying to do is a little more complicated than I thought.

So, 1st field works.

xdXDocument:GetDOM("RPS - Response Entity")/dfs:myFields/dfs:dataFields/d:tmpPW_RPS_CodeTables/@Code[../@Code = current()/../my:TerminationRespEnt]

2nd Field:

xdXDocument:GetDOM("RPS - Response Entity")/dfs:myFields/dfs:dataFields/d:tmpPW_RPS_CodeTables/@CodeShortName[../@Code = current()/../my:TerminationRespEnt]

3rd and so on would be just replacing the underlined info.

Again, thanks!

Is this possible:

If I make the drop down [my:TerminationRespEnt] actually --> Code + ' - ' + CodeDescription as ResponseEntity

Code is the key, but by using a concatenated column (ResponseEntity), can I still do it?

PAW

Re: Autopopulate Static Fields after a Drop Down Selection

Jimmy — Wed, 08 Apr 2009 05:18:42 GMT

Ok, thank you. Please try these steps:

Right-click a field whose value you want to auto-populate (e.g., the textbox to the bottom left of "Response entity") and choose Properties
Click the fx icon in the Default Value section
Click Insert Field or Group... and select the corresponding field in your secondary data source.
Check Edit XPath. The contents of the formula box should look something like this, though the underlined parts will differ:
xdXDocument:GetDOM("TestTable1")/dfs:myFields/dfs:dataFields/d:TestTable1/@Column1
Append the following to the end of that formula, replacing the underlined part with the appropriate value:
[../@Code = current()/../my:code]
The whole thing should look something like this:
xdXDocument:GetDOM("TestTable1")/dfs:myFields/dfs:dataFields/d:TestTable1/@Column1[../@Code = current()/../my:code]
Click OK several times and preview the form

That's the general idea. Please give that a try and let me know if you get stuck.

Re: Autopopulate Static Fields after a Drop Down Selection

PAWInfo — Wed, 08 Apr 2009 04:57:16 GMT

Duh!

Thx Jimmy.

Re: Autopopulate Static Fields after a Drop Down Selection

Jimmy — Wed, 08 Apr 2009 04:06:09 GMT

If you click the Options tab when entering a post on this forum, you can attach files to your post.

Re: Autopopulate Static Fields after a Drop Down Selection

PAWInfo — Wed, 08 Apr 2009 03:20:13 GMT

Okay, how can I show you the Form easily? <ALT> Print Screen into a .bmp file, but how does one get that into a post?

Or is there an easier way?

PAW

Re: Autopopulate Static Fields after a Drop Down Selection

PAWInfo — Wed, 08 Apr 2009 03:09:30 GMT

Yes, exact same source.

SQL in Data Connection:

SELECT Code, CodeShortName, CodeLongName, CodeDescription, CodeStartDate, CodeEndDate,

Code + ' - ' + CodeDescription as ResponseEntity

FROM dbo.tmpPW_RPS_CodeTables

WHERE CodeTableClassName = 'Response Entity'

AND (CodeEndDate is null OR CodeEndDate > getdate())

ORDER BY Code

Dropdown uses ResponseEntity.

So Something like this below:

(No luck on getting my picture into this Forum.)

As you can see, I have the drop down working.

PAW

Re: Autopopulate Static Fields after a Drop Down Selection

Jimmy — Wed, 08 Apr 2009 02:43:29 GMT

Are the other five fields coming from the same data source as the codes? If so, could you make a simple diagram of how the source is structured?

Will this be in a repeating table/section, or will there just be one section like this in your form?

Autopopulate Static Fields after a Drop Down Selection

PAWInfo — Wed, 08 Apr 2009 02:19:33 GMT

Hello,

I have a data connection that goes to a Code Table which allows the user to select the code they want to change.

This part I have working fine. They select the code in the drop down no problem, from a list of valid codes from our database.

What I want to happen, is the 6 fields below get populated based on the selection of the code so the user can see the

fields below.

Code Short Name Long Name Description Start Date End Date

So, my question is, if the user selects a code from the drop down box, how can I populate these 6 fields above based on the code they select.

PAW