AnsweredAssumed Answered

Calculation for field selection

Question asked by grapeboy on Mar 11, 2018
Latest reply on Mar 11, 2018 by beverly

I've had great success working out my FM app but am getting stuck with calculations.  I have a Field "Account Name" which is generated from the two fields of the last names of our contracted clients.  (Most clients are couples).

Calc is:  Last Name 1 & "/" & Last Name 2


I'd like to expand this capability so that the "/" character is not included if the Last Name 2 field is empty so I don't have account names e.g. "Smith/"


I'd also like the "Account Name" to be the "Company" field over the name of the person involved, if the contracted client is a company. There is a separate field for "Company".  I have tried Case and If functions but can't get it to work.