Solved
Formula if with conditional
Hello QB Community I am trying to build a formula combining more than one variable Variables: First Name Middle Name Last Name Preferred First Name Preferred Middle Name Preferred L...
- Try something like this in a formula rich text field
var text firstname = If([Preferred First Name]="", [First Name], [Preferred First Name]);var text middlename = If([Preferred Middle Name]="", [Middle Name], [Preferred Middle Name]);var text lastname = If([Preferred Last Name]="", [Last Name], [Preferred Last Name]);
$firstname & " " & $middlename & " " & $lastname
------------------------------
Everett Patterson
------------------------------
