2 Replies Latest reply on Jan 30, 2014 10:01 AM by wakinheimer

    Create email calculation

    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.