0

How can I add a linefeed to a text field?

I have been attempting to combine several notes fields when importing data and I am unable to find a way to insert them into the text field as multiple lines.  I have tried using "\n", \n, '\n', LF, CRLF. None of these work. Any ideas?

2 replies

null
    • Mel_Charles
    • 2 yrs ago
    • Reported - view

    Tom

    try line feed Char(10)

    • Mel_Charles
    • 2 yrs ago
    • Reported - view

    Otherwise - if you are regulary intending to import the same csv data. You could leave the orginal fields on the form (say tucked out of the way on another form tab)

    and do 1 of 2 things

    1) add a formula field (mergedText) then add a script to that formula filed 'notefield1' + "

    " + 'notefield2' + "
    " + 'notefield3' + " etc (see image and remember to press return key on each line (as shown)

    2) Or Create a text field (mergetextfield) for the merged data and add a button with  the script such as. mergetextfield := 'notefield1' + "chr(10)" + 'notefield2' + "chr(10)" + etc etc

    Screenshot 2021-06-07 at 14.47.46

    change above field names for yours

Login to reply

Content aside

  • 2 yrs agoLast active
  • 2Replies
  • 328Views