14 Replies Latest reply on Mar 9, 2012 9:15 AM by timwhisenant

    auto entering data vs calculation

    wallybuch

      I would like to have a field which can easily be done with a calculation. I am trying to concatenate a husband first name & a spouse first_name & a Last_Name. Using a calculation field, it is easy to do this, but the result cannot be edited in the event of a change of marital status. Another problem is that some contacts are single and if I concatenate the contact first_name and there is no spouse first_name, it creates problems.

       

      So how could I do an auto enter type of concatenation and have it ignore those contacts who do not have a spouse first name and still be editable should things change?

       

      thanks in advance

       

      wally buch