Friday, April 26, 2019

Concatenate three fields and have additional custom prefix

Item labelling might include separate fields shown on an item record, thus, concatenation may be necessary including a prefix customized as needed.

To concatenate 3 fields and include a custom prefix on the results of a saved search, do the following:

1. Navigate to List > Search > Saved Searches > New.

2. Select any search type. (this example selects Item)

3. Navigate to the Results subtab and add the field "Formula (Text)"

4. Enter the following as the value of the Formula:

    Concat('custom label', concat(' ', Concat({field1}, concat(concat(' ', {field2}), concat(' ', {field3})))))

For Example:

    Concat('OO', concat(' ', Concat({internalid}, concat(concat(' ', {type}), concat(' ', {name})))))


    Custom Label = 00
    Internal Id = 123
    Item Type = Inventory Item 
    Item Name = Widgets

Hence, the results will be:

    00 123 Inventory Item Widgets

No comments:

Post a Comment