Newbie Questions

Re: Populate a field based on another field's value

Greg Collins — Thu, 01 Nov 2007 16:29:45 GMT

Take a look at some of these blog posts -- they use fitlers and can give you walkthroughs to help figure it out:

http://www.infopathdev.com/search/SearchResults.aspx?q=populate&g=6

Re: Populate a field based on another field's value

dhoffkins — Wed, 31 Oct 2007 21:28:21 GMT

Hello-

I'm very new to Infopath and I'm trying achieve the same result; populating a field based on another field's value. I've connected to my secondary data source, which is a table with all the user information, but I cannot figure out how to use filters to make this happen. Any tips for complete noob?

Thanks!

Re: Populate a field based on another field's value

Greg Collins — Tue, 30 Oct 2007 20:53:41 GMT

Great! Glad to hear back that you got it working!

Re: Populate a field based on another field's value

heath3106 — Mon, 29 Oct 2007 18:32:03 GMT

Worked like a charm. Thanks for the quick response.

Re: Populate a field based on another field's value

Greg Collins — Mon, 29 Oct 2007 18:06:28 GMT

You can do this with rules. Your rule needs to use "filters" to get the correct row from the 2DS (secondary data source).

So if you have a table with a row like ["Fred Flinstone", "Quarry Worker", "Fred@Flinstone.com"], your rule would look up the 2DS row where the Employee Name matched the name selected in the field that the drop-down was attached to (i.e. the filtering feature lets you do that compare) and then select the email from that row to assign to the other field.

Populate a field based on another field's value

heath3106 — Mon, 29 Oct 2007 13:01:50 GMT

I have a secondary data source which consists of a table. In the table are three values; Employee Name, Employee role, and Employee Email. I have a drop down where the form submitter selects to assign the form to an employee. I have a field that I want to contain the employee email address based on the name chosen in the drop down. I'm not very handy with Jscript. Is there a way to do this with rules?

Thanks.