Skip to main content
Solved

Update lookup field using typecast?

  • December 11, 2020
  • 2 replies
  • 30 views

Forum|alt.badge.img+10

Is it possible to update the lookup filed on a linked table via the API?

I have a projects table. An a people table.
O the projects table I have a lookup field that grabs the first name from the people table.

Using the API, would I be able to change the name by simply updating the lookup field on the projects table?

Thank you!

Best answer by Erin_OHern

Hi Gustavo!

This isn’t possible, since a lookup field is a computed field – its value can’t be modified directly. You will instead want to update the Name value in the People table directly, and that change will be reflected in the Lookup field in your Projects table.

I hope this helps!

2 replies

  • Participating Frequently
  • 28 replies
  • Answer
  • December 16, 2020

Hi Gustavo!

This isn’t possible, since a lookup field is a computed field – its value can’t be modified directly. You will instead want to update the Name value in the People table directly, and that change will be reflected in the Lookup field in your Projects table.

I hope this helps!


Forum|alt.badge.img+10
  • Author
  • Known Participant
  • 29 replies
  • December 16, 2020

Hi Gustavo!

This isn’t possible, since a lookup field is a computed field – its value can’t be modified directly. You will instead want to update the Name value in the People table directly, and that change will be reflected in the Lookup field in your Projects table.

I hope this helps!


Thank you @Erin_OHern! That makes sense.