InfoPath Dev

I am very new to using InfoPath and using formulas.  Is there any tutorials on formulas in InfoPath?

I want to create a formula that will take the first letter in the firstName field and merge it with the entire lastName field, all in lower case.

Can anyone help with this?

Hi and welcome to InfoPathDev forums!

You'll need to use substring to get the first letter in the FirstName and then combine the result to the value of your LastName using concat, something like: concat(substring(FirstName, 1, 1), LastName)

 Jo Ann, thank you very much for the assistance as that did work.

The only question is how can I get the result all in lower case.

This is what I tried but does not work:  

concat(translate(substring(firstName, 1, 1 ),  “abcdefghijklmnopqrstuvwyxz” ,“ABCDEFGHIJKLMNOPQRSTUVWYXZ”)), translate(substring(lastName, “abcdefghijklmnopqrstuvwyxz” ,“ABCDEFGHIJKLMNOPQRSTUVWYXZ”, ))

Try this: translate(concat(substring(FirstName, 1, 1), LastName), "ABCDEFGHIJKLMONPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz").

Hope that works! =)

 Thanks again Jo Ann, that was the solution I was looking for.

You're welcome, glad it worked!

I'm trying to do something similar.  I would like to get the result of First Initial of Last name combined with a seperate field of last 4.  This is the fomula I am using:  concat(substring(@PATIENT_LAST_NAME), 1, 1) @Last_4_of_Patient_SSN

 This is the error I receive:

Expected value type: end-of-string

Actual value: ..
concat(substring(../@PATIENT_LAST_NAME), 1, 1) -->..<--/@Last_4_of_Patient_SSN