Skip to main content
Solved

Formula if with conditional

  • September 17, 2019
  • 0 replies
  • 35 views
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)
------------------------------

Best answer by EverettPatterso

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
------------------------------
This topic has been closed for replies.

EverettPatterso
Forum|alt.badge.img+10
  • EverettPatterso
  • Quickbase Alumni
  • Answer
  • September 17, 2019
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
------------------------------
    Terms & ConditionsAccessibility statement