Discussions

Expand all | Collapse all

Can I insert data into text lookup field ?

  • 1.  Can I insert data into text lookup field ?

    Posted 12-01-2017 17:28
    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. 


  • 2.  RE: Can I insert data into text lookup field ?

    Posted 12-01-2017 17:47
    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.


  • 3.  RE: Can I insert data into text lookup field ?

    Posted 12-01-2017 17:54
    Alright thanks for quick response!


  • 4.  RE: Can I insert data into text lookup field ?

     
    Posted 07-10-2018 15:07
    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?