Multi-Field Formula--If multiple columns IsEmpty then populate those fields with new data

Question

Hello,

I'm trying to check existing address fields and bring in new data ONLY if all of the existing address fields are null/empty. Would the multi-field formula be the best option for this case or is there another tool?

This is what I am trying to accomplish and I've also attached the workflow:

IF IsEmpty([address_1]) AND IsEmpty([address_2) AND IsEmpty([city]) AND IsEmpty([state]) AND IsEmpty([zip])

THEN [n_address_1] AND [n_address_2] AND [city] AND [state] AND [zip]

ELSE [_CurrentField_]

ENDIF

all_prod_address_null_then_new_data.yxmd

markcurry · Accepted Answer

Hi @vujennyfer , if you are just looking to bring in the rows with no information in any of the data fields, I think a Filter would work, just using the Custom filter option, with the formula ...

IsEmpty([address_1]) AND IsEmpty([address_2]) AND IsEmpty([city]) AND IsEmpty([state]) AND IsEmpty([zip])

Hope that helps, Mark