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

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
 

 

Related Links

 

Version history
Revision #:
73 of 73
Last update:
‎11-13-2020 09:18 PM
Updated by:
 
Contributors