Can I insert data into text lookup field ?

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered
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. 
Photo of Karan Bhavsar

Karan Bhavsar

  • 178 Points 100 badge 2x thumb

Posted 12 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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.
Photo of Karan Bhavsar

Karan Bhavsar

  • 178 Points 100 badge 2x thumb
Alright thanks for quick response!
(Edited)
Photo of Ann Swelgin

Ann Swelgin

  • 382 Points 250 badge 2x thumb
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?