Newbie Questions

Re: Automatic email Generation from Infopath form

donstephen — Mon, 30 Jun 2014 10:25:19 GMT

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.

Re: Automatic email Generation from Infopath form

doppino — Fri, 27 Jun 2014 09:58:32 GMT

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

Re: Automatic email Generation from Infopath form

donstephen — Fri, 27 Jun 2014 07:47:52 GMT

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,

Automatic email Generation from Infopath form

doppino — Wed, 25 Jun 2014 08:45:55 GMT

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

first letter of field name, all field surname