Create email calculation
Using FileMaker Pro 11. We have a calculated email creation convention that I'd like to duplicate in FileMaker. I have a list of employees with their first and last names in separate fields. To create an address, we use the first letter of the first name added to the their last name, followed by the email protocol. Such as:
I know there must be a simple calculation that could pull the first letter from FirstNameField and add it to LastNameField then add "@somecompany.com" but I am not understanding how to calculate the "get first character of FirstNameField" part of the equation. I think I've even seen it in this forum before, but I can't find it today.
Thanks for your help.