API HELP

Question

So I am very confused here. I am developing a software to update some of the necessary fields in QuickBase for us, however, I am getting this error. 
Error:

"Can not change the value of the formula field with ID \"17\"."
And as you can see it is stating it can not change the value of a formula field nor will it do a reference field or lookup field. However, with the button we currently utilize within QuickBase this is exactly how we do this. 
Button Code:

Now in QuickBase I only see one type of API call to both insert and update a WO, so is there some way with an external API call I can do this also? 
QuickBase docs:
------------------------------William Hunter------------------------------

MarkShnierYou · Answer

You seem to be asking two different questions and I will try to answer the first one. Indeed you cannot manually nor with an API edit a look up or a formula field. If you want to change the value have a look up field then you need to change the value in the related parent field so that it will pull from a different parent record .

If you look at the code that you posted for what the button does it is not editing a look up fields it is at editing the related parent fields

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

Sign up

Login to the community