Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Solution to concatenate specific fields only

Topic Labels: Base design
205 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

I would greatly appreciate your help finding a solution to concatenate each of the following fields while ignoring fields which contain (just) the letter “X”. (I am using “X” to denote empty instead of leaving the filed empty).

FYI. This formula works for concatenating all fields while ignoring the blank ones.

IF({Login Companies}, " " & {Login Companies}) &
IF({Login Titles}, " " & {Login Titles}) &
IF({Login Persons}, " " & {Login Persons}) &
IF({Login Places}, " " & {Login Places}) &
IF({Login Differentiators}, " " & {Login Differentiators})

Many thanks!!!

0 Replies 0