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.