I know this should not be very hard, but for some reason I seem to be having a real problem. My users would like me to remove a few fields from a form but before removing them, to take their data and append them at the end of another field. I have tried several variations of the formula:
FIELD fulldescr := @If(@IsAvailable(remarks);fulldescr + @NewLine + remarks;fulldescr);
I also tried it with @Char(10) and @Char(13). Both @Char commands put some special characters between the two strings when I look at the document properties. But it wouldn’t actually put a blank line when viewing. @Newline creates the following error text in the field:
Incorrect data type for operator or @Function: Number expected
Can anybody tell me what I’m doing wrong?
Thanks,
Jackie
Subject: Merging 2+ fields with formula
removing fields from a form does not remove the data - it just prevents it from being displayed
if a form had field1 and field2 and field3 and there was data in all, then simply by removing the design element doesn’t erase the data:
fieldnew that has a formula of (field1 : field2 : field3) would still show all data in the fields
Subject: RE: Merging 2+ fields with formula
I already knew that the data would still be there, but I guess I was just having one of those moments trying to figure out what to do about it. Along the lines of your suggestions, I created a computed field below the existing field. I’m stringing the data into the computed field and that works perfectly. Thanks! 
Subject: Merging 2+ fields with formula
Try:
FIELD fulldescr := @Trim(fulldescr : remarks);
Then set fulldescr to be a multi-value field with Newline as separator.