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


      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