venkatch
Forms Fledgling

How to avoid the #ID in the Lookup Formula

Jump to solution

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

0 Kudos
Reply
2 Replies
mlauer
Connector Crackerjack

Re: How to avoid the #ID in the Lookup Formula

Jump to solution

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)

View solution in original post

Reply
venkatch
Forms Fledgling

Re: How to avoid the #ID in the Lookup Formula

Jump to solution
Bingo that worked.
Thank you for the assistance
0 Kudos
Reply