Other

The Other tab is used for various purposes.

Removing blank paragraphs

Check the box Remove the paragraph this mapping is in when the value is not specified or blank if you want to prevent blank lines from appearing in this mapping.

For instance, this is very useful when dealing with addresses. Typically, addresses are input in address lines, but not every line is always used:

Turning on this setting fixes this:

Check the box Create a hyperlink to render your mapping as a clickable hyperlink. The mapping will still contain whatever is in it, but you can define a URL that it links to when you select it.

Insert the URL you want in the Hyperlink Target text box, or select the button in the text box to insert a field's value for the hyperlink target. You can also use an expression.

You can change what is shown when hovering over the link in the Screentip text box. You can insert a field's value by clicking the button in the text box, or again, use an expression.

If you want to create an e-mail hyperlink, follow these steps:

  1. Create a pseudo-field of type Text.
  2. Give it the value concat('mailto://',${field with link}), where ${field with link} is the field that contains the link.
  3. Then, use this created field as the Hyperlink Target by selecting it from the data set after clicking the button inside the Hyperlink Target text box.

By adding the mailto://, the field is specified to be an e-mail link.

Converting case

Check the box Apply advanced case-convert rules to change the casing of certain letters in a text.

 

The following options are available:

  • Don't change: the text stays as it is.
  • Sentence case: everything is converted to lowercase, except the first letter and every letter following a dot.
  • lowercase: everything is converted to lowercase.
  • UPPERCASE: everything is converted to uppercase.
  • Capitalize Each Word: everything is converted to lowercase except the first letter of each word.
  • tOGGLE cASE: invert the case of each character.