Exporing Retool for one day now i found this solution for updating a record of a table based on a query on de the Retool db. However i have normalized data model hence the update value needs to be collected first in another table to update the foreign key correctly. Any suggestions on how to do that?
If i understand correctly i can use additionalScope to add data to the changesetArray. And update multiple values to the database. That's great! Will give that a try.
One question that rises: is there a way to avoid the default save button after a cell change and use component to trigger the batch update??