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 Last Name
I want to show the Prefered Names when student have one otherwise the Legal name
------------------------------
Data (Administrator)
------------------------------
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 Last Name
I want to show the Prefered Names when student have one otherwise the Legal name
------------------------------
Data (Administrator)
------------------------------
- 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
------------------------------
