Forum Discussion

KaranBhavsar's avatar
KaranBhavsar
Qrew Trainee
7 years ago

Can I insert data into text lookup field ?

I want to insert data into a text lookup field using API_EditRecord. Is there anyway this can be achieved? I tried to insert into lookup field but the lookup field remains blank. 

3 Replies

  • You cannot "force" a value in a lookup field or a formula field.

    if you need to override them you will need to create and override field and then have a formula field to resolve which to use, the lookup or the override.
  • I have a field called gate code on my contact record. I have gate code set as a lookup field in another table for service calls. It works great until someone wants to enter a new gate code from the service record. I think I need to add a second gate code field to the service call record and then make then send that to the contact record as a lookup field. then I can create a form rule to show either or both if they are not blank? Will this even work? Am I thinking too much? Is there an easier way?