AnsweredAssumed Answered

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

Question asked by LoriE on Dec 2, 2016
Latest reply on Dec 2, 2016 by 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