Adding Carriage Returns for Certain Migrations

Follow

Introduction

If you are using Migrations such as Text outputs or similar, you may encounter scenarios where you wish or need to have a carriage return.

Step-by-step guide

In order to do this, you will need to configure the following:

  1. Create an Index Field and set the datatype to "Memo". Move this field to the bottom of the list, so it is the last Index Field (In Step 6)
    Image 2015-06-24 at 5.33.05 PM.png
  2. You can also choose to "Hide" this field under "Field Options" so it is not displayed to the user and it cannot be modified as shown above.
  3. Check "Use a Custom Validation Script" and click on the "Edit" button located on the bottom right of the window.
    Image 2015-06-24 at 5.35.19 PM.png 
  4. Launch the script editor, and go to DocumentDataRecordInitialize
  5. Add the following into the script location: dataRecord["newline"].Value = Environment.NewLine + Environment.NewLine;
    Image 2015-06-24 at 5.40.11 PM.png 
  6. Click on "Build & Save" in the upper left corner of the window.
  7. Make sure that the Memo field is the last index field on the Field Settings tab in the Migration you are using.

To recap, the Index Field must be configured as datatype "Memo", and it needs to be the last index field in Step 6. Use the custom validation script, and under Step 9, edit your Migration and ensure that the Field Settings tab has the Index Field as the last field (all other user defined index fields must be above)

If you are still experiencing difficulties, please contact our Support team by:

Table of Contents