Data Connections

Re: Populating a field

Stavi — Fri, 15 Sep 2006 10:30:52 GMT

yeah the rules works ok for 4 names, but if it grows you will have to add a rule everytime a name gets added which I imagine will happen

The concat way avoids this by taking the name automatically

Re: Populating a field

ragav_in — Fri, 15 Sep 2006 10:14:59 GMT

Hey Stavi,

The first option has done it for me. Anyways I would try the second one also. Thanks once again for your effort.

Subramanian

Re: Populating a field

Stavi — Fri, 15 Sep 2006 10:14:26 GMT

You would have to add 1 rule per name, so thats probably not the best way

Use the concat way

Re: Populating a field

Stavi — Fri, 15 Sep 2006 10:10:19 GMT

I can think of two ways

I would leave email as a text field

Then add rules to the name field
If name = abc then set email = abc@mycomany.com

Or have email default value = concat(name, "@mycompany.com") and tick update when change

Populating a field

ragav_in — Fri, 15 Sep 2006 09:36:27 GMT

Hi all,

I have an InfoPath form which has for example two fields. One is a drop down with 4 names and other is a field for their e-mail ID.

Name:
abc
def
ghi
jkl

If I chose abc in the name field, my email field should be populated as abc@mycompany.com and if I chose def, then it should be populated as def@mycompany.com and so on....

Is this possible and if yes, how? Do I need to have a drop down list for the email ID also, or is it enough to have a text field?

Your help is highly appreciated and millions of thanks in advance.

Regards
Subramanian