Error: Please use field(...) because it starts with an upper case letter

#1

Hi
I am trying to create an email field. I created the formula:
concat(FirstName,".",LastName,"@",“google.com”)
But I keep getting the error message:
error: Please use field(‘FirstName’) to access FirstName because it starts with an upper case letter.

So I have tried with the formats:
“FirstName”
‘FirstName’
(‘FirstName’)

but nothing works. What must I do?

#2

You want:

concat(field('FirstName'), ".", field('LastName'), "@", "google.com")

The underlying reason you need to use field() when names are capitalized is that Ruby assumes all capitalized variables are constants or classes.

1 Like
#3

It works, you are a genius! Thanks!