Use Different Field if Blank

[Gregster1234]

Here's an easy one I just need to use the "Full Name" field if the "First Name" field is blank. It contains Companies and it shows up as "Dear ,"

Thanks,

[Dan Korn]

return Field("First Name") || Field("Full Name");

[Gregster1234]

It works perfect, Is there a way to apply Proper Case to this also?

[Dan Korn]

It works perfect, Is there a way to apply Proper Case to this also?

return ToTitleCase(Field("First Name") || Field("Full Name"));

Although see some of my many caveats about "proper case." A computer algorithm can't always programatically determine the "proper" casing for a name, especially since capitalization can be arbitrary. It's best to have the data in the proper format in the first place.