Issues to Sync data from a child table to parent table

Thank you in advance for your help and insights about this issue: 
I have a parent table called db_rmas with a column named Manufacturer_Status, and child table called rma_updates referenced to the db_rmas with a column called Update. What I want to achieve is that anytime there is a new row in the child table the data from the column update make copies the same exact update in the Manufacturer_Status Column from parent table. This is what I have done so far but it is not working. 

1. I created an action for the child table (rma_updates) to trigger another action to the referenced row

areyes_0-1716512942857.png

2. Then I created another action to set the values of the referenced child to table to the Manufacturer_status column in the parent Table:

areyes_1-1716513089834.png

FInally I created an automation so that anytime a row is updated from the child table (rma_updates), it may run a data action to run the Referenced action Update RMAs Status previously set in Actions:

areyes_2-1716513404836.png

After doing this, when creating a new record in the child table, the column manufacturer_status doesn't change at all.

If there is another way to do it, I appreacite your suggestions

 

0 3 135
3 REPLIES 3

Should the highlighted part in the bot, the referenced table be set to  db_rmas rather than rma_updates?

Also the referenced action name should be "Set Manufacturer Status from latest Update"?

Suvrutt_Gurjar_0-1716515059605.png

 

 

You're right. I was wrong about that setting, but I changed that and still the row value doesn't sync change to the parent table ๐Ÿ˜ž

Please check what errors if any " Audit History " and " Automation Monitor" are showing when you run the bot.

Top Labels in this Space