use the data in several fields on form as email subject

L

Lewis Scott

How can I get infopath to use the data in several fields as the subject line
when the form is submitted via email. I cannot seem to get the correct
syntax. I have tried using the commas, spaces, parenthesis, and any
combination of those to seperate the word but only get errors.
 
B

Ben Walters

Hey Lewis,
try using
concat(field1,field2,field3, " ", field4)

Hope this helps

Cheers
Ben Walters
 
L

Lewis Scott

Thanks Ben! I knew it had to be something simple. Thanks for the help. It
works but still runs everything together. How do I get a space between the
fields? Sorry if this seems like a stupid question.
 
B

Ben Walters

Hey Lewis,
If you put double quotes with a space in your concat statement that will
register as a space so if I had an XML dataset as follows

<Field1>Ben</Field1>
<Field2>Walters</Field2>

then the expression
concat(Field1," ", Field2)

would evaluate to Ben Walters

Hope this helps

Cheers
 
L

Lewis Scott

Thanks again! Your a huge help. Thanks for the contribution. I owe you a case
of beer or something!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top