Hello,

I would like to be able to populate a multi-line field with values from other fields, separated by a new line, i.e. linefeed character, preferably by using a Formula (or Default Value if possible). I've tried the standard spreadsheet formulas, e.g. "=string & CHAR(10) & string " , or "=CONCATENATE(string, CHAR(10), string), but am having no luck. For what it's worth, I've had similar problems in past attempts to concatenate a space either as a string or via the CHAR() formula, eventually opting to create another column in my SQL view with the concatenated string.

I know there will be both JS and SQL workarounds -- I've essentially gotten the SQL method working with a "CONCAT(string, CHAR(10), string)" type approach -- but being able to use the Formula method would be much less cumbersome, so if this is possible and I'm missing something, I'd appreciate the information.

Thanks,

Jesse