I imagine this is pretty common, but haven’t figured this one out yet as I’m struggling a bit with understanding exactly how the CONCATENATE feature works.
I have a flow that regularly exports data from an accounting application into Airtable. The info always exports fields seperately as:
- Ship Line 1
- Ship Line 2
- Ship Line 3
- Ship Line 4
- Postal Code
I want to combine it into something a bit easier to display on the page designer. I’d like it to look very similar to how a long text would look where I can insert line breaks, and in the event Ship Line 3 and 4 are not present, omit them to eliminate unnecessary spacing.
Ship Line 1
Ship Line 2
Ship Line 3 (if present), Ship Line 4 (if present)
City, State ZIP Country