InfoPath Dev

 Hi to all,

I'm new with infopath. I'm trying to create a simple form: name, surname, email. The field  email should be read only and autogenerated with a formula.

Eg: 

Name: John

Surname: Lennon 

email: jlennon@mycompany.com

With Concate i succesfully aggregate all the field toghether, but I need only the first letter of the first field

someone can help ? 

thanks

D. 

 first letter of field name, all field surname

Hi D,

I would suggest using a substring function to extract the first letter from the first name. Your formula would look similar to this:

concat(substring(Name, 1, 1), Surname, "@mycompany.com")

Hope this helps,

Hi Don Stephen,

thanks for the reply. My Name and email fields are obviously a text fields, but when i paste your formula in the email field, it asks for a number value ? 

Here is the error message 

Expected value type: ,

Actual value: number
concat(substring(Name, 1. -->1<--), Surname, "@mycompany.com")

Could you  explain me why ?

Thanks

D. 

Hi D,

Upon reviewing your formula, I can see that a period (.) is used instead of a comma (,), which is why you are receiving this error. Hope this helps.