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


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)



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: