How to avoid the #ID in the Lookup Formula

+2

HI,

I have Lookup formula in my form.

It is working fine however the Output has the ID;# Column Value (Image Attached)

This is the formula that i have used.

lookup("Contract Type","ID",TypeofAgreement,"Contract")

How can i get rid of the prefix text the "ID;#"

Thank you in advance

Venkat

+9

Please use parselLookup runtime function to get only ID or text of lookup function:

only text: parseLookup(lookup("Contract Type","ID",TypeofAgreement,"Contract"), True)

only ID: parseLookup(lookup("Contract Type","ID",TypeofAgreement,"Contract"), False)

+2

Bingo that worked.
Thank you for the assistance

Sign up