Forum Discussion

Data_SystemAnal's avatar
Data_SystemAnal
Qrew Cadet
6 years ago
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...
Formulas and functions
  • EverettPatterso's avatar
    EverettPatterso
    6 years ago
    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
    ------------------------------
EverettPatterso's avatar
EverettPatterso
Qrew Captain
6 years ago
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
------------------------------
Data_SystemAnal's avatar
Data_SystemAnal
Qrew Cadet
6 years ago
It worked beautifully. 

Thank you so much

Edson

------------------------------
Data (Administrator)
------------------------------