I need to concatenate two Text fields (Name and Address) with the result placed in a resultant virtual Long Text field (Full Address).
But I need a CR Newline character in between so the resultant virtual Long Text field (Full address) has the text on two lines.
Concatenate is easy but placing on two lines is still a secret to me.
In Excel it would be Chr (20) if I recall but in appsheet???
Bill Smith 123 First Street