I am trying to create a value list for a drop down list that shows a list of names, schools or teams. At the moment I have it working fine using a field with the following calculation...
If ( IsEmpty ( LName ) ; SchoolName ; LName & ", " &"" & FName )
But now I need to add the team into that scenario. They will never have more than one of those fields filled in, it's one or the others. But I'm just not sure how to properly write it adding another option because when I search for help some plases say use the case function instead.
What would be the correct way to write it adding if last name are empty use the team?
As always, thank you SO much for the help.
Try using Case:
Case( not IsEmpty ( School ) ; SchoolName ;
not IsEmpty ( Team ) ; TeamName ;
LName & ", " & FName )