How to avoid the #ID in the Lookup Formula

  • 18 November 2020
  • 2 replies
  • 4 views

Badge +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


2 replies

Badge +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)

Badge +2
Bingo that worked.
Thank you for the assistance

Reply