10 Replies Latest reply on Dec 2, 2016 10:49 AM by LoriE

    Need a Calculation to result in the first Letter of a field

    LoriE

      I am creating a field that will calculate the combination of two fields, but in the first field I only want the first letter.

       

      (Actions::Discipline(first letter only)) + ( Actions:: Item# )     the result would be the "Action#" field

       

      So the result would be:

       

                     First Field Name         Second Field Name     Third Field

                     Discipline                    Item#                              Action#

                     Architectural               .001                                   A.001

       

                    

       

      The field named "Discipline" is the field that contains a value list of what the action item pertains to.  ie;   Architectural, Structual, Mechanical, etc

       

      So the result which will be the Action #

      A.001 or

      S.001    (depending on what the discipline it is)

       

      Thank you