How do I auto fill a text box from a non-repeating cascading drop.

[Karyl]

--
Karyl

 

[Karyl]

Let's try this again!! How do I auto fill a text box from a non-repeating
cascading drop down list. I'm using an xml data source list. I have
searched everywhere for a solution to this seemingly easy question. I have
tried rules, filters etc. but none seem to work. What am I doing wrong?

 

[Karyl]

For example I have a non-repeating drop down list that is using an xml data
source. Let's call this field Requester Name. I also have a text box named
Requester Email Address. I want the text box to auto fill when the requester
selects their name from the drop down list. Both fields are using the same
xml data source. Thank you so much.

Please provide an example of what you are trying to do... something like: I select a choice from the last drop-down list in a non-repeating cascading list, and then I want to populate a text box with a value associated to that selection.

Thanx!

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



Let's try this again!! How do I auto fill a text box from a non-repeating
cascading drop down list. I'm using an xml data source list. I have
searched everywhere for a solution to this seemingly easy question. I have
tried rules, filters etc. but none seem to work. What am I doing wrong?

 

[Karyl]

Thank you - I'll give that a try.

You would use a rule on the drop-down list that would populate the text box based on the selected value in the drop-down list.

The rule would follow the convetion of
xml: = secondary data source
my: = main data source


Select xml:RequesterEmailAddress where xml:RequesterName = my:RequesterName

The where clause means that you are using a filter as part of the selection.

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



For example I have a non-repeating drop down list that is using an xml data
source. Let's call this field Requester Name. I also have a text box named
Requester Email Address. I want the text box to auto fill when the requester
selects their name from the drop down list. Both fields are using the same
xml data source. Thank you so much.

Please provide an example of what you are trying to do... something like: I select a choice from the last drop-down list in a non-repeating cascading list, and then I want to populate a text box with a value associated to that selection.

Thanx!

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



Let's try this again!! How do I auto fill a text box from a non-repeating
cascading drop down list. I'm using an xml data source list. I have
searched everywhere for a solution to this seemingly easy question. I have
tried rules, filters etc. but none seem to work. What am I doing wrong?

 

[Karyl]

Well I'm getting closer - At least now I have data in the text box - However
it is the requester name not the requester email address.

My rule is email[name=requesterName]

This should equate to xml:email where xml:name = my:requesterName.

What did I do wrong?

Thank you for being so very patient.

You would use a rule on the drop-down list that would populate the text box based on the selected value in the drop-down list.

The rule would follow the convetion of
xml: = secondary data source
my: = main data source


Select xml:RequesterEmailAddress where xml:RequesterName = my:RequesterName

The where clause means that you are using a filter as part of the selection.

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



For example I have a non-repeating drop down list that is using an xml data
source. Let's call this field Requester Name. I also have a text box named
Requester Email Address. I want the text box to auto fill when the requester
selects their name from the drop down list. Both fields are using the same
xml data source. Thank you so much.

Please provide an example of what you are trying to do... something like: I select a choice from the last drop-down list in a non-repeating cascading list, and then I want to populate a text box with a value associated to that selection.

Thanx!

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



Let's try this again!! How do I auto fill a text box from a non-repeating
cascading drop down list. I'm using an xml data source list. I have
searched everywhere for a solution to this seemingly easy question. I have
tried rules, filters etc. but none seem to work. What am I doing wrong?

 

[Karyl]

Never mind - I GOT IT!!!! I was putting the rule on the text box not the
drop down as instructed!!! YIPPEE!!!!!!

Thank you - Thank You!!

 

[Chieftonw]

You had mentioned that this would a little harder with a repeating table.
However that is what I am trying to do. In a repeating table, how can I have
the selection from one drop down box fill several over text boxes? Is it
better for my source for the drop down box to be a database or excel file?

jeff

is the my:requesterName in a repeating table/section? If so that requires a little more complicated effort.

Also if you have more than one identical xml:name, then this filter will only grab the first one. There's not much to do about that, the names have to be unique.

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



Well I'm getting closer - At least now I have data in the text box - However
it is the requester name not the requester email address.

My rule is email[name=requesterName]

This should equate to xml:email where xml:name = my:requesterName.

What did I do wrong?

Thank you for being so very patient.

You would use a rule on the drop-down list that would populate the text box based on the selected value in the drop-down list.

The rule would follow the convetion of
xml: = secondary data source
my: = main data source


Select xml:RequesterEmailAddress where xml:RequesterName = my:RequesterName

The where clause means that you are using a filter as part of the selection.

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



For example I have a non-repeating drop down list that is using an xml data
source. Let's call this field Requester Name. I also have a text box named
Requester Email Address. I want the text box to auto fill when the requester
selects their name from the drop down list. Both fields are using the same
xml data source. Thank you so much.

Please provide an example of what you are trying to do... something like: I select a choice from the last drop-down list in a non-repeating cascading list, and then I want to populate a text box with a value associated to that selection.

Thanx!

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



Let's try this again!! How do I auto fill a text box from a non-repeating
cascading drop down list. I'm using an xml data source list. I have
searched everywhere for a solution to this seemingly easy question. I have
tried rules, filters etc. but none seem to work. What am I doing wrong?

: