Running an update query on a normalized data model

[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…