Concatenate text fields with calculated value - continue even if a field blank

[roattw]

I have a calculated field that concatenates an address and uses the CHAR13 for a hard return, which allows for an address to be print label ready.

Instead of this:  First_name, Last_name, Degree  111 address, city, State zipcode

I get this:

First_name Last_name, Degree
111 address
City, State, Zipcode

Works well EXCEPT that if any of those fields are blank it wont complete the concatenation/calculation.  It wants all or none.  I tried ISNULL but in this context, the formula doesn't validate - I think because I cant get the syntax correct with the LEFT command.

'[@field:First_Name]'+' '+'[@field:Last_Name]'+', '+LEFT([@field:Degrees] ,2)+CHAR(13)+'[@field:Address]'+CHAR(13)+
'[@field:City]'+', '+'[@field:State]'+' '+'[@field:Zipcode]'

As always, many thanks!

[futurist]

Hi @roattw,

I tried a similar setup and it seems to work fine on my end, not sure why it isn't working for you. I didn't even need to use the ISNULL function, but have you tried putting each field in an ISNULL function, instead of putting all of them together in one ISNULL?

[cheonsa]

Hi @roattw,

I also tried your formula and it is working as expected. The LEFT command is working  fine as well. As futurist mentioned, you can use ISNULL function for each fields.

For more details, you can check this link: https://howto.caspio.com/function-reference/