OrgChart Now Help Guide

Concatenate Example

Audience

Audience: Administrators

Overview

Administrators can merge fields and text strings together in order to generate new field values. For example, you can display Department Name and Dept # as one, combined field, rather than two separate ones.

Creating a Concatenate Formula

  1. Sign in to OrgChart.

  2. Click on More > Chart Settings, and then select the Fields & Formulas option from the left side menu.

    5_2_1_CS_FieldsandFormulas_Arrow.png
  3. Click on the green f(x) Create button (in the top left corner) to create a new formula. The Static Formula Editor is displayed.

    5_2_1_CreateFormula_Panel.png
  4. Enter a name for the formula is the Formula Name textbox.

  5. Click on the No values. Click here to add." hyperlink, and then select the Concatenate option from the dropdown menu.

    DeptNameandNumber_Concat.png
  6. Click on the Type dropdown , and then select the Field Lookup option.

    5_2_Concat1.png
  7. Click on the Value dropdown menu, and then select the first field you would like to use.

  8. Click on Add Value button. A Text Type value is added.

  9. Enter ' - ' in the Value text box.

    5_2_ConcatStep2.png
  10. Click on Add Value.

  11. Click on the Type dropdown menu, and then select the Field Lookup option.

  12. Click on the Value dropdown menu, and then select the second field you would like to use.

    5_2_StaticFormula_ConcatEx.png
  13. Click on Save. The formula is displayed in the Chart Settings: Fields and Formulas panel.

  14. Click on Refresh. The formula is now available to add to the Profile, or a Box Style.

    5_2_ConcatInBox.png