Skip to main content
Search Again

We think these articles could help you:

    See More

    ALERT: This site will be decommissioned at the end of December 2018. All existing and new Nintex knowledge content will be available within the new Knowledge Base area of the Nintex Community site. 

    Nintex Knowledge Base

    How to Parse value of a lookup control in a calculated Column

    Status: Validated

    TOPIC
    If you attempt to pass the value returned in form lookUp Control to a calculated field the value will contain the item ID a semi colon and a pound sign Example 10;#r (r is the actual value)
    INSTRUCTIONS
    Use a runtime function in the calculated field Formula:
    The easiest way is to use parseLookup()
    Example: parseLookup(NamedControl) This will remove all but value
     
    ADDITIONAL INFORMATION
    RELATED LINKS