username() function

Question

Hello, I have a form that uses the userName() function.

our user names are in the  FirstName.LastName format. I would like to seperate the users name in two different field

IE: field1 = FirstName, field2 = LastName.

Answer 1

Thanks you this works great

i would also like to change the first letter of this field to be in upper case

this is the formula i have

concat(substring(translate(userName(), "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 1, 1), substring(userName(), 2, string-length(userName()) - 1)) (this formula works fine)

substring-before(userName(), '.')

I would like the first letter to be upper case and if possible put have the first letter of a hypenated name in upper case

ie:

FirstName field= First-Name

LastName field = Last-Name

hope you can help me with this

Answer 2

Use default value formulas:

FirstName: substring-before(userName(), '.')

LastName: substring-after(userName(), '.')