Skip to main content

I have four name fields that I wish to concatenate.


First Name-1, First Name-2, Last Name-1 and Last Name-2.


Objective:


If First Name-2 and Last Name-2 two are both black, return First Name-1 Last Name-1

If First Name-2 is not blank and Last Name-2 is blank, return First Name-1 & First Name-2 Last Name-1

If both First Name-2 and Last Name-2 are not blank, return First Name-1 Last Name-1 & First Name-2 Last Name-2


I am new to Airtable.


Thanks

Hi Gary,


Sounds like you’re creating a wedding mailing list or similar. I would use nested IF logic: https://support.airtable.com/hc/en-us/articles/221564887-Nested-IF-formulas


Change the field where you want the concatenated result to a formula and try this one:


IF({Last Name 2} = BLANK(), {First Name 1} & " " & {Last Name 1}, IF({Last Name 1}={Last Name 2}, {First Name 1} & " & " &{First Name 2}& " " & {Last Name 1}, {First Name 1} & " " &{Last Name 1} & " & " &{First Name 2} & " " &{Last Name 2}))

Looking at your criteria, I see some interesting patterns that can be used to simplify the formula a bit.



  1. First Name-1 is always there, so we can start the formula with that no matter what.

  2. Last Name-1 is always there, though it may have First Name-2 before it based on one condition.


With those in mind, here’s an alternative formula:


{First Name-1} &

IF(

    AND({First Name-2}, NOT({Last Name-2})),

    " & " & {First Name-2}

) &

" " & {Last Name-1} &

IF(

    AND({First Name-2}, {Last Name-2}),

    " & " & {First Name-2} & " " & {Last Name-2}

)

Looking at your criteria, I see some interesting patterns that can be used to simplify the formula a bit.



  1. First Name-1 is always there, so we can start the formula with that no matter what.

  2. Last Name-1 is always there, though it may have First Name-2 before it based on one condition.


With those in mind, here’s an alternative formula:


{First Name-1} &

IF(

    AND({First Name-2}, NOT({Last Name-2})),

    " & " & {First Name-2}

) &

" " & {Last Name-1} &

IF(

    AND({First Name-2}, {Last Name-2}),

    " & " & {First Name-2} & " " & {Last Name-2}

)


Thank you VERY much.


Gary Nelson

Reply


Terms & Conditions