AnsweredAssumed Answered

Create email calculation

Question asked by wakinheimer on Jan 30, 2014
Latest reply on Jan 30, 2014 by wakinheimer

Title

Create email calculation

Post

     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:

     jsmith@somecompany.com

     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.

Outcomes