MarkShnier__You
4 years agoQrew Legend
Re: Extract Initials
Try this
var text FirstName = If([PreferredFirstName]="", [FirstName], [PreferredFirstName]);
var text MiddleName = If([PreferredMiddleName]="", [MiddleName], [PreferredMiddleName]);
var text LastName = If([PreferredLastName]="", [LastName],[PreferredLastName]);
List(" ", Left($FirstName,1), Left($MiddleName,1), Left($LastName,1)
On your original formula, I suggest using
List(" ", $FirstName, MiddleName, $LastName) in case any of the three values are blank.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var text FirstName = If([PreferredFirstName]="", [FirstName], [PreferredFirstName]);
var text MiddleName = If([PreferredMiddleName]="", [MiddleName], [PreferredMiddleName]);
var text LastName = If([PreferredLastName]="", [LastName],[PreferredLastName]);
List(" ", Left($FirstName,1), Left($MiddleName,1), Left($LastName,1)
On your original formula, I suggest using
List(" ", $FirstName, MiddleName, $LastName) in case any of the three values are blank.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------