Running an update query on a normalized data model

[shiftd]

Hi,

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?

Thanks in advance

[Little_Big_Apple]

I'm newbie here, but it sounds like some Javascript Transformers, to transform the data before running the DB query, would do the trick for you.

[AnsonHwang]

Hello, pls check this topic. Hope can some help.

Running extra data UPDATE via "save actions"

[image] By the way, though the Run script is before batchInserData.trigger. but it may run after that. So for more confidence result. You better to run only one script in the save action event handlers. using additionalScope to pass the rearranged changesetArray (which with extra data as you said ) to the query. Here is my full solution.(this time we don't need variable of tempState) [image] batchInsertData.trigger({ additionalScope:{ changesetArr: [...table1.changesetArray.m…

[shiftd]

Thanks for the suggestion. Will look into that.

[shiftd]

Hi Anson,

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??

Thanks again!

[Kabirdas]

Hey @shiftd! Not sure if you were able to get this resolved but if you're referring to this modal:

It can be removed by deleting the save action from your table:

If you're triggering the bulk update and refresh query from a separate component you should be fine without it!

[shiftd]

Hi Kabirdas,

Actually my use case changed a bit and the data source changed to a REST service.
Thanks for pointing this out though... Will keep it in mind in future explorations.