Skip to main content
Question

Formula URL to Add Records with a Reference Proxy Field

  • February 17, 2023
  • 0 replies
  • 221 views

Forum|alt.badge.img+9

I have a table with lookup fields to related tables. Only one lookup field is required to be populated when adding a record, and that field has a drop down menu made up of a report link to a related table. I can api_addrecord to actually populate the necessary fields except, when I look at the new record, the lookup field is blank and the related fields didn't populate. When I choose to edit the record, the lookup fields immediately populate but I still have to select the drop down value.

Is it possible to make a formula url that will lead to the lookup fields being populated after the call? Also, how do I populate the lookup field with the formul url? Is it even possible?



------------------------------
James Carr
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

The reference field on the right side of the relationship needs to be populated by the API with the value of the key field of the parent record.  Then all the lookup fields will populate.



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------